[civicrm-core.git] / xml / schema / Case / Case.xml

<?xml version="1.0" encoding="iso-8859-1" ?>
<table>
  <base>CRM/Case</base>
  <class>Case</class>
  <name>civicrm_case</name>
  <comment>This table stores information about cases grouping activities.</comment>
  <add>1.8</add>
  <log>true</log>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <uniqueName>case_id</uniqueName>
    <required>true</required>
    <import>true</import>
    <title>Case ID</title>
    <comment>Unique Case ID</comment>
    <add>1.8</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>contact_id</name>
    <type>int unsigned</type>
    <uniqueName>case_contact_id</uniqueName>
    <required>true</required>
    <comment>Contact ID of contact record given case belongs to.</comment>
    <add>1.8</add>
    <drop>2.1</drop>
  </field>
  <foreignKey>
    <name>contact_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <add>1.8</add>
    <drop>2.1</drop>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>case_type_id</name>
    <type>int unsigned</type>
    <import>true</import>
    <export>false</export>
    <title>Case Type</title>
    <comment>FK to civicrm_case_type.id</comment>
    <html>
      <type>Select</type>
    </html>
    <pseudoconstant>
      <table>civicrm_case_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>title</labelColumn>
    </pseudoconstant>
    <add>2.0</add>
  </field>
  <index>
    <name>index_case_type_id</name>
    <fieldName>case_type_id</fieldName>
    <add>2.0</add>
  </index>
  <foreignKey>
    <name>case_type_id</name>
    <table>civicrm_case_type</table>
    <key>id</key>
    <add>4.5</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>casetag1_id</name>
    <type>varchar</type>
    <length>128</length>
    <required>true</required>
    <comment>Id of first case category.</comment>
    <add>1.8</add>
    <drop>2.0</drop>
  </field>
  <index>
    <name>index_casetag1_id</name>
    <fieldName>casetag1_id</fieldName>
    <add>1.8</add>
    <drop>2.0</drop>
  </index>
  <field>
    <name>casetag2_id</name>
    <type>varchar</type>
    <length>128</length>
    <required>true</required>
    <comment>Id of second case category.</comment>
    <add>1.8</add>
    <drop>2.0</drop>
  </field>
  <index>
    <name>index_casetag2_id</name>
    <fieldName>casetag2_id</fieldName>
    <add>1.8</add>
    <drop>2.0</drop>
  </index>
  <field>
    <name>casetag3_id</name>
    <type>varchar</type>
    <length>128</length>
    <required>true</required>
    <comment>Id of third case category.</comment>
    <add>1.8</add>
    <drop>2.0</drop>
  </field>
  <index>
    <name>index_casetag3_id</name>
    <fieldName>casetag3_id</fieldName>
    <add>1.8</add>
    <drop>2.0</drop>
  </index>
  <field>
    <name>subject</name>
    <type>varchar</type>
    <length>128</length>
    <title>Case Subject</title>
    <import>true</import>
    <uniqueName>case_subject</uniqueName>
    <comment>Short name of the case.</comment>
    <html>
      <type>Text</type>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>start_date</name>
    <uniqueName>case_start_date</uniqueName>
    <title>Case Start Date</title>
    <import>true</import>
    <type>date</type>
    <comment>Date on which given case starts.</comment>
    <html>
      <type>Select Date</type>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>end_date</name>
    <uniqueName>case_end_date</uniqueName>
    <title>Case End Date</title>
    <import>true</import>
    <type>date</type>
    <comment>Date on which given case ends.</comment>
    <html>
      <type>Select Date</type>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>details</name>
    <type>text</type>
    <html>
      <type>TextArea</type>
      <rows>8</rows>
      <cols>60</cols>
    </html>
    <comment>Details about the meeting (agenda, notes, etc).</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>status_id</name>
    <type>int unsigned</type>
    <uniqueName>case_status_id</uniqueName>
    <required>true</required>
    <import>true</import>
    <export>false</export>
    <title>Case Status</title>
    <comment>Id of case status.</comment>
    <pseudoconstant>
      <optionGroupName>case_status</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>is_deleted</name>
    <title>Case is in the Trash</title>
    <uniqueName>case_deleted</uniqueName>
    <type>boolean</type>
    <default>0</default>
    <import>true</import>
    <title>Case Deleted</title>
    <add>2.2</add>
  </field>
  <index>
    <name>index_is_deleted</name>
    <fieldName>is_deleted</fieldName>
    <add>2.2</add>
  </index>
