1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <name>civicrm_case
</name>
6 <description>Collections of activities and relationships for a given purpose.
</description>
7 <comment>This table stores information about cases grouping activities.
</comment>
10 <icon>fa-folder-open
</icon>
11 <labelField>subject
</labelField>
12 <component>CiviCase
</component>
15 <type>int unsigned
</type>
16 <uniqueName>case_id
</uniqueName>
17 <required>true
</required>
19 <title>Case ID
</title>
20 <comment>Unique Case ID
</comment>
28 <autoincrement>true
</autoincrement>
31 <name>case_type_id
</name>
32 <type>int unsigned
</type>
34 <export>false
</export>
35 <title>Case Type ID
</title>
36 <required>true
</required>
37 <comment>FK to civicrm_case_type.id
</comment>
40 <label>Case Type
</label>
43 <table>civicrm_case_type
</table>
44 <keyColumn>id
</keyColumn>
45 <labelColumn>title
</labelColumn>
50 <name>index_case_type_id
</name>
51 <fieldName>case_type_id
</fieldName>
55 <name>case_type_id
</name>
56 <table>civicrm_case_type
</table>
64 <title>Case Subject
</title>
66 <uniqueName>case_subject
</uniqueName>
67 <comment>Short name of the case.
</comment>
74 <name>start_date
</name>
75 <uniqueName>case_start_date
</uniqueName>
76 <title>Case Start Date
</title>
79 <comment>Date on which given case starts.
</comment>
81 <type>Select Date
</type>
82 <formatType>activityDateTime
</formatType>
88 <uniqueName>case_end_date
</uniqueName>
89 <title>Case End Date
</title>
92 <comment>Date on which given case ends.
</comment>
94 <type>Select Date
</type>
95 <formatType>activityDateTime
</formatType>
103 <type>TextArea
</type>
106 <label>Details
</label>
108 <comment>Details populated from Open Case. Only used in the CiviCase extension.
</comment>
112 <name>status_id
</name>
113 <type>int unsigned
</type>
114 <uniqueName>case_status_id
</uniqueName>
115 <required>true
</required>
116 <import>true
</import>
117 <export>false
</export>
118 <title>Case Status
</title>
119 <comment>ID of case status.
</comment>
121 <optionGroupName>case_status
</optionGroupName>
129 <name>is_deleted
</name>
130 <title>Case is in the Trash
</title>
131 <uniqueName>case_deleted
</uniqueName>
134 <import>true
</import>
136 <type>CheckBox
</type>
141 <name>index_is_deleted
</name>
142 <fieldName>is_deleted
</fieldName>
146 <name>created_date
</name>
147 <uniqueName>case_created_date
</uniqueName>
148 <type>timestamp
</type>
149 <comment>When was the case was created.
</comment>
150 <required>false
</required>
151 <export>true
</export>
152 <default>NULL
</default>
154 <label>Created Date
</label>
159 <name>modified_date
</name>
160 <uniqueName>case_modified_date
</uniqueName>
161 <type>timestamp
</type>
162 <comment>When was the case (or closely related entity) was created or modified or deleted.
</comment>
163 <required>false
</required>
164 <export>true
</export>
165 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
167 <label>Modified Date
</label>
169 <readonly>true
</readonly>