TaiorLink
Tables (11)
Accident_Reports
- Report_ID — INT
- User_ID — INT — NOT NULL
- Description — TEXT — NOT NULL
- Timestamp — DATETIME
Car_Maintenance_Tips
- Tip_ID — INT
- Description — TEXT — NOT NULL
- Category — VARCHAR(50) — NOT NULL
Customer_Vehicles
- Vehicle_ID — INT
- Customer_ID — INT — NOT NULL
- Model_ID — INT — NOT NULL
- License_Plate — VARCHAR(50)
- VIN — VARCHAR(50)
Customers
- CustomerID — Int — Primary key — NOT NULL
- Customer_ID — INT
- Name — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- Phone — VARCHAR(20)
- Address — VARCHAR(255)
Driving_Analysis
- Analysis_ID — INT
- User_ID — INT — NOT NULL
- Driving_Data — JSON — NOT NULL
- Fuel_Efficiency — FLOAT — NOT NULL
- Recommendations — TEXT
FAQ
- FAQ_ID — INT — Primary key — NOT NULL
- Category — TEXT
- Question — TEXT — NOT NULL
- Answer — TEXT — NOT NULL
Repair_Estimates
- Estimate_ID — INT
- Image_Path — VARCHAR(255) — NOT NULL
- Estimated_Cost — FLOAT — NOT NULL
- Timestamp — DATETIME
Reservations
- Reservation_ID — INT
- User_ID — INT — NOT NULL
- Service_Date — DATE — NOT NULL
- Status — VARCHAR(20) — NOT NULL
Text_Estimates
- Estimate_ID — INT
- User_Input — TEXT — NOT NULL
- Estimated_Cost — FLOAT — NOT NULL
- Timestamp — DATETIME
Users
- User_ID — INT
- Name — VARCHAR(255) — NOT NULL
- Role — VARCHAR(50) — NOT NULL
Vehicle_Models
- Model_ID — INT
- Make — VARCHAR(100) — NOT NULL
- Model — VARCHAR(100) — NOT NULL
- Year — INT — NOT NULL