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