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