Constraint | Type | Details |
ind_redistricted_div_pkey |
Primary Key |
See details above for primary key index
|
ind_redistricted_div_area_type_check |
Check |
((((area_type)::text = 'COUNTRY'::text) OR ((area_type)::text = 'DISTRICT'::text) OR ((area_type)::text = 'GOR'::text) OR ((area_type)::text = 'MOD_REG'::text) OR ((area_type)::text = 'MOD_CNTY'::text) OR ((area_type)::text = 'NATION'::text)))
|
ind_redistricted_div_gender_check |
Check |
((((gender)::text = 'A'::text) OR ((gender)::text = 'M'::text) OR ((gender)::text = 'F'::text)))
|
ind_redistricted_div_nat_source_check |
Check |
((((nat_source)::text = 'Reported_total'::text) OR ((nat_source)::text = 'Sum_of_redist'::text) OR ((nat_source)::text = 'Sum_of_raw_EnumD'::text) OR ((nat_source)::text = 'Sum_of_raw_Par'::text) OR ((nat_source)::text = 'Sum_of_raw_Ward'::text) OR ((nat_source)::text = 'Sum_of_EW_and_Scot'::text)))
|
Column | Type | Contents |
area_type |
Text string (max.len.=16). |
Type of row:
- 'DISTRICT' = data are for a Local Authority District.
- 'NATION' = data are overall totals for England and Wales, or for Scotland.
|
nation |
Text string (max.len.=6). |
Short code indicating part of Britain covered:
"EW" = England and Wales, "S" = Scotland,
"GB" = Great Britain (used only for the national totals).
|
nat_source |
Text string (max.len.=28). |
Used only for rows which are national totals for
"England and Wales", Scotland or Great Britain,
and then records how it was calculated.
|
area_name |
Text string (max.len.=44). |
Name of the reporting area.
|
g_unit |
Integer number. |
ID number of the reporting area as defined in the GBHGIS AUO.
|
year |
Integer number. |
Date of the census.
|
sic_division |
Integer number. |
Integer number identifying the 2007 SIC 'Division'.
These form a single sequence running from 1 to 99,
but we have added 100 to cover unclassifiable workers.
|
sic_section |
Text string (max.len.=6). |
Capital Letter identifying the SIC 'Section'.
These form a single sequence running from A to U,
but we have added X to cover unclassifiable workers.
|
gbh_sector_name |
Text string (max.len.=28). |
Name of one of eight broad "Sectors" defined by the project.
|
gender |
Text string (max.len.=6). |
Gender: 'A' means all, i.e. males and females combined.
'F' means females, and 'M' means males.
|
persons |
Floating point number. |
Number of persons in this combination of date, areaa, division and gender.
|
rec_num |
Integer number. |
Sequence number keeping rows in the order they were inserted.
|