civicrm_contact_type

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_contact_type.parent_id FK_civicrm_contact_type_parent_idR

Contact Type ID

name VARCHAR 64 null

Internal name of Contact Type (or Subtype).

image_URL VARCHAR 255 null

URL of image if any.

parent_id INT UNSIGNED 10 null
civicrm_contact_type.id FK_civicrm_contact_type_parent_idR

Optional FK to parent contact type.

is_active TINYINT 3 null

Is this entry active?

is_reserved TINYINT 3 null

Is this contact type a predefined system type

label_en_US VARCHAR 64 null
description_en_US TEXT 65535 null
label_fr_CA VARCHAR 64 null
description_fr_CA TEXT 65535 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
contact_type Must be unique Asc name
FK_civicrm_contact_type_parent_id Performance Asc parent_id

Relationships