waterport locations table structure

This table joins the Waterports with their corresponding activity locations from the Location table

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
waterport	INTEGER	NO	0	Waterport(waterport)	The unique identifier of the waterport as in the Waterport table
location	INTEGER	NO	0		The selected location of the waterport (foreign key to the Location table)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Waterport_Locations (
    "waterport"  INTEGER NOT NULL DEFAULT 0,
    "location"   INTEGER NOT NULL DEFAULT 0,
    CONSTRAINT waterportloc_fk FOREIGN KEY (waterport)
    REFERENCES Waterport (waterport) DEFERRABLE INITIALLY DEFERRED
);