ddd

Tables (6)

category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

producer

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

product

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — INT
  • provider_id — BIGINT — Foreign key → provider.id
  • category_id — BIGINT — Foreign key → category.id
  • created_at — DATETIME
  • updated_at — DATETIME

product_detail

  • id — BIGINT — Primary key — NOT NULL
  • description — VARCHAR(255)
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

product_producer

  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • producer_id — BIGINT — Foreign key → producer.id — NOT NULL

provider

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME