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)