Table d47civi_0z3xa.civicrm_location_type 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_mailing.location_type_id FK_civicrm_mailing_location_type_id N
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 mer. avr. 13 16:52 EDT 2016

Indexes:
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: