board
Tables (3)
Book (book)
- 책아이디 (bookid) — INT — Primary key — NOT NULL
- 책이름 (bookname) — VARCHAR(40)
- 책정보 (publisher) — VARCHAR(40)
- 책가격 (price) — INT
- Field
- 아이디 (orderid) — INT — Foreign key → Orders.아이디 — NOT NULL
Customer (customer)
- 커스텀아이디 (custid) — INT — Primary key — NOT NULL
- 커스텀이름 (name) — VARCHAR(40)
- 커스텀주소 (address) — VARCHAR(50)
- 커스텀폰 (phone) — VARCHAR(20)
- Field
Orders (orders)
- 아이디 (orderid) — INT — Primary key — NOT NULL
- 커스텀아이디 (custid) — INT
- 책아이디 (bookid) — INT
- 세일가격 (saleprice) — INT
- 날짜 (orderdate) — date
- Field
- 커스텀아이디 (custid2) — INT — Foreign key → Customer.커스텀아이디 — NOT NULL
- 책아이디 (bookid2) — INT — Foreign key → Book.책아이디 — NOT NULL