w
Tables (6)
option (옵션)
- 옵션아이디 (option_id) — BIGINT — Primary key — NOT NULL
- 옵션이름 (option_name) — VARCHAR
- 옵션아이디 (option_id2) — BIGINT
option_list (옵션리스트)
- 옵션리스트아이디 (option_list_id) — INT — Primary key — NOT NULL
- 옵션리스트이름 (Field)
- 옵션아이디 (option_id) — BIGINT
- 상품아이디 (product_id) — BIGINT — Foreign key → product.상품아이디 — NOT NULL
- 옵션아이디 (option_id2) — BIGINT — Foreign key → option.옵션아이디 — NOT NULL
product (상품)
- 상품아이디 (product_id) — BIGINT — Primary key — NOT NULL
- 상품이름 (product_name) — VARCHAR
- 상품가격 (product_price) — INT
- 상품코드 (product_code) — VARCHAR
- 상품상세 (product_des) — VARCHAR
product_list (Untitled4)
- Key (id) — BIGINT — Primary key — NOT NULL
- 상품아이디 (product_id) — BIGINT
- 옵션리스트아이디 (option_list_id) — INT
- Field
product_option_list (옵션별 상품관리)
- id (Key) — Primary key — NOT NULL
- Field
- 옵션리스트아이디 (option_list_id) — INT — Foreign key → option_list.옵션리스트아이디 — NOT NULL