Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
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.

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

Table contained 5 rows


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