workshop_0504
Tables (5)
ConvenienceStore (conveniencestore)
- ConvenienceStore_id (conveniencestroe_id) — INT(10) — Primary key — NOT NULL
- Manager (manager) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
Employ (employ)
- ConvenienceStore_id (conveniencestroe_id) — INT(10) — Foreign key → ConvenienceStore.ConvenienceStore_id — NOT NULL
- Employee_id (employee_id) — INT(10) — Foreign key → Employee.Employee_id — NOT NULL
Employee (employee)
- Employee_id (employee_id) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
Product (product)
- Product_id (product_id) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Price (price) — INT(10)
- Category (category) — VARCHAR(255)
- Exp (exp) — INT(10)
StoreProduct (storeproduct)
- Product_id (product_id) — INT(10) — Foreign key → Product.Product_id — NOT NULL
- ConvenienceStore_id (conveniencestroe_id) — INT(10) — Foreign key → ConvenienceStore.ConvenienceStore_id — NOT NULL
- 수량 — INT(10)