Convinience_Store
Tables (4)
items
- item id (item_id) — INT() — Primary key — NOT NULL
- type id (type_id) — INT() — Foreign key → types.type id — NOT NULL
- item name (item_name) — VARCHAR(50)
- item price (item_price) — INT()
stocks (store_stocks)
- stock id (stock_id) — INT() — Primary key — NOT NULL
- store id (store_id) — INT() — Foreign key → stores.store id — NOT NULL
- item id (item_id) — INT() — Foreign key → items.item id — NOT NULL
- stock count (stock_count) — INT()
stores
- store id (store_id) — INT() — Primary key — NOT NULL
- store name (store_name) — VARCHAR(20)
types
- type id (type_id) — INT() — Primary key
- type name (type_name) — VARCHAR(20)