dic_county

35 rows


Description

Dictionary of counties

Columns

Column Type Size Nulls Auto Default Children Parents Comments
county_id INT 10 √ null
heritage_site.county_id heritage_site_ibfk_1 R
location.county_id location_ibfk_1 R
material.county_id material_ibfk_1 R
material_source.county_id material_source_ibfk_1 R

PK. Auto incrementing
county VARCHAR 100 null

Full name of county
province VARCHAR 100 √ NULL

Full name of province
county_code VARCHAR 10 √ NULL

County code

Indexes

Constraint Name Type Sort Column(s)
dic_county_s_pk Primary key Asc county_id
PRIMARY Must be unique Asc county_id

Relationships

Close relationships within degrees of separation