civicrm_case

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_case_activity.case_id FK_civicrm_case_activity_case_idC
civicrm_case_contact.case_id FK_civicrm_case_contact_case_idC
civicrm_relationship.case_id FK_civicrm_relationship_case_idC

Unique Case ID
case_type_id INT UNSIGNED 10 null
civicrm_case_type.id FK_civicrm_case_case_type_idR

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 null

Id of case status.
is_deleted TINYINT 3 √ 0
created_date TIMESTAMP 19 √ null

When was the case was created.
modified_date TIMESTAMP 19 √ CURRENT_TIMESTAMP

Indexes

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

Relationships

Close relationships within degrees of separation