pears.PostCodeLocation

• PostCodeLocationID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."PostCodeLocation"
-- Table comment: 
-- Statement count: 4
 
CREATE TABLE "pears"."PostCodeLocation" (
    "PostCodeLocationID"             BIGINT NOT NULL DEFAULT autoincrement
   ,"PostCode"                       CHAR(20) NOT NULL
   ,"Easting"                        INTEGER NULL
   ,"Northing"                       INTEGER NULL
   ,"IQXPosition"                    ST_Point(SRID=999999) NULL COMPUTE (IF("Easting" IS NOT NULL AND "Northing" IS NOT NULL) THEN(NEW "st_point"("Easting","Northing",999999)) ELSE NULL endif)
   ,"WS84Position"                   ST_Point(SRID=4326) NULL COMPUTE ("IQXPosition"."ST_Transform"(4326))
   ,PRIMARY KEY ("PostCodeLocationID" ASC) 
)
GO
 
 
CREATE INDEX "PostCodeLocation_PostCode" ON "pears"."PostCodeLocation"
    ( "PostCode" )
GO
 
 
CREATE INDEX "PostCodeLocation_IQXPosition" ON "pears"."PostCodeLocation"
    ( "IQXPosition" )
GO
 
 
CREATE INDEX "PostCodeLocation_WS84Position" ON "pears"."PostCodeLocation"
    ( "WS84Position" )
GO