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