products
Tables (10)
brand (Untitled6)
- id — Primary key — NOT NULL
- brand_code
- url
- brand_type
- reg_date
brand_property (Untitled10)
- id — Primary key — NOT NULL
- brand_id — Foreign key → brand.id — NOT NULL
- brand_name
- brand_description
- brand_country
- brand_hq
- language_code
category (Untitled2)
- id — Primary key — NOT NULL
- parent_id
- property
- depth
category_property (Untitled11)
- id — Primary key — NOT NULL
- category_id — Foreign key → category.id — NOT NULL
- category_name
- language_code
option (Untitled12)
- id — Primary key — NOT NULL
- product_id — Foreign key → products.id — NOT NULL
- option_type
- option_value
- language_code
product_images (Untitled4)
- id — Primary key — NOT NULL
- product_id — Foreign key → products.id — NOT NULL
- src
- type
- size
- width
- height
- format
product_price (Untitled8)
- id — Primary key — NOT NULL
- product_id — Foreign key → products.id — NOT NULL
- currency
- price
product_property (Untitled9)
- id — Primary key — NOT NULL
- product_id — Foreign key → products.id — NOT NULL
- product_name
- description
- url
- language_code
product_tags (Untitled5)
- id — Primary key — NOT NULL
- product_id — Foreign key → products.id — NOT NULL
- tag
products (Untitled)
- id — Primary key — NOT NULL
- brand_id — Foreign key → brand.id — NOT NULL
- category_id — Foreign key → category.id — NOT NULL
- name
- type
- sku
- status
- weight
- length
- width
- height
- hs_code
- discontinued
- outlet
- launch_date
- reg_date
- mod_date