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