shop
Tables (6)
Customer
- CustomerID — INT
- Name — VARCHAR(255)
- Contact — VARCHAR(20)
- RegistrationDate — DATE
Mileage
- MileageID — INT
- CustomerID — INT
- UsedMileage — INT
- UnusedMileage — INT
- Month — DATE
PlatformAdmin
- AdminID — INT
- Name — VARCHAR(255)
- RegistrationDate — DATE
Product
- ProductID — INT
- Name — VARCHAR(255)
- Price — DECIMAL(10, 2)
- EntryDate — DATE
- ShopID — INT
Purchase
- PurchaseID — INT
- PurchaseDate — DATE
- ProductID — INT
- CustomerID — INT
- Quantity — INT
Shop
- ShopID — INT
- Name — VARCHAR(255)
- EntryDate — DATE
- Contact — VARCHAR(20)
- 2) — DEFAULT
- PlatformFee — DECIMAL(15, 2)