Table d44civi_9xzwf.civicrm_contact_type Generated by
SchemaSpy
Legend: SourceForge.net
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
civicrm_contact_type.id 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 8 rows at Wed Nov 11 17:14 EST 2015

Indexes:
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: