Table d45civi_b72v5.civicrm_case 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_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
civicrm_case_type.id FK_civicrm_case_case_type_id N
FK to civicrm_case_type.id
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 Wed Nov 11 17:12 EST 2015

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