truck poe table structure#
List of Point of Entry for trucks by OD pair between all counties in the model and external counties
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
|---|---|---|---|---|---|
internal_county |
INTEGER |
NO |
0 |
Counties(internal_county) |
ID of the county inside the modelled area |
external_county |
INTEGER |
NO |
0 |
ID of the county outside the modelled area |
|
location |
INTEGER |
NO |
0 |
ID of the location in the Supply file |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE Truck_Poe (
"internal_county" INTEGER NOT NULL DEFAULT 0,
"external_county" INTEGER NOT NULL DEFAULT 0,
"location" INTEGER NOT NULL DEFAULT 0,
CONSTRAINT internal_county_fk FOREIGN KEY (internal_county)
REFERENCES Counties (county) DEFERRABLE INITIALLY DEFERRED
);