[civicrm-core.git] / xml / schema / Price / PriceSet.xml

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

<table>
  <base>CRM/Price</base>
  <class>PriceSet</class>
  <name>civicrm_price_set</name>
  <add>1.8</add>
  <log>true</log>
  <component>CiviContribute</component>
  <field>
    <name>id</name>
    <title>Price Set</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Price Set</comment>
    <html>
      <type>Number</type>
      <label>ID</label>
    </html>
    <add>1.8</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>domain_id</name>
    <title>Domain ID</title>
    <type>int unsigned</type>
    <pseudoconstant>
      <table>civicrm_domain</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <comment>Which Domain is this price-set for</comment>
    <add>3.1</add>
    <html>
      <type>Text</type>
      <label>Domain</label>
    </html>
  </field>
  <foreignKey>
    <name>domain_id</name>
    <table>civicrm_domain</table>
    <key>id</key>
    <add>3.1</add>
  </foreignKey>
  <field>
    <name>name</name>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <comment>Variable name/programmatic handle for this set of price fields.</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
      <label>Name</label>
    </html>
  </field>
  <index>
    <name>UI_name</name>
    <fieldName>name</fieldName>
    <unique>true</unique>
    <add>1.8</add>
  </index>
  <field>
    <name>title</name>
    <title>Price Set Title</title>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <localizable>true</localizable>
    <comment>Displayed title for the Price Set.</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>is_active</name>
    <title>Price Set Is Active?</title>
    <type>boolean</type>
    <default>1</default>
    <required>true</required>
    <comment>Is this price set active</comment>
    <add>1.8</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>help_pre</name>
    <title>Price Set Pre Help</title>
    <type>text</type>
    <localizable>true</localizable>
    <comment>Description and/or help text to display before fields in form.</comment>
    <html>
      <type>TextArea</type>
      <rows>4</rows>
      <cols>80</cols>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>help_post</name>
    <title>Price Set Post Help</title>
    <type>text</type>
    <localizable>true</localizable>
    <comment>Description and/or help text to display after fields in form.</comment>
    <html>
      <type>TextArea</type>
      <rows>4</rows>
      <cols>80</cols>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>javascript</name>
    <title>Price Set Javascript</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>extends</name>
    <title>Price Set Extends</title>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <comment>What components are using this price set?</comment>
    <pseudoconstant>
      <table>civicrm_component</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <add>3.1</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>financial_type_id</name>
    <title>Financial Type ID</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>FK to Financial Type(for membership price sets only).</comment>
    <add>4.3</add>
    <pseudoconstant>
      <table>civicrm_financial_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
      <label>Financial Type</label>
    </html>
  </field>
  <foreignKey>
    <name>financial_type_id</name>
    <table>civicrm_financial_type</table>
    <key>id</key>
    <add>4.3</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>is_quick_config</name>
    <title>Is Price Set Quick Config?</title>
    <type>boolean</type>
    <default>0</default>
    <required>true</required>
    <comment>Is set if edited on Contribution or Event Page rather than through Manage Price Sets</comment>
    <html>
      <type>CheckBox</type>
    </html>
    <add>4.1</add>
  </field>
  <field>
    <name>is_reserved</name>
    <title>Price Set Is Reserved</title>
    <type>boolean</type>
    <default>0</default>
    <required>true</required>
    <comment>Is this a predefined system price set  (i.e. it can not be deleted, edited)?</comment>
    <add>4.2</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>min_amount</name>
    <title>Minimum Amount</title>
    <type>decimal</type>
    <default>0.0</default>
    <comment>Minimum Amount required for this set.</comment>
    <add>4.7</add>
    <html>
      <type>Text</type>
    </html>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Price</base>
9da8dc8c	5	<class>PriceSet</class>
6a488035 TO	6	<name>civicrm_price_set</name>
	7	<add>1.8</add>
	8	<log>true</log>
d31fb4e3	9	<component>CiviContribute</component>
6a488035 TO	10	<field>
6a488035 TO	11	<name>id</name>
a0a2c91d	12	<title>Price Set</title>
6a488035 TO	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<comment>Price Set</comment>
a0a2c91d	16	<html>
0481e12c	17	<type>Number</type>
fd735f54	18	<label>ID</label>
a0a2c91d	19	</html>
0481e12c	20	<add>1.8</add>
6a488035 TO	21	</field>
	22	<primaryKey>
	23	<name>id</name>
	24	<autoincrement>true</autoincrement>
	25	</primaryKey>
	26	<field>
	27	<name>domain_id</name>
047c5009	28	<title>Domain ID</title>
6a488035	29	<type>int unsigned</type>
c2b4755a EM	30	<pseudoconstant>
	31	<table>civicrm_domain</table>
	32	<keyColumn>id</keyColumn>
	33	<labelColumn>name</labelColumn>
	34	</pseudoconstant>
6a488035 TO	35	<comment>Which Domain is this price-set for</comment>
6a488035 TO	36	<add>3.1</add>
614d72ec	37	<html>
614d72ec	38	<type>Text</type>
047c5009	39	<label>Domain</label>
614d72ec	40	</html>
6a488035 TO	41	</field>
	42	<foreignKey>
	43	<name>domain_id</name>
	44	<table>civicrm_domain</table>
	45	<key>id</key>
	46	<add>3.1</add>
	47	</foreignKey>
	48	<field>
	49	<name>name</name>
	50	<type>varchar</type>
	51	<length>255</length>
	52	<required>true</required>
	53	<comment>Variable name/programmatic handle for this set of price fields.</comment>
	54	<add>1.8</add>
