parking records table structure

An output table for the simulated parking events. For each parking event, it records the vehicle, driver, parking location, parking start and end time and the parking cost

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
id*	INTEGER	NO			Unique identifier of this Parking event
Parking_ID	INTEGER	NO	-1		The parking facility at which this event occurred (foreign key to Parking table)
Location_ID	INTEGER	NO	-1		Optional, the location where this event occurred; only used where no nearby parking facility is available (foreign key to Location table)
Link_ID	INTEGER	NO	0		The link from which the parking event occurred (foreign key to Link table)
vehicle	INTEGER	NO	0		The vehicle being parked (foreign key to Vehicle table)
person	INTEGER	NO	0		The person driving the vehicle (foreign key to Person table)
Time_In	INTEGER	NO	0		Time stamp when the vehicle started parking (units: seconds)
Time_Out	INTEGER	NO	0		Time stamp when the vehicle exited parking (units: seconds)
Is_TNC_Vehicle	INTEGER	NO	0		boolean flag - is this a TNC vehicle?
Cost	REAL	YES	0		The vehicle’s parking cost ($USD)
Choice_ID	INTEGER	NO	0		The parking choice identifier

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Parking_Records (
    "id"                INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "Parking_ID"        INTEGER NOT NULL DEFAULT -1,
    "Location_ID"       INTEGER NOT NULL DEFAULT -1,
    "Link_ID"           INTEGER NOT NULL DEFAULT 0,
    "vehicle"           INTEGER NOT NULL DEFAULT 0,
    "person"            INTEGER NOT NULL DEFAULT 0,
    "Time_In"           INTEGER NOT NULL DEFAULT 0,
    "Time_Out"          INTEGER NOT NULL DEFAULT 0,
    "Is_TNC_Vehicle"    INTEGER NOT NULL DEFAULT 0,
    "Cost"              REAL             DEFAULT 0,
    "Choice_ID"         INTEGER NOT NULL DEFAULT 0
);