SSG_PRODUCT
Tables (5)
color (색상)
- Key — Primary key — NOT NULL
option (기타옵션)
- Key — Primary key — NOT NULL
product_option_ and_stock (옵션 관리)
- Key4 (product_option_ and_stock_id) — Primary key — NOT NULL
- 상품아이디 (product_id) — BIGINT — Foreign key → ssg_product.상품아이디 — NOT NULL
- Key — Foreign key → size.Key — NOT NULL
- Key (Key2) — Foreign key → color.Key — NOT NULL
- Key (Key3) — Foreign key → option.Key — NOT NULL
- 재고 (Field)
size (사이즈)
- Key — Primary key — NOT NULL
ssg_product (상품 정보)
- 상품아이디 (product_id) — BIGINT — Primary key — NOT NULL
- 상품이름 (product_name) — VARCHAR(255)
- 상품가격 (product_price) — INT
- 상품코드 (product_code) — VARCHAR(255)
- 상품상세설명 (product_explanation) — VARCHAR(255)