civicrm_location_type - civicrm Database

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees