airport locations table structure

airport locations table structure#

This Airport Point of Entry (POE) Locations table mainly contains the location of airport

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

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Airport_Locations (
    "airport"       INTEGER NOT NULL DEFAULT 0,
    "location"      INTEGER NOT NULL DEFAULT 0,
    CONSTRAINT airportloc_fk FOREIGN KEY (airport)
    REFERENCES Airport (airport) DEFERRABLE INITIALLY DEFERRED
);