Table d44civi_9xzwf.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 varchar 128 Multivalued pseudo-fk to option_value table where option_group_name = case_type.
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:14 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: