traffic incident table structure

traffic incident table structure#

Incidents to be applied during the simulation (only supported in Mesoscopic model)

Table Structure#
Field	Type	NULL allowed	Default Value	Foreign key	Description
link	INTEGER	NO		Link(link)	link in which the incident applies
dir	INTEGER	NO	0		direction (0 for A to B, 1 from B to A)
start_time	INTEGER	NO	0		initial time (in seconds from midnight) in which the incident occurs
end_time	INTEGER	NO	0		final time (in seconds from midnight) in which the incident occurs
capacity_scale	REAL	NO	0		relative capacity that the link will experience from 0 (completely blocked) to 1 (no impact)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Traffic_Incident"
(
    "link"           INTEGER NOT NULL,
    "dir"            INTEGER NOT NULL DEFAULT 0,
    "start_time"     INTEGER NOT NULL DEFAULT 0,
    "end_time"       INTEGER NOT NULL DEFAULT 0,
    "capacity_scale" REAL    NOT NULL DEFAULT 0,

    CONSTRAINT "link_fk" FOREIGN KEY ("link") REFERENCES "Link" ("link") DEFERRABLE INITIALLY DEFERRED -- check
);