Schema

User collection

Model: User

field name	data type	details
_id	ObjectId("")
username	string	not null
email	string
password	string	not null
role	string	not null (Car owner

Service provider dashboard note

Business collection

Model: Business

field name	data type	details
_id	ObjectId("")
shop name	string	not null
location	string	not null
hours of operation	string	not null
serviceIds	array

NOTE: later when we add ‘house call’ services, can include radius for each service

Service collection

Model: Service

field name	data type	details
_id	ObjectId("")
type	string	not null
price	integer	not null

[future plans: add radius of travel for house call services]

Appointment collection

Model: Appointment

field name	data type	details
_id	ObjectId("")
datetime	string	not null
vehicleId	integer	not null
confirmed	boolean
done	boolean

Car owner dashboard note

Vehicle collection:

Model: Vehicle

field name	data type	details
_id	ObjectId("")
VIN	integer	not null
vehicleId	integer	not null
attributes	object	(make/model/year)
location	object	(latitude, longtitute
currOdometer	integer	not null
lastOdometer	integer	not null
oil level	hash	eg. ("lifeRemaining": 0.35)
tire pressure	hash	eg. (backleft ... frontright