쇼핑몰 설계
테이블 (6)
customers (Untitled)
- customer_id — INT — 기본 키 — NOT NULL
- name — varchar(10)
- email — varchar(30)
- phone — varchar(20)
- address — varchar(40)
- gender — varchar(1)
inquiries (Untitled6)
- inquiry_id — INT(PK) — 기본 키 — NOT NULL
- customer_id (customer_id2) — INT(FK) — 외래 키 → customers.customer_id — NOT NULL
- product_id — INT(FK) — 외래 키 → products.product_id — NOT NULL
- title — varchar(100)
- content — TEXT
- created_at — DATETIME
- answer_at — DATETIME
orders (Untitled3)
- order_id — INT(PK) — 기본 키 — NOT NULL
- customer_id — INT(FK) — 외래 키 → customers.customer_id — NOT NULL
- payment_id (payment_id2) — INT(FK) — 외래 키 → payments.payment_id — NOT NULL
- order_date — datetime
- total_price — INT
- memo — TEXT
payments (Untitled4)
- payment_id — INT(PK) — 기본 키 — NOT NULL
- amount — INT
- patment_date (payment_date) — DATETIME
products (Untitled2)
- product_id — INT — 기본 키 — NOT NULL
- name — varchar(100)
- price — INT
- stock — INT
shipments (Untitled5)
- shipment_id — INT(PK) — 기본 키 — NOT NULL
- order_id — INT(FK) — 외래 키 → orders.order_id — NOT NULL
- address — varchar(50)
- recipient_name — varchar(10)
- recipient_phone — varchar(20)
- shipped_date — DATETIME