614d72ec	55	<html>
614d72ec	56	<type>Text</type>
fd735f54	57	<label>Name</label>
614d72ec	58	</html>
6a488035 TO	59	</field>
	60	<index>
	61	<name>UI_name</name>
	62	<fieldName>name</fieldName>
	63	<unique>true</unique>
	64	<add>1.8</add>
	65	</index>
	66	<field>
	67	<name>title</name>
021ad66c	68	<title>Price Set Title</title>
6a488035 TO	69	<type>varchar</type>
	70	<length>255</length>
	71	<required>true</required>
	72	<localizable>true</localizable>
	73	<comment>Displayed title for the Price Set.</comment>
	74	<add>1.8</add>
614d72ec	75	<html>
	76	<type>Text</type>
	77	</html>
6a488035 TO	78	</field>
	79	<field>
	80	<name>is_active</name>
021ad66c	81	<title>Price Set Is Active?</title>
6a488035 TO	82	<type>boolean</type>
6a488035 TO	83	<default>1</default>
c1e814c7	84	<required>true</required>
6a488035 TO	85	<comment>Is this price set active</comment>
6a488035 TO	86	<add>1.8</add>
614d72ec	87	<html>
	88	<type>CheckBox</type>
	89	</html>
6a488035 TO	90	</field>
	91	<field>
	92	<name>help_pre</name>
021ad66c	93	<title>Price Set Pre Help</title>
6a488035 TO	94	<type>text</type>
	95	<localizable>true</localizable>
	96	<comment>Description and/or help text to display before fields in form.</comment>
7deea513	97	<html>
7deea513	98	<type>TextArea</type>
817807ab	99	<rows>4</rows>
817807ab	100	<cols>80</cols>
7deea513	101	</html>
6a488035 TO	102	<add>1.8</add>
	103	</field>
	104	<field>
	105	<name>help_post</name>
021ad66c	106	<title>Price Set Post Help</title>
6a488035 TO	107	<type>text</type>
	108	<localizable>true</localizable>
	109	<comment>Description and/or help text to display after fields in form.</comment>
7deea513	110	<html>
7deea513	111	<type>TextArea</type>
817807ab	112	<rows>4</rows>
817807ab	113	<cols>80</cols>
7deea513	114	</html>
6a488035 TO	115	<add>1.8</add>
	116	</field>
	117	<field>
	118	<name>javascript</name>
021ad66c	119	<title>Price Set Javascript</title>
6a488035 TO	120	<type>varchar</type>
	121	<length>64</length>
	122	<comment>Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional</comment>
	123	<add>1.8</add>
614d72ec	124	<html>
614d72ec	125	<type>Text</type>
6cc0b7bd	126	</html>
6a488035 TO	127	</field>
	128	<field>
	129	<name>extends</name>
021ad66c	130	<title>Price Set Extends</title>
6a488035 TO	131	<type>varchar</type>
	132	<length>255</length>
	133	<required>true</required>
	134	<comment>What components are using this price set?</comment>
6cc0b7bd EM	135	<pseudoconstant>
	136	<table>civicrm_component</table>
	137	<keyColumn>id</keyColumn>
	138	<labelColumn>name</labelColumn>
	139	</pseudoconstant>
6a488035	140	<add>3.1</add>
614d72ec	141	<html>
	142	<type>Text</type>
	143	</html>
6a488035	144	</field>
6f3f0f22	145	<field>
6f3f0f22	146	<name>financial_type_id</name>
57e94608	147	<title>Financial Type ID</title>
6f3f0f22	148	<type>int unsigned</type>
6a488035 TO	149	<default>NULL</default>
6a488035 TO	150	<comment>FK to Financial Type(for membership price sets only).</comment>
6f3f0f22	151	<add>4.3</add>
6cc0b7bd EM	152	<pseudoconstant>
	153	<table>civicrm_financial_type</table>
	154	<keyColumn>id</keyColumn>
	155	<labelColumn>name</labelColumn>
	156	</pseudoconstant>
614d72ec	157	<html>
614d72ec	158	<type>Select</type>
57e94608	159	<label>Financial Type</label>
614d72ec	160	</html>
6f3f0f22	161	</field>
	162	<foreignKey>
	163	<name>financial_type_id</name>
	164	<table>civicrm_financial_type</table>
	165	<key>id</key>
	166	<add>4.3</add>
6a488035	167	<onDelete>SET NULL</onDelete>
6f3f0f22	168	</foreignKey>
6a488035 TO	169	<field>
6a488035 TO	170	<name>is_quick_config</name>
021ad66c	171	<title>Is Price Set Quick Config?</title>
6f3f0f22	172	<type>boolean</type>
6a488035	173	<default>0</default>
c1e814c7	174	<required>true</required>
6a488035	175	<comment>Is set if edited on Contribution or Event Page rather than through Manage Price Sets</comment>
614d72ec	176	<html>
	177	<type>CheckBox</type>
	178	</html>
6a488035 TO	179	<add>4.1</add>
	180	</field>
	181	<field>
	182	<name>is_reserved</name>
021ad66c	183	<title>Price Set Is Reserved</title>
6a488035 TO	184	<type>boolean</type>
6a488035 TO	185	<default>0</default>
c1e814c7	186	<required>true</required>
6a488035 TO	187	<comment>Is this a predefined system price set (i.e. it can not be deleted, edited)?</comment>
6a488035 TO	188	<add>4.2</add>
614d72ec	189	<html>
	190	<type>CheckBox</type>
	191	</html>
6a488035	192	</field>
601c7a24	193	<field>
	194	<name>min_amount</name>
	195	<title>Minimum Amount</title>
f5e61d50 PN	196	<type>decimal</type>
f5e61d50 PN	197	<default>0.0</default>
601c7a24	198	<comment>Minimum Amount required for this set.</comment>
	199	<add>4.7</add>
	200	<html>
	201	<type>Text</type>
	202	</html>
	203	</field>
6a488035	204	</table>