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