Data Fields

Driver

DB Column	DB DataType	JS	JS DataType	Comments
ID	BIGINT(19)	id	Number	-
ACTIVE	BOOLEAN(1)	active	Boolean	-
CSUS_ID	VARCHAR(9)	csusId	String	-
DL_NUMBER	VARCHAR(255)	dlNumber	String	-
DL_STATE	VARCHAR(2)	dlState	String	-
DRIVER_FIRST_NAME	VARCHAR(30)	driverFirstName	String	-
DRIVER_LAST_NAME	VARCHAR(30)	driverLastName	String	-
INSURANCE_CHECKED	BOOLEAN(1)	insuranceChecked	Boolean	-
PHONE_NUMBER	VARCHAR(10)	phoneNumber	String	-
VEHICLE_ID	BIGINT(19)	vehicle	Vehicle Object	-

Vehicle

DB Column	DB DataType	JS	JS DataType	Comments
ID	BIGINT(19)	id	Number	-
COLOR	VARCHAR(255)	color	String	-
LICENSE_PLATE	VARCHAR(255)	licensePlate	String	-
MAKE	VARCHAR(255)	make	String	-
MODEL	VARCHAR(255)	model	String	-
SEATS	INTEGER(10)	seats	Number	-
YEAR	VARCHAR(4)	year	String	-
DRIVER_ID	BIGINT(19)	-	-	-

Ride Request

DB Column	DB DataType	JS	JS DataType	Comments
ID	BIGINT(19)	id	Number	-
DATE	TIMESTAMP(23,10)	date	Number	-
DROPOFF_CITY	VARCHAR(255)	dropoffCity	String	-
DROPOFF_LINE1	VARCHAR(255)	dropoffLine1	String	-
DROPOFF_LINE2	VARCHAR(255)	dropoffLine2	String	-
DROPOFF_ZIP	VARCHAR(255	dropoffZip	Number	-
END_ODOMETER	INTEGER(10)	endOdometer	Number	-
NUM_PASSENGERS	INTEGER(10)	numPassengers	Number	-
PICKUP_CITY	VARCHAR(255)	pickupCity	String	-
PICKUP_LINE1	VARCHAR(255)	pickupLine1	String	-
PICKUP_LINE2	VARCHAR(255)	pickupLine2	String	-
PICKUP_ZIP	INTEGER(10)	pickupZip	Number	-
REQUESTOR_CONTACT_NUMBER	VARCHAR(255)	requestorContactNumber	String	-
REQUESTOR_FIRST_NAME	VARCHAR(255)	requestorFirstName	String	-
REQUESTOR_ID	VARCHAR(10)	requestorId	String	-
REQUESTOR_LAST_NAME	VARCHAR(255)	requestorLastName	String	-
START_ODOMETER	INTEGER(10)	startOdometer	Number	-
STATUS	VARCHAR(255)	status	String	-
DRIVER_ID	BIGINT(19)	driver	Driver Object	-