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>
21 <autoincrement>true
</autoincrement>
24 <name>contact_id
</name>
25 <type>int unsigned
</type>
26 <uniqueName>case_contact_id
</uniqueName>
27 <required>true
</required>
28 <comment>Contact ID of contact record given case belongs to.
</comment>
33 <name>contact_id
</name>
34 <table>civicrm_contact
</table>
38 <onDelete>CASCADE
</onDelete>
41 <name>case_type_id
</name>
42 <type>int unsigned
</type>
44 <export>false
</export>
45 <title>Case Type
</title>
46 <comment>FK to civicrm_case_type.id
</comment>
51 <table>civicrm_case_type
</table>
52 <keyColumn>id
</keyColumn>
53 <labelColumn>title
</labelColumn>
58 <name>index_case_type_id
</name>
59 <fieldName>case_type_id
</fieldName>
63 <name>case_type_id
</name>
64 <table>civicrm_case_type
</table>
67 <onDelete>SET NULL
</onDelete>
70 <name>casetag1_id
</name>
73 <required>true
</required>
74 <comment>Id of first case category.
</comment>
79 <name>index_casetag1_id
</name>
80 <fieldName>casetag1_id
</fieldName>
85 <name>casetag2_id
</name>
88 <required>true
</required>
89 <comment>Id of second case category.
</comment>
94 <name>index_casetag2_id
</name>
95 <fieldName>casetag2_id
</fieldName>
100 <name>casetag3_id
</name>
103 <required>true
</required>
104 <comment>Id of third case category.
</comment>
109 <name>index_casetag3_id
</name>
110 <fieldName>casetag3_id
</fieldName>
118 <title>Case Subject
</title>
119 <import>true
</import>
120 <uniqueName>case_subject
</uniqueName>
121 <comment>Short name of the case.
</comment>
128 <name>start_date
</name>
129 <uniqueName>case_start_date
</uniqueName>
130 <title>Case Start Date
</title>
131 <import>true
</import>
133 <comment>Date on which given case starts.
</comment>
135 <type>Select Date
</type>
140 <name>end_date
</name>
141 <uniqueName>case_end_date
</uniqueName>
142 <title>Case End Date
</title>
143 <import>true
</import>
145 <comment>Date on which given case ends.
</comment>
147 <type>Select Date
</type>
155 <type>TextArea
</type>
159 <comment>Details about the meeting (agenda, notes, etc).
</comment>
163 <name>status_id
</name>
164 <type>int unsigned
</type>
165 <uniqueName>case_status_id
</uniqueName>
166 <required>true
</required>
167 <import>true
</import>
168 <export>false
</export>
169 <title>Case Status
</title>
170 <comment>Id of case status.
</comment>
172 <optionGroupName>case_status
</optionGroupName>
180 <name>is_deleted
</name>
181 <title>Case is in the Trash
</title>
182 <uniqueName>case_deleted
</uniqueName>
185 <import>true
</import>
186 <title>Case Deleted
</title>
190 <name>index_is_deleted
</name>
191 <fieldName>is_deleted
</fieldName>