11-21T EST

Tables (3)

BOOK

  • Key (BOOK_NO) — CHAR(11) — Primary key — NOT NULL
  • Field (BOOK_NAME) — VARCHAR2(50)
  • Field (BOOK_WRITER) — VARCHAR2(30)
  • Field (BOOK_MAKER) — VARCHAR2(30)

Untitled (BOOK_MEMBER)

  • Key (MEMBER_ID) — CHAR(6) — Primary key — NOT NULL
  • Field (MEMBER_PW) — CHAR(6)
  • Field (MEMBER_NAME) — VARCHAR2(30)
  • Field (MEMBER_TEL) — CHAR(11) — NOT NULL
  • Field (MEMBER_BIRTH) — DATE — NOT NULL

Untitled (BOOK_BORROW)

  • Key (MEMBER_ID) — CHAR(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (BOOK_NO) — CHAR(11) — Foreign key → BOOK.Key — NOT NULL
  • Field (BOOK_BORROW_DATE) — DATE
  • Field (BOOK_TO_BE_RETURN_DATE) — DATE
  • Field (BOOK_RETURN_FINISH_DATE) — DATE