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