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