Store

Tables (3)

mapping (Untitled3)

  • product_type_id (store_product) — Primary key — NOT NULL
  • 1
  • 1 (2)
  • 2 (3.)
  • 2 (1.)
  • 3 (2.)
  • 3
  • id (product_type) — Foreign key → store_product_type.id — NOT NULL
  • id (product_type_id) — Foreign key → store_product.id — NOT NULL

store_product (Untitled2)

  • id (product_type_id) — Primary key — NOT NULL
  • 1 (1, 2)
  • 2 (2, 3)
  • 3 (1, 3)

store_product_type (Untitled)

  • id (product_type) — Primary key — NOT NULL
  • 1 (snack)
  • 2 (chocolate)
  • 3 (drink)