Table d47civi_0z3xa.civicrm_county Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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
civicrm_state_province.id FK_civicrm_county_state_province_id R
ID of State/Province that County belongs

Table contained 6 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: