Table d47civi_0z3xa.civicrm_contact_type Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_contact_type.parent_id FK_civicrm_contact_type_parent_id R
Contact Type ID
name varchar 64  √  null Internal name of Contact Type (or Subtype).
label varchar 64  √  null localized Name of Contact Type.
description text 65535  √  null localized Optional verbose description of the type.
image_URL varchar 255  √  null URL of image if any.
parent_id int unsigned 10  √  null FK_civicrm_contact_type_parent_id R
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

Table contained 9 rows at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
name Must be unique Asc contact_type This unique column is also nullable
parent_id Performance Asc FK_civicrm_contact_type_parent_id  

Close relationships: