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>
44 <required>true
</required>
46 <export>false
</export>
47 <title>Case Type Id
</title>
48 <comment>Multivalued pseudo-fk to option_value table where option_group_name = case_type.
</comment>
50 <optionGroupName>case_type
</optionGroupName>
55 <name>index_case_type_id
</name>
56 <fieldName>case_type_id
</fieldName>
60 <name>casetag1_id
</name>
63 <required>true
</required>
64 <comment>Id of first case category.
</comment>
69 <name>index_casetag1_id
</name>
70 <fieldName>casetag1_id
</fieldName>
75 <name>casetag2_id
</name>
78 <required>true
</required>
79 <comment>Id of second case category.
</comment>
84 <name>index_casetag2_id
</name>
85 <fieldName>casetag2_id
</fieldName>
90 <name>casetag3_id
</name>
93 <required>true
</required>
94 <comment>Id of third case category.
</comment>
99 <name>index_casetag3_id
</name>
100 <fieldName>casetag3_id
</fieldName>
108 <title>Case Subject
</title>
109 <import>true
</import>
110 <uniqueName>case_subject
</uniqueName>
111 <comment>Short name of the case.
</comment>
115 <name>start_date
</name>
116 <uniqueName>case_start_date
</uniqueName>
117 <title>Case Start Date
</title>
118 <import>true
</import>
120 <comment>Date on which given case starts.
</comment>
124 <name>end_date
</name>
125 <uniqueName>case_end_date
</uniqueName>
126 <title>Case End Date
</title>
127 <import>true
</import>
129 <comment>Date on which given case ends.
</comment>
136 <type>TextArea
</type>
140 <comment>Details about the meeting (agenda, notes, etc).
</comment>
144 <name>status_id
</name>
145 <type>int unsigned
</type>
146 <uniqueName>case_status_id
</uniqueName>
147 <required>true
</required>
148 <import>true
</import>
149 <export>false
</export>
150 <title>Case Status Id
</title>
151 <comment>Id of case status.
</comment>
153 <optionGroupName>case_status
</optionGroupName>
158 <name>is_deleted
</name>
159 <title>Case is in the Trash
</title>
160 <uniqueName>case_deleted
</uniqueName>
163 <import>true
</import>
164 <title>Case Deleted
</title>
168 <name>index_is_deleted
</name>
169 <fieldName>is_deleted
</fieldName>