Test1

Tables (3)

Book

  • book_id (Key) — Primary key — NOT NULL
  • bookname — varchar — NOT NULL — 책이름

Customer

  • custid — int — Primary key
  • name — varchar — NOT NULL — 고객이름

Orders

  • orderid — int — Primary key — NOT NULL — 주문번호
  • custid
  • bookid — int
  • custid (custid2) — int — Foreign key → Customer.custid
  • book_id (Key) — Foreign key → Book.book_id — NOT NULL