ERD 프로토타입 1

테이블 (11)

Untitled (회원)

  • Key (member_id) — NOT NULL — 기본 키 — NOT NULL
  • 주문 (orders) — NULL — imbedded
  • Field (wishlist) — NULL
  • Field (cart) — NULL
  • Field2 (inquiry) — NULL
  • Field (photo) — NULL
  • Field (user_id) — NOT NULL
  • Field (password) — NOT NULL
  • Field (email) — NOT NULL
  • Field (name) — NOT NULL
  • Field2 (phone_num) — NOT NULL
  • Field (address) — NOT NULL
  • Field (point) — NOT NULL

Untitled (주문)

  • Key (order_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (order_detail) — NOT NULL
  • Field (delivery_detail) — NOT NULL
  • Field (payment) — NOT NULL
  • Field (point) — NULL
  • Field (total_price) — NOT NULL

Untitled (위시리스트)

  • Key (wishlist_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (items) — NULL

Untitled (장바구니)

  • Key (cart_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (total_price) — NOT NULL

Untitled (1:1문의)

  • Key (inquiry_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (reply) — NULL
  • Field (title) — NOT NULL
  • Field (content) — NOT NULL
  • Field (write_date) — NOT NULL
  • Field (update_date) — NOT NULL

Untitled (주문상세)

  • Key (order_detail_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (item_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (cart_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (member_id2) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (category_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (item_quantity) — NOT NULL
  • Field (total_price) — NOT NULL
  • Field (size) — NOT NULL

Untitled (상품)

  • Key (item_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (category_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — NOT NULL
  • Field (main_photo) — NULL
  • Field (price) — NOT NULL
  • Field (stock_quantity) — NOT NULL
  • Field (item_detail) — NULL
  • Field (reviews) — NULL
  • Field (delivery_price) — NOT NULL
  • Field (size) — NOT NULL
  • Field (category) — NULL

Untitled (상품 상세)

  • Key (item_detail_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (item_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (category_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (material) — NULL
  • Field (detail_photo) — NULL
  • Field (detail_name) — NULL
  • Field (comment) — NULL
  • Field (made_in) — NULL
  • Field (max_quantity) — NULL

Untitled (구매평)

  • Key (review_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (item_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (category_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (writer) — NOT NULL
  • Field (content) — NULL
  • Field (write_date) — NOT NULL
  • Field (update_date) — NOT NULL
  • Field (photo) — NULL

Untitled (배송 상세)

  • Key (delivery_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (order_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (receiver) — NOT NULL
  • Field (phone_number) — NOT NULL
  • Field (address) — NOT NULL
  • Field (memo) — NULL

Untitled (카테고리)

  • Key (category_id) — NOT NULL — 기본 키 — NOT NULL
  • Field (name) — NOT NULL