123

테이블 (5)

대여 (LOAN)

  • LoanID (PK) — INT
  • LoanDate (Field) — DATE
  • ReturnDAte (Field2) — DATE
  • OverdueStatus (Field3) — BOOLEAN
  • UserID (fk) — INT
  • ISBN (FK2) — CHAR(13)

서적 (BOOK)

  • ISBN (PK) — CHAR(13)
  • TITLE (Field) — VARCHAR(100)
  • PUBLISHYEAR (Field2) — YEAR
  • PRICE (Field3) — DECIMAL(10,2)
  • AuthorID (FK) — INT
  • PublisherID (FK2) — INT

저자 (AUTHOR)

  • Field (PK) — INT
  • NAME (Field) — VARCHAR(50)
  • BIRTHDATE (Field2) — DATE
  • NATIONALITY (Field3) — VARCHAR(30)

출판사 (Publisher)

  • PublisherID (PK) — INT
  • NAME (Field) — VARCHAR(50)
  • LOCATION (Field2) — VARCHAR(100)
  • contact (Field3) — VARCHAR(15)

회원 (user)

  • UESRID (PK) — INT — 기본 키
  • NAME (Field) — VARCHAR(50)
  • JOINDATE (Field2) — DATE
  • ADDRESS (Field3) — VARCHAR(100)