sp047_postcodes
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table provides a list of (full or partial) postcodes (or, more generally, any 8 character location code) known to the system. (It is needed to allow the user to be presented with a list of postcodes which have not been assigned to a region.)
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| postcode | varchar2(30) | Â |  |
| region_no | number(9) | Â |  |
| lat | number(18,9) | Â | |
| lon | number(18,9) | Â | |
| obsolete | integer | Â | |
| visible | number(1) | Â | |
| lat_long_option | number(2) |  | |
Keys
primary key (postcode)Â
foreign key (region_no) references sp057_regions (region_no)
Column Descriptions
| Field | Description |
|---|---|
| postcode | A full or partial postcode, or other (customer defined) location code. |
| region_no | region to which this postcode is mapped |
| lat | lat/lon co-ordinates of postcode (coordinate system WGS84) |
| lon | Â |
| obsolete | Marker used to indicate postcode no longer used |
| visible | Marker used to denote whether the point should be drawn on the map in Planner. |
| lat_long_option | *reserved* for future enhancements |
Â
Â