kh

Tables (3)

Book

  • bookid (도서id) — INT — Primary key — NOT NULL
  • bookname (도서이름) — VARCHAR(100)
  • publisher (출판사) — VARCHAR(50)
  • price (도서가격) — INT

Customer

  • custid (고객id) — INT — Primary key — NOT NULL
  • name (고객이름) — VARCHAR(50)
  • address (고객주소) — VARCHAR(200)
  • phone (고객연락처) — VARCHAR(20)

Orders

  • orderid (주문id) — INT — Primary key — NOT NULL
  • custid (고객id) — INT — Foreign key → Customer.custid — NOT NULL
  • bookid (도서id) — INT — Foreign key → Book.bookid — NOT NULL
  • orderdate (주문날짜) — DATE
  • saleprice (주문금액) — INT