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

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Batch</base>
  <class>Batch</class>
  <name>civicrm_batch</name>
  <comment>Stores the details of a batch operation Used primarily when doing batch operations with an external system.</comment>
  <add>3.3</add>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Unique Address ID</comment>
    <add>3.3</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Variable name/programmatic handle for this batch.</comment>
    <add>3.3</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <index>
    <name>UI_name</name>
    <fieldName>name</fieldName>
    <unique>true</unique>
    <add>4.2</add>
  </index>
  <field>
    <name>label</name>
    <type>varchar</type>
    <length>64</length>
    <localizable>true</localizable>
    <comment>Friendly Name.</comment>
    <add>3.3</add>
    <drop>4.2</drop>
  </field>
  <field>
    <name>title</name>
    <type>varchar</type>
    <length>64</length>
    <localizable>true</localizable>
    <comment>Friendly Name.</comment>
    <add>4.2</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>description</name>
    <type>text</type>
    <comment>Description of this batch set.</comment>
    <localizable>true</localizable>
    <html>
      <type>TextArea</type>
      <rows>4</rows>
      <cols>80</cols>
    </html>
    <add>3.3</add>
  </field>
  <field>
    <name>created_id</name>
    <type>int unsigned</type>
    <comment>FK to Contact ID</comment>
    <add>3.3</add>
  </field>
  <foreignKey>
    <name>created_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <add>3.3</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>created_date</name>
    <type>datetime</type>
    <comment>When was this item created</comment>
    <add>3.3</add>
    <html>
      <type>Select Date</type>
    </html>
  </field>
  <field>
    <name>modified_id</name>
    <type>int unsigned</type>
    <comment>FK to Contact ID</comment>
    <add>3.3</add>
  </field>
  <field>
    <name>modified_date</name>
    <type>datetime</type>
    <comment>When was this item created</comment>
    <add>3.3</add>
  </field>
  <foreignKey>
    <name>modified_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <add>3.3</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>saved_search_id</name>
    <type>int unsigned</type>
    <comment>FK to Saved Search ID</comment>
    <add>4.1</add>
    <html>
      <type>Autocomplete-Select</type>
    </html>
  </field>
  <foreignKey>
    <name>saved_search_id</name>
    <table>civicrm_saved_search</table>
    <key>id</key>
    <add>4.2</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>status_id</name>
    <type>int unsigned</type>
    <required>true</required>
    <comment>fk to Batch Status options in civicrm_option_values</comment>
    <add>4.2</add>
    <pseudoconstant>
      <optionGroupName>batch_status</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>type_id</name>
    <type>int unsigned</type>
    <comment>fk to Batch Type options in civicrm_option_values</comment>
    <add>4.2</add>
    <pseudoconstant>
      <optionGroupName>batch_type</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>mode_id</name>
    <type>int unsigned</type>
    <comment>fk to Batch mode options in civicrm_option_values</comment>
    <add>4.2</add>
    <pseudoconstant>
      <optionGroupName>batch_mode</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>total</name>
    <type>decimal</type>
    <comment>Total amount for this batch.</comment>
    <add>4.2</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>item_count</name>
    <type>int unsigned</type>
    <comment>Number of items in a batch.</comment>
    <add>4.2</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>payment_instrument_id</name>
    <type>int unsigned</type>
    <comment>fk to Payment Instrument options in civicrm_option_values</comment>
    <pseudoconstant>
      <optionGroupName>payment_instrument</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
    <add>4.3</add>
  </field>
  <field>
    <name>exported_date</name>
    <type>datetime</type>
    <add>4.3</add>
  </field>
  <field>
    <name>data</name>
    <type>longtext</type>
    <comment>cache entered data</comment>
    <add>4.4</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Batch</base>
	5	<class>Batch</class>
	6	<name>civicrm_batch</name>
	7	<comment>Stores the details of a batch operation Used primarily when doing batch operations with an external system.</comment>
	8	<add>3.3</add>
	9	<field>
	10	<name>id</name>
	11	<type>int unsigned</type>
	12	<required>true</required>
	13	<comment>Unique Address ID</comment>
	14	<add>3.3</add>
	15	</field>
	16	<primaryKey>
	17	<name>id</name>
	18	<autoincrement>true</autoincrement>
	19	</primaryKey>
	20	<field>
	21	<name>name</name>
	22	<type>varchar</type>
	23	<length>64</length>
	24	<comment>Variable name/programmatic handle for this batch.</comment>
	25	<add>3.3</add>
614d72ec	26	<html>
	27	<type>Text</type>
	28	</html>
6a488035 TO	29	</field>
	30	<index>
	31	<name>UI_name</name>
	32	<fieldName>name</fieldName>
	33	<unique>true</unique>
	34	<add>4.2</add>
	35	</index>
	36	<field>
	37	<name>label</name>
	38	<type>varchar</type>
	39	<length>64</length>
	40	<localizable>true</localizable>
	41	<comment>Friendly Name.</comment>
	42	<add>3.3</add>
	43	<drop>4.2</drop>
	44	</field>
	45	<field>
	46	<name>title</name>
	47	<type>varchar</type>
	48	<length>64</length>
	49	<localizable>true</localizable>
	50	<comment>Friendly Name.</comment>
	51	<add>4.2</add>
