Convini
Tables (3)
Goods (goods)
- id (Key) — Integer — Primary key — NOT NULL
- Name (name) — Text
- Stock (stock) — Integer
- Company (company) — Text
- Price (price) — Integer
- Expiration_date (exp) — Date
Order (order)
- id (Key) — Integer — Primary key — NOT NULL
- goods_id (Key2) — Integer — Foreign key → Goods.id — NOT NULL
- store_id (Key3) — Integer — Foreign key → Store.id — NOT NULL
- Date (date) — Date
- quantity — Integer
- Total_price (total) — Integer
Store (store)
- id (Key) — Integer — Primary key — NOT NULL
- Store_name (store_name) — Text
- address — Text
- phone_number — Phone_number