conve
Tables (3)
Category (category)
- Conve_id (conve_id) — INT(100) — Foreign key → GS50.Conve_id — NOT NULL
- Content_id (content_id) — INT(100) — Foreign key → Content.Content_id — NOT NULL
Content (content)
- Content_id (content_id) — INT(100) — Primary key — NOT NULL
- Content_name (content_name) — VARCHAR(250)
- Price (price) — INT(10)
- Arrival_date (arrival_date) — INT(8)
- Expiration_date (expiration_date) — INT(8)
- Manufacturer (manufacturer) — VARCHAR(100)
- Stock (stock) — INT(8)
GS50 (7&11)
- Conve_id (conve_id) — INT(100) — Primary key — NOT NULL
- City (city) — VARCHAR(100)
- Store_name (store_name) — VARCHAR(250)
- Phone (phone) — VARCHAR(11)