Table d47civi_0z3xa.civicrm_case 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_case_activity.case_id FK_civicrm_case_activity_case_id C
civicrm_case_contact.case_id FK_civicrm_case_contact_case_id C
civicrm_relationship.case_id FK_civicrm_relationship_case_id C
Unique Case ID
case_type_id int unsigned 10  √  null FK_civicrm_case_case_type_id N
FK to
subject varchar 128  √  null Short name of the case.
start_date date 10  √  null Date on which given case starts.
end_date date 10  √  null Date on which given case ends.
details text 65535  √  null Details about the meeting (agenda, notes, etc).
status_id int unsigned 10 Id of case status.
is_deleted tinyint 3  √  0

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

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
case_type_id Performance Asc index_case_type_id
is_deleted Performance Asc index_is_deleted

Close relationships  within of separation: