쇼핑몰 ERD
테이블 (8)
Delivery (Untitled7)
- delivery_id (Key) — bigint — 기본 키 — NOT NULL
- order_id (Field) — varchar2(20)
- recipient_name (Field2) — varchar2(20)
- recipient_phone (Field3) — varchar2(20)
- zipcode (Field4) — varchar2(20)
- address_detail (Field5) — varchar2(50)
- Field6
Member (Untitled2)
- id (Key) — varchar(20) — 기본 키 — NOT NULL
- password (Field2) — bigint
- name (Field3) — varchar2(10)
- birthday (Field4) — varchar2(10)
- phonenumber (Field5) — varchar2(20)
- skin_type (Field6) — varchar2(20)
- skin_troble (Field) — varchar2(20)
- created_at (Field7) — date
Order (Untitled6)
- order_ID (Key) — varchar2(20) — 기본 키 — NOT NULL
- member_id (Key2) — varchar2(20) — 기본 키 — NOT NULL
- order_status (Field) — varchar2(10)
- total_price (Field2) — varchar2(20)
- ordered_at (Field3) — date
- Field4
- Field5
Payment (Untitled4)
- Key — 기본 키 — NOT NULL
- orderName (Field) — varchar2(20)
- Field2
- Field3
- Field4
Review (Untitled8)
- review_id (Key) — varchar2(20) — 기본 키 — NOT NULL
- product_id (Field) — varchar2(20)
- member_id (Field2) — varchar2(20)
- rating (Field3) — bigint
- content (Field4) — varchar2(500)
- created_at (Field5) — date
ShoppingCart (Untitled3)
- id (Key) — varchar2(20) — 기본 키 — NOT NULL
- product_id (Field) — varchar2(20)
- price (Field2) — varchar2(20)
- sale_price (Field3) — varchar2(20)
- delivery_information (Field4) — varchar2(50)
product (Untitled5)
- product_id (Key) — varchar2(20) — 기본 키 — NOT NULL
- product_name (Field) — varchar2(20)
- price (Field2) — varchar2(20)
- sale_price (Field3) — varchar2(20)
- Field4