title
테이블 (3)
상품 (Untitled2)
- id (PK) — int — 기본 키 — NOT NULL
- name (P_name) — char
- price (P_price) — int
- stock (P_stock) — int
주문 (Untitled3)
- id (order_id) — int — 기본 키 — NOT NULL
- client_id — int — 외래 키 → 회원.id — NOT NULL
- product_id (PK) — int — 외래 키 → 상품.id — NOT NULL
- date (order_date) — int
- quantity — int
회원 (client_number)
- id (client_id) — int — 기본 키 — NOT NULL
- name (client_name) — char
- email (client_emali) — char
- phone (client_phone) — int