national ports locations table structure

national ports locations table structure#

This table includes the locations of internal ports that are within the modelled city

Table Structure#
Field	Type	NULL allowed	Default Value	Foreign key	Description
national_port	INTEGER	NO	0	National_Ports(national_port)	The unique identifier of the port as in the National_Ports table
location	INTEGER	NO	0		The selected location of the internal port (foreign key to the Location table)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE National_Ports_Locations (
    "national_port"       INTEGER NOT NULL DEFAULT 0,
    "location"            INTEGER NOT NULL DEFAULT 0,
    CONSTRAINT nationalportloc_fk FOREIGN KEY (national_port)
    REFERENCES National_Ports (national_port) DEFERRABLE INITIALLY DEFERRED
);