civicrm_case


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_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 R

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

When was the case (or closely related entity) was created or modified or deleted.

Table contained 0 rows

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