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>
53 <name>index_case_type_id
</name>
54 <fieldName>case_type_id
</fieldName>
58 <name>case_type_id
</name>
59 <table>civicrm_case_type
</table>
62 <onDelete>SET NULL
</onDelete>
65 <name>casetag1_id
</name>
68 <required>true
</required>
69 <comment>Id of first case category.
</comment>
74 <name>index_casetag1_id
</name>
75 <fieldName>casetag1_id
</fieldName>
80 <name>casetag2_id
</name>
83 <required>true
</required>
84 <comment>Id of second case category.
</comment>
89 <name>index_casetag2_id
</name>
90 <fieldName>casetag2_id
</fieldName>
95 <name>casetag3_id
</name>
98 <required>true
</required>
99 <comment>Id of third case category.
</comment>
104 <name>index_casetag3_id
</name>
105 <fieldName>casetag3_id
</fieldName>
113 <title>Case Subject
</title>
114 <import>true
</import>
115 <uniqueName>case_subject
</uniqueName>
116 <comment>Short name of the case.
</comment>
123 <name>start_date
</name>
124 <uniqueName>case_start_date
</uniqueName>
125 <title>Case Start Date
</title>
126 <import>true
</import>
128 <comment>Date on which given case starts.
</comment>
130 <type>Select Date
</type>
135 <name>end_date
</name>
136 <uniqueName>case_end_date
</uniqueName>
137 <title>Case End Date
</title>
138 <import>true
</import>
140 <comment>Date on which given case ends.
</comment>
142 <type>Select Date
</type>
150 <type>TextArea
</type>
154 <comment>Details about the meeting (agenda, notes, etc).
</comment>
158 <name>status_id
</name>
159 <type>int unsigned
</type>
160 <uniqueName>case_status_id
</uniqueName>
161 <required>true
</required>
162 <import>true
</import>
163 <export>false
</export>
164 <title>Case Status
</title>
165 <comment>Id of case status.
</comment>
167 <optionGroupName>case_status
</optionGroupName>
175 <name>is_deleted
</name>
176 <title>Case is in the Trash
</title>
177 <uniqueName>case_deleted
</uniqueName>
180 <import>true
</import>
181 <title>Case Deleted
</title>
185 <name>index_is_deleted
</name>
186 <fieldName>is_deleted
</fieldName>