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