convenience store
Tables (4)
Category (Untitled4)
- Category ID (category_id) — INT(10) — Primary key — NOT NULL
- Store ID (store_id) — INT(10) — Foreign key → Convenience Store.Store ID — NOT NULL
- Category Name (category name) — VARCHAR(20)
Convenience Store (Untitled)
- Store ID (store_id) — INT(10) — Primary key — NOT NULL
- Location (location) — VARCHAR(20)
- Store Name (store_name) — VARCHAR(20)
Order (Untitled3)
- Order ID (order_id) — INT(10) — Primary key — NOT NULL
- Order Date (order_date) — CHAR(8)
- Order Quantity (order_quantity) — INT
Product (Untitled2)
- Product Code (product_code_id) — INT(10) — Primary key — NOT NULL
- Category ID (category_id) — INT(10) — Foreign key → Category.Category ID — NOT NULL
- Store ID (store_id) — INT(10) — Foreign key → Category.Store ID — NOT NULL
- Price (price) — INT
- Stock (stock) — INT
- Order (order) — INT
- Warehousing (warehousing) — CHAR(8)
- Expiration (expiration) — CHAR(8)
- Minimum Stock (minimum stock) — INT