Convenience

Tables (3)

Branche (branch)

  • Branch Id (branch_id) — INT(11) — Primary key — NOT NULL
  • Branch Name (branch_name) — VARCHAR(25)
  • Master Name (master_name) — VARCHAR(25)
  • Founding (founding) — CHAR(11)
  • Open Time (open_time) — CHAR(11)
  • Close Time (close_time) — CHAR(11)

Category (category)

  • Category Id (category_id) — INT(11) — Primary key — NOT NULL
  • Branch Id (branch_id) — INT(11) — Foreign key → Branche.Branch Id — NOT NULL
  • Category (category) — VARCHAR(25)
  • Storage (storage) — VARCHAR(25)

Product (product)

  • Product Id (product_id) — INT(11) — Primary key — NOT NULL
  • Category Id (category_id) — INT(11) — Foreign key → Category.Category Id — NOT NULL
  • Branch Id (branch_id) — INT(11) — Foreign key → Category.Branch Id — NOT NULL
  • Product Name (product_name) — VARCHAR(25)
  • Price (price) — CHAR(25)
  • Stock (stock) — CHAR(25)
  • Shelf Life (shelf_life) — CHAR(11)