11-29
Tables (4)
BOOK
- BOOK_NO (도서식별자) — VARCHAR2(50) — Primary key — NOT NULL
- GENRE — VARCHAR2(50)
- TITLE — VARCHAR2(50)
- AUTHOR — VARCHAR2(50)
- PUBLISHER — VARCHAR2(50)
- PRICE — VARCHAR2(50) — NOT NULL
MEMBER
- MEMBER_NO (회원번호) — VARCHAR2(50)DEFAULT — Primary key
- NAME (이름) — VARCHAR2(50) — NOT NULL
- PHONE (전화번호) — VARCHAR2(50) — NOT NULL
ORDER
- ORDER_NO (주문번호) — VARCHAR2(50) — Primary key
- SALE_NO — VARCHAR2(50) — Foreign key → SALE_LIST.SALE_NO
- BOOK_NO (도서식별자) — VARCHAR2(50) — Foreign key → SALE_LIST.BOOK_NO — NOT NULL
- MEMBER_NO (회원번호) — VARCHAR2(50)DEFAULT — Foreign key → SALE_LIST.MEMBER_NO
SALE_LIST
- SALE_NO (판매번호) — VARCHAR2(50) — Primary key
- BOOK_NO (도서식별자) — VARCHAR2(50) — Foreign key → BOOK.BOOK_NO — NOT NULL
- MEMBER_NO (회원번호) — VARCHAR2(50)DEFAULT — Foreign key → MEMBER.MEMBER_NO
- SALEDATE (판매일자) — DATE