railports locations table structure

railports locations table structure#

The Railport Locations table mainly contains the location of railport

(* - 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
);