취업준비반 1
테이블 (4)
member (Untitled)
- member_id (Key) — 기본 키 — NOT NULL
- password (Field)
- name (Field2)
- phone (Field3)
- address (Field4)
- admin (Field5)
order_information (Untitled4)
- product_id (Key3) — 외래 키 → product.product_id — NOT NULL
- order_id (Key) — 외래 키 → order_list.order_id — NOT NULL
- quantity (Field)
order_list (Untitled2)
- order_id (Key) — 기본 키 — NOT NULL
- member_id (Key2) — 외래 키 → member.member_id — NOT NULL
- name (Field2)
- order_date (Field3)
- total_cost (Field4)
product (Untitled3)
- product_id (Key) — 기본 키 — NOT NULL
- company (Field)
- item_name (Field2)
- item_describe (Field3)
- size (Field4)
- color (Field5)
- image (Field6)
- price (Field7)
- category (Field8)