Customer Database
Manage customer accounts, contact info, and vehicle records
| Customer | Contact | Vehicles | Status | Last Service | Satisfaction | Total Spend |
|---|---|---|---|---|---|---|
John Smith CUST-001 123 Main St, Downtown | john.smith@email.com (555) 123-4567 | 2 | Active | 2024-12-01 | 95% | $3,200 |
Sarah Martinez CUST-002 456 Oak Ave, Midtown | s.martinez@email.com (555) 234-5678 | 1 | Active | 2024-11-28 | 90% | $1,800 |
Mike Davis CUST-003 789 Pine Rd, Uptown | m.davis@email.com (555) 345-6789 | 3 | VIP | 2024-12-03 | 98% | $8,500 |
Emma Thompson CUST-004 321 Elm St, Suburbs | e.thompson@email.com (555) 456-7890 | 2 | Active | 2024-10-15 | 85% | $2,400 |
Robert Brown CUST-005 654 Maple Dr, Downtown | r.brown@email.com (555) 567-8901 | 4 | VIP | 2024-12-02 | 96% | $12,300 |
| Vehicle | VIN | Owner | Odometer | Last Service | Next Service | History | Status |
|---|---|---|---|---|---|---|---|
2023 Honda Civic VEH-001 | 1HGBH41JXMN109186 | John Smith | 18,500 mi | 2024-12-01 | 2025-03-01 | 5 visits | Active |
2022 Toyota Camry VEH-002 | 4T1BF1K80CU123456 | Sarah Martinez | 45,200 mi | 2024-11-28 | 2025-02-28 | 8 visits | Active |
2021 Volkswagen Jetta VEH-003 | 3VWFE21C03M000001 | John Smith | 62,300 mi | 2024-11-20 | 2025-02-20 | 12 visits | Active |
2020 Ford Fusion VEH-004 | 2FMF5D43506A123456 | Mike Davis | 98,700 mi | 2024-12-03 | 2025-01-03 | 18 visits | Active |
2019 Chevrolet Silverado VEH-005 | 1GC4KSE30EF123456 | Robert Brown | 156,400 mi | 2024-12-02 | 2024-12-22 | 28 visits | Active |