pears.PostcodeAreaCountries
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Links Outward part of postcode to a county and country/region fro reporting use
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| PostcodeArea | char(2) | NOT NULL | ||
| Country | char(50) | NULL | ||
| CountryRegion | char(50) | NULL |
Primary Key
- PostcodeArea
Foreign Keys
- No outgoing foreign keys found.
Referenced By
- No incoming foreign keys found.
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."PostcodeAreaCountries" -- Table comment: Links Outward part of postcode to a county and country/region fro reporting use -- Statement count: 2 CREATE TABLE "pears"."PostcodeAreaCountries" ( "PostcodeArea" CHAR(2) NOT NULL ,"Country" CHAR(50) NULL ,"CountryRegion" CHAR(50) NULL ,PRIMARY KEY ("PostcodeArea" ASC) ) GO COMMENT ON TABLE "pears"."PostcodeAreaCountries" IS 'Links Outward part of postcode to a county and country/region fro reporting use' GO