614d72ec	52	<html>
	53	<type>Text</type>
	54	</html>
6a488035 TO	55	</field>
	56	<field>
	57	<name>description</name>
	58	<type>text</type>
	59	<comment>Description of this batch set.</comment>
	60	<localizable>true</localizable>
7deea513	61	<html>
7deea513	62	<type>TextArea</type>
817807ab	63	<rows>4</rows>
817807ab	64	<cols>80</cols>
7deea513	65	</html>
6a488035 TO	66	<add>3.3</add>
	67	</field>
	68	<field>
	69	<name>created_id</name>
	70	<type>int unsigned</type>
	71	<comment>FK to Contact ID</comment>
	72	<add>3.3</add>
	73	</field>
	74	<foreignKey>
	75	<name>created_id</name>
	76	<table>civicrm_contact</table>
	77	<key>id</key>
	78	<add>3.3</add>
	79	<onDelete>SET NULL</onDelete>
	80	</foreignKey>
	81	<field>
	82	<name>created_date</name>
	83	<type>datetime</type>
	84	<comment>When was this item created</comment>
	85	<add>3.3</add>
614d72ec	86	<html>
	87	<type>Select Date</type>
	88	</html>
6a488035 TO	89	</field>
	90	<field>
	91	<name>modified_id</name>
	92	<type>int unsigned</type>
	93	<comment>FK to Contact ID</comment>
	94	<add>3.3</add>
	95	</field>
	96	<field>
	97	<name>modified_date</name>
	98	<type>datetime</type>
	99	<comment>When was this item created</comment>
	100	<add>3.3</add>
	101	</field>
	102	<foreignKey>
	103	<name>modified_id</name>
	104	<table>civicrm_contact</table>
	105	<key>id</key>
	106	<add>3.3</add>
	107	<onDelete>SET NULL</onDelete>
	108	</foreignKey>
	109	<field>
	110	<name>saved_search_id</name>
	111	<type>int unsigned</type>
	112	<comment>FK to Saved Search ID</comment>
	113	<add>4.1</add>
614d72ec	114	<html>
	115	<type>Autocomplete-Select</type>
	116	</html>
6a488035 TO	117	</field>
	118	<foreignKey>
	119	<name>saved_search_id</name>
	120	<table>civicrm_saved_search</table>
	121	<key>id</key>
	122	<add>4.2</add>
	123	<onDelete>SET NULL</onDelete>
	124	</foreignKey>
	125	<field>
	126	<name>status_id</name>
	127	<type>int unsigned</type>
	128	<required>true</required>
	129	<comment>fk to Batch Status options in civicrm_option_values</comment>
	130	<add>4.2</add>
97afa853 AS	131	<pseudoconstant>
	132	<optionGroupName>batch_status</optionGroupName>
	133	</pseudoconstant>
614d72ec	134	<html>
e0991796	135	<type>Select</type>
614d72ec	136	</html>
6a488035 TO	137	</field>
	138	<field>
	139	<name>type_id</name>
	140	<type>int unsigned</type>
	141	<comment>fk to Batch Type options in civicrm_option_values</comment>
	142	<add>4.2</add>
97afa853 AS	143	<pseudoconstant>
	144	<optionGroupName>batch_type</optionGroupName>
	145	</pseudoconstant>
614d72ec	146	<html>
e0991796	147	<type>Select</type>
614d72ec	148	</html>
6a488035 TO	149	</field>
	150	<field>
	151	<name>mode_id</name>
	152	<type>int unsigned</type>
	153	<comment>fk to Batch mode options in civicrm_option_values</comment>
	154	<add>4.2</add>
e7e657f0 AS	155	<pseudoconstant>
	156	<optionGroupName>batch_mode</optionGroupName>
	157	</pseudoconstant>
614d72ec	158	<html>
e0991796	159	<type>Select</type>
614d72ec	160	</html>
6a488035 TO	161	</field>
	162	<field>
	163	<name>total</name>
	164	<type>decimal</type>
	165	<comment>Total amount for this batch.</comment>
	166	<add>4.2</add>
614d72ec	167	<html>
	168	<type>Text</type>
	169	</html>
6a488035 TO	170	</field>
	171	<field>
	172	<name>item_count</name>
	173	<type>int unsigned</type>
	174	<comment>Number of items in a batch.</comment>
	175	<add>4.2</add>
614d72ec	176	<html>
	177	<type>Text</type>
	178	</html>
6a488035 TO	179	</field>
	180	<field>
	181	<name>payment_instrument_id</name>
	182	<type>int unsigned</type>
	183	<comment>fk to Payment Instrument options in civicrm_option_values</comment>
6d68a4cb CW	184	<pseudoconstant>
	185	<optionGroupName>payment_instrument</optionGroupName>
	186	</pseudoconstant>
614d72ec	187	<html>
e0991796	188	<type>Select</type>
614d72ec	189	</html>
6a488035 TO	190	<add>4.3</add>
	191	</field>
	192	<field>
	193	<name>exported_date</name>
	194	<type>datetime</type>
	195	<add>4.3</add>
	196	</field>
638aee74	197	<field>
	198	<name>data</name>
	199	<type>longtext</type>
	200	<comment>cache entered data</comment>
	201	<add>4.4</add>
	202	</field>
6a488035	203	</table>