test1

Tables (3)

Book

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

Customer

  • custid — 고객번호
  • custid (Field)

Orders

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