international port locations table structure

international port 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
international_port	INTEGER	NO	0	International_Port(international_port)	The unique identifier of the port as in the International_Port 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 International_Port_Locations (
    "international_port"       INTEGER NOT NULL DEFAULT 0,
    "location"                 INTEGER NOT NULL DEFAULT 0,
    CONSTRAINT internationalportloc_fk FOREIGN KEY (international_port)
    REFERENCES International_Port (international_port) DEFERRABLE INITIALLY DEFERRED
);