conven

Tables (4)

Category (cotegory)

  • Category Id (category_id) — INT — Primary key — NOT NULL
  • Category Name (category_name) — CHAR(30)

Product (product)

  • Product Id (product_id) — INT — Primary key — NOT NULL
  • Category Id (category_id) — INT — Foreign key → Category.Category Id — NOT NULL
  • Product Name (product_name) — CHAR(100)
  • Created At (created_at) — DATETIME
  • Expiry Date (expiry_date) — DATETIME

Store (store)

  • Store Id (store_id) — INT — Primary key — NOT NULL
  • Location (location) — CHAR(30)
  • Owner (owner) — CHAR(30)
  • Created At (created_at) — DATETIME

Store Product (store_product)

  • Product Id (product_id) — INT — Foreign key → Product.Product Id — NOT NULL
  • Store Id (store_id) — INT — Foreign key → Store.Store Id — NOT NULL