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
);