civicrm_location_type

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_mailing.location_type_id FK_civicrm_mailing_location_type_idN
civicrm_mapping_field.location_type_id FK_civicrm_mapping_field_location_type_idR
civicrm_uf_field.location_type_id FK_civicrm_uf_field_location_type_idN

Location Type ID
name VARCHAR 64 √ null

Location Type 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?
display_name_en_US VARCHAR 64 √ null
display_name_fr_CA VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UI_name Must be unique Asc name

Relationships

Close relationships within degrees of separation