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