[23'2학기-sql 프로그래밍 과제] 쇼핑몰 db 구축
테이블 (4)
Delivery (Untitled4)
- delivery_id (Key) — 기본 키 — NOT NULL
- departure_date (Field)
- arrival_date (Field2)
- delivery_address (Field3)
- order_id (Key2) — Auto increment — 외래 키 → Orders.order_id — NOT NULL
Member (Untitled)
- member_id (Key) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- birthdate (Field3) — NOT NULL
- phone (Field4)
- email (Field6)
- password (Field7)
- sex (Field8)
- signup_date (Field5)
- modify_date (Field9)
Orders (Untitled2)
- order_id (Key) — Auto increment — 기본 키 — NOT NULL
- delivery_address (Field2)
- order_date (Field3)
- order_phone (Field)
- order_name (Field5)
- quantity (Field4)
- order_modify_date (Field6)
- member_id (Key3) — 외래 키 → Member.member_id — NOT NULL
- product_id (Key2) — 외래 키 → Product.product_id — NOT NULL
Product (Untitled3)
- product_id (Key) — 기본 키 — NOT NULL
- name (Field)
- price (Field2)
- color (Field3)
- quantity (Field4)
- size (Field5)