Table of Contents



pears.PostCodeLocation

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Columns

Column Type Null Default Comment
PostCodeLocationID bigint NOT NULL autoincrement
PostCode char(20) NOT NULL
Easting integer NULL
Northing integer NULL
IQXPosition ST_Point(SRID=999999) NOT NULL
WS84Position ST_Point(SRID=4326) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
PostCodeLocation_PostCode Index PostCode
PostCodeLocation_IQXPosition Index IQXPosition
PostCodeLocation_WS84Position Index WS84Position

Triggers

Original SQL

-- 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