libary
Tables (5)
BOOK (책)
- BOOK_ID (Key) — varchar2 — Primary key — NOT NULL
- BOOK_NAME (Field) — varchar2
- BOOK_PUB (Field2) — varchar2
MEMBER (회원)
- MEM_ID (Key) — varchar2 — Primary key — NOT NULL
- MEM_NAME (Field) — varchar2
- MEM_ADDR (Field2) — varchar2
- MEM_NUM (Field3) — varchar2
RENTAL (대여)
- LOAN_ID (Key) — varchar2 — Primary key — NOT NULL
- LOAN_DATE (Field2) — date
- MEM_ID (Key3) — varchar2 — Foreign key → MEMBER.MEM_ID — NOT NULL
- BOOK_ID (Key4) — varchar2 — Foreign key → BOOK.BOOK_ID — NOT NULL
RETURN (반납)
- RETURN_ID (Key) — varchar2 — Primary key — NOT NULL
- RETURN_DATE (Field2) — date
- MEM_ID (Key3) — varchar2 — Foreign key → MEMBER.MEM_ID — NOT NULL
- BOOK_ID (Key4) — varchar2 — Foreign key → BOOK.BOOK_ID — NOT NULL
USER (회원가입)
- Key — Primary key — NOT NULL