test

Tables (3)

Brand

  • id — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • popularity — int — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

Product

  • id — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • price — varchar(100) — NOT NULL
  • brand_id — int — Foreign key → Brand.id — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

Something

  • id — int — Primary key — NOT NULL
  • product_id — int — Foreign key → Product.id — NOT NULL
  • value — int — NOT NULL