civicrm_contact_type - civicrm Database

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 10 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One