미니 쇼핑몰
테이블 (7)
cart (Untitled6)
- id (Key2) — 기본 키 — NOT NULL
- member_id (Key) — 외래 키 → member.id — NOT NULL
- created_by (Field)
- reg_time (Field2)
- modified_by (Field3)
- update_time (Field4)
cart_item (Untitled7)
- cart_item_id (Key) — 기본 키 — NOT NULL
- cart_id (Key2) — 외래 키 → cart.id — NOT NULL
- item_id (Key3) — 외래 키 → item.id — NOT NULL
- count (Field)
- created_by (Field2)
- reg_time (Field3)
- modified_by (Field4)
- update_time (Field5)
item (Untitled4)
- id (Key) — 기본 키 — NOT NULL
- item_nm (Field)
- price (Field2)
- item_detail (Field3)
- item_sell_status (Field4)
- created_by (Field5)
- reg_time (Field6)
- modified_by (Field7)
- update_time (Field8)
item_img (Untitled5)
- item_img_id (Key) — 기본 키 — NOT NULL
- item_id (Key2) — 외래 키 → item.id — NOT NULL
- item_name (Field)
- ori_img_name (Field2)
- img_url (Field3)
- rep_img_yn (Field4)
- created_by (Field5)
- reg_time (Field6)
- modified_by (Field7)
- update_time (Field8)
member (Untitled)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
- email (Field2)
- password (Field3)
- address (Field4)
- role (Field5)
- created_by (Field6)
- reg_time (Field7)
- modified_by (Field8)
- update_time (Field9)
order (Untitled2)
- id (Key) — 기본 키 — NOT NULL
- member_id (Key2) — 외래 키 → member.id — NOT NULL
- order_date (Field)
- order_state (Field2)
- created_by (Field3)
- reg_time (Field4)
- modified_by (Field5)
- update_time (Field6)
order_item (Untitled3)
- id (Key2) — 기본 키 — NOT NULL
- order_id (Key) — 외래 키 → order.id — NOT NULL
- item_id (Key3) — 외래 키 → item.id — NOT NULL
- order_price (Field)
- count (Field2)
- created_by (Field3)
- reg_time (Field4)
- modified_by (Field5)
- update_time (Field6)