workshop
Tables (4)
Category (Untitled)
- Key — Primary key — NOT NULL
- Category_id (category) — VARCHAR(255)
P_info (p_info)
- Key — Primary key — NOT NULL
- ID (id) — INT — Foreign key → Product_info.ID — NOT NULL
- ID (id2) — INT — Foreign key → Product_info.ID — NOT NULL
- Key (Key2) — Foreign key → Product_info.Key — NOT NULL
- Product_id (product) — VARCHAR(255)
Product_info (product)
- ID (id) — INT — Primary key — NOT NULL
- ID (id2) — INT — Foreign key → Store.ID — NOT NULL
- Key — Foreign key → Category.Key — NOT NULL
- Date (date) — VARCHAR(255)
- Name (name) — VARCHAR(255)
- Price (price) — VARCHAR(255)
Store (stores)
- ID (id) — INT — Primary key — NOT NULL
- Location (location) — VARCHAR(255)
- Name (name) — VARCHAR(255)