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