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