parking occupancy table structure

The parking occupancy table lists the occupancy of the parking during each time interval

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
parking_id	INTEGER	NO			The parking facility identifier
start	INTEGER	NO			Start of the time interval when the occupancy is calculated (seconds)
end	INTEGER	NO			End of the time interval when the occupancy is calculated (seconds)
occupancy	REAL	NO			Parking occupancy percentage compared to the parking capacity

(* - Primary key)

The SQL statement for table and index creation is below.

create TABLE IF NOT EXISTS "Parking_Occupancy" (
    "parking_id"        INTEGER NOT NULL,
    "start"             INTEGER NOT NULL,
    "end"               INTEGER NOT NULL,
    "occupancy"         REAL    NOT NULL
);