Workshop
Tables (3)
Items (items)
- Item_id (item_id) — INT — Primary key — NOT NULL
- Item_name (item_name) — TEXT
- Created_at (created_at) — DATE
- Dead_line (dead_line) — DATE
StockManagement (stockmanagement)
- 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 (stock) — INT
- Receving_date (receving_date) — DATE
- Price (price) — INT
Stores (stores)
- Store_id (store_id) — INT — Primary key — NOT NULL
- Address (address) — TEXT