Table d47civi_0z3xa.civicrm_value_constituent_information_1 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  √ 
entity_id int unsigned 10
civicrm_contact.id FK_civicrm_value_constituent_information_1_entity_id C
most_important_issue_1 varchar 255  √  null
marital_status_2 varchar 255  √  null
marriage_date_3 datetime 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
marital_status_2 Performance Asc INDEX_marital_status_2
marriage_date_3 Performance Asc INDEX_marriage_date_3
most_important_issue_1 Performance Asc INDEX_most_important_issue_1
entity_id Must be unique Asc unique_entity_id

Close relationships  within of separation: