test
Tables (6)
BOOK (Untitled3)
- 저자 (author) — varchar
- isbn — varchar
Delivery (Untitled6)
- 배송ID (delivery_id) — int — Primary key — NOT NULL
- 배송상태 (status) — ready, comp
- 주소-도시 (city) — varchar
- 주소-도로명 (street) — varchar
- 주소-우편번호 (zipcode)
ITEM (Untitled2)
- 아이템ID (item_id) — int — Primary key — NOT NULL
- 상품명 (name) — varchar
- 가격 (price) — int
- 재고 (stock_quantity) — int
MEMBER (Untitled)
- 회원ID (member_id) — int — Primary key — NOT NULL
- 회원이름 (name) — varchar
- 이메일 (email) — varchar
- 비밀번호 (password) — varchar
- 주소-도시 (city) — varchar
- 주소-도로명 (street) — varchar
- 주소-우편번호 (zipcode) — varchar
ORDER (Untitled4)
- 주문ID (order_id) — int — Primary key — NOT NULL
- 회원ID (member_id) — int — Foreign key → MEMBER.회원ID — NOT NULL
- 배송ID (delivery_id) — int — Foreign key → Delivery.배송ID — NOT NULL
- 주문날짜 (order_date) — datetime
- 주문상태 (status) — order,cancel
ORDER_ITEM (Untitled5)
- 주문상품ID (order_item_id) — int — Primary key — NOT NULL
- 주문ID (order_id) — int — Foreign key → ORDER.주문ID — NOT NULL
- 회원ID (member_id) — int — Foreign key → ORDER.회원ID — NOT NULL
- 배송ID (delivery_id) — int — Foreign key → ORDER.배송ID — NOT NULL
- 아이템ID (item_id2) — int — Foreign key → ITEM.아이템ID — NOT NULL
- 주문가격 (order_price) — int
- 주문수량 (count) — int