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