person gaps table structure

Person_Gaps table holds the status of assignment at the person level. As we are using agent-specific routers and agent-based dynamic equilibrium, the gaps stored here can help with convergence.

Not currently used, but logged.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
person*	INTEGER	NO		Person(person)	The person whose average gap is being logged (foreign key to Person table)
avg_gap	REAL	YES	0		Float value of gap estimated based on routed travel time and estimated travel time.

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Person_Gaps" (
  "person" INTEGER NOT NULL PRIMARY KEY,
  "avg_gap" REAL NULL DEFAULT 0,

  CONSTRAINT "person_fk"
    FOREIGN KEY ("person")
    REFERENCES "Person" ("person")
    DEFERRABLE INITIALLY DEFERRED)