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)