civicrm_county


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_address.county_id FK_civicrm_address_county_id N

County ID

name VARCHAR 64 null

Name of County

abbreviation VARCHAR 4 null

2-4 Character Abbreviation of County

state_province_id INT UNSIGNED 10 null
civicrm_state_province.id FK_civicrm_county_state_province_id R

ID of State/Province that County belongs

Table contained 6 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_county_state_province_id Performance Asc state_province_id
UI_name_state_id Must be unique Asc/Asc name + state_province_id

Relationships