</table>
Commit	Line	Data
6a488035 TO	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>
8f069c03 EM	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>
6a488035 TO	18	</field>
6a488035 TO	19	<primaryKey>
8f069c03 EM	20	<name>id</name>
8f069c03 EM	21	<autoincrement>true</autoincrement>
6a488035 TO	22	</primaryKey>
6a488035 TO	23	<field>
8f069c03 EM	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>
6a488035 TO	31	</field>
6a488035 TO	32	<foreignKey>
8f069c03 EM	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>
3c7d2158	39	</foreignKey>
6a488035	40	<field>
8f069c03 EM	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	<comment>FK to civicrm_case_type.id</comment>
	47	<html>
	48	<type>Select</type>
	49	</html>
	50	<pseudoconstant>
	51	<table>civicrm_case_type</table>
	52	<keyColumn>id</keyColumn>
	53	<labelColumn>title</labelColumn>
	54	</pseudoconstant>
	55	<add>2.0</add>
6a488035 TO	56	</field>
6a488035 TO	57	<index>
8f069c03 EM	58	<name>index_case_type_id</name>
	59	<fieldName>case_type_id</fieldName>
	60	<add>2.0</add>
6a488035	61	</index>
fc9e7e51	62	<foreignKey>
8f069c03 EM	63	<name>case_type_id</name>
	64	<table>civicrm_case_type</table>
	65	<key>id</key>
	66	<add>4.5</add>
	67	<onDelete>SET NULL</onDelete>
fc9e7e51	68	</foreignKey>
6a488035	69	<field>
8f069c03 EM	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>
6a488035 TO	77	</field>
6a488035 TO	78	<index>
8f069c03 EM	79	<name>index_casetag1_id</name>
	80	<fieldName>casetag1_id</fieldName>
	81	<add>1.8</add>
	82	<drop>2.0</drop>
6a488035 TO	83	</index>
6a488035 TO	84	<field>
8f069c03 EM	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>
6a488035 TO	92	</field>
6a488035 TO	93	<index>
8f069c03 EM	94	<name>index_casetag2_id</name>
	95	<fieldName>casetag2_id</fieldName>
	96	<add>1.8</add>
	97	<drop>2.0</drop>
6a488035 TO	98	</index>
6a488035 TO	99	<field>
8f069c03 EM	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>
6a488035 TO	107	</field>
6a488035 TO	108	<index>
8f069c03 EM	109	<name>index_casetag3_id</name>
	110	<fieldName>casetag3_id</fieldName>
	111	<add>1.8</add>
	112	<drop>2.0</drop>
6a488035 TO	113	</index>
6a488035 TO	114	<field>
8f069c03 EM	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>
6a488035	126	</field>
8f069c03 EM	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>
6a488035 TO	138	</field>
6a488035 TO	139	<field>
8f069c03 EM	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>
6a488035 TO	150	</field>
6a488035 TO	151	<field>
8f069c03 EM	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>
6a488035 TO	161	</field>
6a488035 TO	162	<field>
8f069c03 EM	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>
6a488035 TO	178	</field>
6a488035 TO	179	<field>
8f069c03 EM	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>
6a488035 TO	188	</field>
6a488035 TO	189	<index>
8f069c03 EM	190	<name>index_is_deleted</name>
	191	<fieldName>is_deleted</fieldName>
	192	<add>2.2</add>
3c7d2158	193	</index>
6a488035	194	</table>