Constraint | Type | Details |
g_dgaz_ft_text_2015_pkey |
Primary Key |
See details above for primary key index
|
g_dgaz_ft_text_2015_fk_adl |
Foreign Key |
Column(s) {2} link to table
g_adl_ft_2015,
column(s) {1}.
|
g_dgaz_ft_text_2015_chk_barony |
Check |
(((is_barony IS NULL) OR (is_barony = 1)))
|
g_dgaz_ft_text_2015_chk_borough |
Check |
(((is_borough IS NULL) OR (is_borough = 1) OR (is_borough = 2)))
|
g_dgaz_ft_text_2015_chk_chapelry |
Check |
(((is_chapelry IS NULL) OR (is_chapelry = 1)))
|
g_dgaz_ft_text_2015_chk_county |
Check |
(((is_county IS NULL) OR (is_county = 1)))
|
g_dgaz_ft_text_2015_chk_district |
Check |
(((is_district IS NULL) OR (is_district = 1)))
|
g_dgaz_ft_text_2015_chk_hundred |
Check |
(((is_hundred IS NULL) OR (is_hundred = 1)))
|
g_dgaz_ft_text_2015_chk_liberty |
Check |
(((is_liberty IS NULL) OR (is_liberty = 1)))
|
g_dgaz_ft_text_2015_chk_parish |
Check |
(((is_parish IS NULL) OR (is_parish = 1) OR (is_parish = 2)))
|
g_dgaz_ft_text_2015_chk_sub_par |
Check |
(((is_sub_par IS NULL) OR (is_sub_par = 1)))
|
g_dgaz_ft_text_2015_chk_township |
Check |
(((is_township IS NULL) OR (is_township = 1)))
|
g_dgaz_ft_text_2015_chk_tything |
Check |
(((is_tything IS NULL) OR (is_tything = 1)))
|
Column | Type | Contents |
g_ft_text |
Text string (max.len.=204). |
Standardised version of gazetteer feature type string.
|
g_adl_ft |
Text string (max.len.=44). |
ADL feature type classification.
|
is_parish |
Integer number. |
2 if the entry clearly states it was for a parish, without qualification; 1 if
it is described as an 'ancient parish', a 'quoad sacra' parish or
similar language; and null otherwise.
|
is_county |
Integer number. |
1 if the entry is for a county, null otherwise.
|
is_barony |
Integer number. |
1 if the entry is for a barony, null otherwise.
|
is_borough |
Integer number. |
1 if the entry is for a borough, null otherwise.
|
is_district |
Integer number. |
1 if the entry is for a 'district', null otherwise.
In 19th century England or Wales this most probably means a Registration District.
|
is_subdist |
Integer number. |
1 if the entry is for a Registration sub-District, null otherwise.
|
is_hundred |
Integer number. |
1 if the entry is for a hundred, null otherwise.
|
is_liberty |
Integer number. |
1 if the entry is for a liberty, null otherwise.
|
is_township |
Integer number. |
1 if the entry is for a township, null otherwise.
|
is_tything |
Integer number. |
1 if the entry is for a tything, null otherwise.
|
is_chapelry |
Integer number. |
1 if the entry is for a chapelry, null otherwise.
|
is_sub_par |
Integer number. |
1 if the entry is for a sub-parish unit, null otherwise.
|