Table d45civi_b72v5.civicrm_location_type Generated by
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_mapping_field.location_type_id FK_civicrm_mapping_field_location_type_id R
civicrm_uf_field.location_type_id FK_civicrm_uf_field_location_type_id N
Location Type ID
name varchar 64  √  null Location Type Name.
display_name varchar 64  √  null Location Type Display Name.
vcard_name varchar 64  √  null vCard Location Type Name.
description varchar 255  √  null Location Type Description.
is_reserved tinyint 3  √  null Is this location type a predefined system location?
is_active tinyint 3  √  null Is this property active?
is_default tinyint 3  √  null Is this location type the default?

Table contained 5 rows at Wed Nov 11 17:12 EST 2015

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
name Must be unique Asc UI_name This unique column is also nullable

Close relationships  within of separation: