a

Tables (15)

brand

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(150) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

bundle_sku_config (bundle_product_config)

  • sku_id — BIGINT — Foreign key → sku.id — NOT NULL
  • pricing_policy — VARCHAR(40) — NOT NULL
  • stock_policy — VARCHAR(40) — NOT NULL

bundle_slot

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • min_select_count — INT — NOT NULL
  • max_select_count — INT — NOT NULL
  • display_order — INT — NOT NULL
  • id (id2) — BIGINT — Foreign key → bundle_sku_config.sku_id — NOT NULL

bundle_slot_choice

  • id — BIGINT — Primary key — NOT NULL
  • bundle_slot_id — BIGINT — Foreign key → bundle_slot.id — NOT NULL
  • component_sku_id — BIGINT — Foreign key → sku.id — NOT NULL
  • min_quantity — INT — NOT NULL
  • max_quantity — INT — NOT NULL
  • default_quantity — INT — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • price_delta — DECIMAL(15, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • display_order — INT — NOT NULL
  • id (id2) — BIGINT — Foreign key → bundle_slot.id — NOT NULL

category

  • id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → category.id
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(150) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inventory

  • sku_id — BIGINT — Foreign key → sku.id — NOT NULL
  • on_hand_quantity — INT — NOT NULL
  • reserved_quantity — INT — NOT NULL
  • safety_stock_quantity — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

option_group

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

option_value

  • id — BIGINT — Primary key — NOT NULL
  • option_group_id — BIGINT — Foreign key → option_group.id — NOT NULL
  • value — VARCHAR(100) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.id — NOT NULL
  • brand_id — BIGINT — Foreign key → brand.id
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_media

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • media_type — VARCHAR(20) — NOT NULL
  • url — VARCHAR(1000) — NOT NULL
  • alt_text — VARCHAR(300)
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

product_option_group

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • option_group_id — BIGINT — Foreign key → option_group.id — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • display_order — INT — NOT NULL

product_option_value

  • id — BIGINT — Primary key — NOT NULL
  • product_option_group_id — BIGINT — Foreign key → product_option_group.id — NOT NULL
  • option_value_id — BIGINT — Foreign key → option_value.id — NOT NULL
  • display_name — VARCHAR(100)
  • display_order — INT — NOT NULL

product_spec

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • value — VARCHAR(500) — NOT NULL
  • unit — VARCHAR(30)
  • display_order — INT — NOT NULL

sku

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • sku_code — VARCHAR(100) — NOT NULL
  • list_price — DECIMAL(15, 2) — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

sku_option_value

  • sku_id — BIGINT — Foreign key → sku.id — NOT NULL
  • product_option_group_id — BIGINT — Foreign key → product_option_value.product_option_group_id — NOT NULL
  • product_option_value_id — BIGINT — Foreign key → product_option_value.id — NOT NULL