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