a

Tables (4)

BOOKINFO (제품)

  • Key (bookcode) — int — Primary key — NOT NULL
  • Field2 (price) — int
  • Field (bookName) — string
  • Field (bookInfo) — string

CARDINFO (카드 정보)

  • Key (id) — int — Foreign key → USER.Key — NOT NULL
  • Key (cardNum) — int — Foreign key → USER.Key — NOT NULL
  • Field (cardInfo) — string

ORDER (주문)

  • Key (id) — int — Foreign key → CARDINFO.Key — NOT NULL
  • Key (cardNum) — int — Foreign key → CARDINFO.Key — NOT NULL
  • Field (orderDay) — string
  • Field2 (day) — string
  • Field3 (address) — string
  • Field4 (allPrice) — int
  • Key (bookcode) — int — Foreign key → BOOKINFO.Key — NOT NULL

USER (사용자 정보)

  • Key (id) — int — Primary key — NOT NULL
  • Key (cardNum) — int — Primary key — NOT NULL
  • Field (name) — text
  • Field (phone) — text
  • Field (email) — text