railport locations table structure

railport locations table structure#

The Railport Locations table mainly contains the location of railport

Table Structure#
Field	Type	NULL allowed	Default Value	Foreign key	Description
railport	INTEGER	NO	0	Railport(railport)	The unique identifier of the railport as in Railport table
location	INTEGER	NO	0		The selected location of the railports (From the Supply Location table)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Railport_Locations (
    "railport"  INTEGER NOT NULL DEFAULT 0,
    "location"  INTEGER NOT NULL DEFAULT 0,
    CONSTRAINT railport_loc_fk FOREIGN KEY (railport)
    REFERENCES Railport (railport) DEFERRABLE INITIALLY DEFERRED
);