s
Tables (3)
Category (Untitled2)
- Category_id (category_id) — INT() — Primary key — NOT NULL
- Category_name (category_name) — VARCHAR(20)
Management (Untitled)
- Product_id (product_id) — INT() — Primary key — NOT NULL
- Store_id (store_id) — INT() — Foreign key → Store.Store_id — NOT NULL
- Category_id (category_id) — INT() — Foreign key → Category.Category_id — NOT NULL
- Expire_Date (expire_date) — INT()
- Price (price) — INT()
- Stock (stock) — INT()
Store (Untiled1)
- Store_id (store_id) — INT() — Primary key — NOT NULL
- Store_name (store_name) — VARCHAR(20)
- Store_address (store_address) — VARCHAR(20)