xml/schema/Case/Case.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2 <table>
   3   <base>CRM/Case</base>
   4   <class>Case</class>
   5   <name>civicrm_case</name>
   6   <comment>This table stores information about cases grouping activities.</comment>
   7   <add>1.8</add>
   8   <log>true</log>
   9   <field>
  10     <name>id</name>
  11     <type>int unsigned</type>
  12     <uniqueName>case_id</uniqueName>
  13     <required>true</required>
  14     <import>true</import>
  15     <title>Case ID</title>
  16     <comment>Unique Case ID</comment>
  17     <add>1.8</add>
  18   </field>
  19   <primaryKey>
  20     <name>id</name>
  21     <autoincrement>true</autoincrement>
  22   </primaryKey>
  23   <field>
  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>
  29     <add>1.8</add>
  30     <drop>2.1</drop>
  31   </field>
  32   <foreignKey>
  33     <name>contact_id</name>
  34     <table>civicrm_contact</table>
  35     <key>id</key>
  36     <add>1.8</add>
  37     <drop>2.1</drop>
  38     <onDelete>CASCADE</onDelete>
  39   </foreignKey>
  40   <field>
  41     <name>case_type_id</name>
  42     <type>int unsigned</type>
  43     <import>true</import>
  44     <export>false</export>
  45     <title>Case Type</title>
  46     <required>true</required>
  47     <comment>FK to civicrm_case_type.id</comment>
  48     <html>
  49       <type>Select</type>
  50     </html>
  51     <pseudoconstant>
  52       <table>civicrm_case_type</table>
  53       <keyColumn>id</keyColumn>
  54       <labelColumn>title</labelColumn>
  55     </pseudoconstant>
  56     <add>2.0</add>
  57   </field>
  58   <index>
  59     <name>index_case_type_id</name>
  60     <fieldName>case_type_id</fieldName>
  61     <add>2.0</add>
  62   </index>
  63   <foreignKey>
  64     <name>case_type_id</name>
  65     <table>civicrm_case_type</table>
  66     <key>id</key>
  67     <add>4.5</add>
  68   </foreignKey>
  69   <field>
  70     <name>casetag1_id</name>
  71     <type>varchar</type>
  72     <length>128</length>
  73     <required>true</required>
  74     <comment>Id of first case category.</comment>
  75     <add>1.8</add>
  76     <drop>2.0</drop>
  77   </field>
  78   <index>
  79     <name>index_casetag1_id</name>
  80     <fieldName>casetag1_id</fieldName>
  81     <add>1.8</add>
  82     <drop>2.0</drop>
  83   </index>
  84   <field>
  85     <name>casetag2_id</name>
  86     <type>varchar</type>
  87     <length>128</length>
  88     <required>true</required>
  89     <comment>Id of second case category.</comment>
  90     <add>1.8</add>
  91     <drop>2.0</drop>
  92   </field>
  93   <index>
  94     <name>index_casetag2_id</name>
  95     <fieldName>casetag2_id</fieldName>
  96     <add>1.8</add>
  97     <drop>2.0</drop>
  98   </index>
  99   <field>
 100     <name>casetag3_id</name>
 101     <type>varchar</type>
 102     <length>128</length>
 103     <required>true</required>
 104     <comment>Id of third case category.</comment>
 105     <add>1.8</add>
 106     <drop>2.0</drop>
 107   </field>
 108   <index>
 109     <name>index_casetag3_id</name>
 110     <fieldName>casetag3_id</fieldName>
 111     <add>1.8</add>
 112     <drop>2.0</drop>
 113   </index>
 114   <field>
 115     <name>subject</name>
 116     <type>varchar</type>
 117     <length>128</length>
 118     <title>Case Subject</title>
 119     <import>true</import>
 120     <uniqueName>case_subject</uniqueName>
 121     <comment>Short name of the case.</comment>
 122     <html>
 123       <type>Text</type>
 124     </html>
 125     <add>1.8</add>
 126   </field>
 127   <field>
 128     <name>start_date</name>
 129     <uniqueName>case_start_date</uniqueName>
 130     <title>Case Start Date</title>
 131     <import>true</import>
 132     <type>date</type>
 133     <comment>Date on which given case starts.</comment>
 134     <html>
 135       <type>Select Date</type>
 136     </html>
 137     <add>1.8</add>
 138   </field>
 139   <field>
 140     <name>end_date</name>
 141     <uniqueName>case_end_date</uniqueName>
 142     <title>Case End Date</title>
 143     <import>true</import>
 144     <type>date</type>
 145     <comment>Date on which given case ends.</comment>
 146     <html>
 147       <type>Select Date</type>
 148     </html>
 149     <add>1.8</add>
 150   </field>
 151   <field>
 152     <name>details</name>
 153     <type>text</type>
 154     <html>
 155       <type>TextArea</type>
 156       <rows>8</rows>
 157       <cols>60</cols>
 158     </html>
 159     <comment>Details about the meeting (agenda, notes, etc).</comment>
 160     <add>1.8</add>
 161   </field>
 162   <field>
 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>
 171     <pseudoconstant>
 172       <optionGroupName>case_status</optionGroupName>
 173     </pseudoconstant>
 174     <html>
 175       <type>Select</type>
 176     </html>
 177     <add>1.8</add>
 178   </field>
 179   <field>
 180     <name>is_deleted</name>
 181     <title>Case is in the Trash</title>
 182     <uniqueName>case_deleted</uniqueName>
 183     <type>boolean</type>
 184     <default>0</default>
 185     <import>true</import>
 186     <title>Case Deleted</title>
 187     <add>2.2</add>
 188   </field>
 189   <index>
 190     <name>index_is_deleted</name>
 191     <fieldName>is_deleted</fieldName>
 192     <add>2.2</add>
 193   </index>
 194 </table>