1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <name>civicrm_case
</name>
6 <comment>This table stores information about cases grouping activities.
</comment>
11 <type>int unsigned
</type>
12 <uniqueName>case_id
</uniqueName>
13 <required>true
</required>
15 <title>Case ID
</title>
16 <comment>Unique Case ID
</comment>
24 <autoincrement>true
</autoincrement>
27 <name>contact_id
</name>
28 <type>int unsigned
</type>
29 <uniqueName>case_contact_id
</uniqueName>
30 <required>true
</required>
31 <comment>Contact ID of contact record given case belongs to.
</comment>
36 <name>contact_id
</name>
37 <table>civicrm_contact
</table>
41 <onDelete>CASCADE
</onDelete>
44 <name>case_type_id
</name>
45 <type>int unsigned
</type>
47 <export>false
</export>
48 <title>Case Type
</title>
49 <required>true
</required>
50 <comment>FK to civicrm_case_type.id
</comment>
55 <table>civicrm_case_type
</table>
56 <keyColumn>id
</keyColumn>
57 <labelColumn>title
</labelColumn>
62 <name>index_case_type_id
</name>
63 <fieldName>case_type_id
</fieldName>
67 <name>case_type_id
</name>
68 <table>civicrm_case_type
</table>
73 <name>casetag1_id
</name>
76 <required>true
</required>
77 <comment>Id of first case category.
</comment>
82 <name>index_casetag1_id
</name>
83 <fieldName>casetag1_id
</fieldName>
88 <name>casetag2_id
</name>
91 <required>true
</required>
92 <comment>Id of second case category.
</comment>
97 <name>index_casetag2_id
</name>
98 <fieldName>casetag2_id
</fieldName>
103 <name>casetag3_id
</name>
106 <required>true
</required>
107 <comment>Id of third case category.
</comment>
112 <name>index_casetag3_id
</name>
113 <fieldName>casetag3_id
</fieldName>
121 <title>Case Subject
</title>
122 <import>true
</import>
123 <uniqueName>case_subject
</uniqueName>
124 <comment>Short name of the case.
</comment>
131 <name>start_date
</name>
132 <uniqueName>case_start_date
</uniqueName>
133 <title>Case Start Date
</title>
134 <import>true
</import>
136 <comment>Date on which given case starts.
</comment>
138 <type>Select Date
</type>
139 <formatType>activityDateTime
</formatType>
144 <name>end_date
</name>
145 <uniqueName>case_end_date
</uniqueName>
146 <title>Case End Date
</title>
147 <import>true
</import>
149 <comment>Date on which given case ends.
</comment>
151 <type>Select Date
</type>
152 <formatType>activityDateTime
</formatType>
160 <type>TextArea
</type>
164 <comment>Details about the meeting (agenda, notes, etc).
</comment>
168 <name>status_id
</name>
169 <type>int unsigned
</type>
170 <uniqueName>case_status_id
</uniqueName>
171 <required>true
</required>
172 <import>true
</import>
173 <export>false
</export>
174 <title>Case Status
</title>
175 <comment>Id of case status.
</comment>
177 <optionGroupName>case_status
</optionGroupName>
185 <name>is_deleted
</name>
186 <title>Case is in the Trash
</title>
187 <uniqueName>case_deleted
</uniqueName>
190 <import>true
</import>
191 <title>Case Deleted
</title>
193 <type>CheckBox
</type>
198 <name>index_is_deleted
</name>
199 <fieldName>is_deleted
</fieldName>
203 <name>created_date
</name>
204 <uniqueName>case_created_date
</uniqueName>
205 <type>timestamp
</type>
206 <comment>When was the case was created.
</comment>
207 <required>false
</required>
208 <export>true
</export>
209 <default>NULL
</default>
213 <name>modified_date
</name>
214 <uniqueName>case_modified_date
</uniqueName>
215 <type>timestamp
</type>
216 <comment>When was the case (or closely related entity) was created or modified or deleted.
</comment>
217 <required>false
</required>
218 <export>true
</export>
219 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>