Product

Tables (3)

Product (product)

  • id (pk) — BINGINT — Primary key — NOT NULL
  • sku — VARCHAR
  • product_type — ENUM
  • platform — ENUM
  • amount — INT
  • is_enabled — BOOL
  • name — VARCHAR
  • desc — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

Product Descriptions (product_desc)

  • id (pk) — BINGINT — Primary key — NOT NULL
  • product_id — BINGINT — Foreign key → Product.id — NOT NULL
  • country_cd — VARCHAR
  • name — VARCHAR
  • desc — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

Product Prices (product_price)

  • id (pk) — BINGINT — Primary key — NOT NULL
  • product_id — BINGINT — Foreign key → Product.id — NOT NULL
  • country_cd — VARCHAR
  • currency_cd — VARCHAR
  • price — INT
  • created_at — DATETIME
  • updated_at — DATETIME