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

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

<table>
  <base>CRM/Price</base>
  <class>PriceFieldValue</class>
  <name>civicrm_price_field_value</name>
  <add>3.3</add>
  <field>
    <name>id</name>
    <title>Price Field Value ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Price Field Value</comment>
    <add>3.3</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>price_field_id</name>
    <title>Price Field</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>FK to civicrm_price_field</comment>
    <add>3.3</add>
  </field>
  <foreignKey>
    <name>price_field_id</name>
    <table>civicrm_price_field</table>
    <key>id</key>
    <add>3.3</add>
  </foreignKey>
  <field>
    <name>name</name>
    <type>varchar</type>
    <title>Name</title>
    <length>255</length>
    <comment>Price field option name</comment>
    <html>
      <type>Text</type>
    </html>
    <add>3.3</add>
    <default>NULL</default>
  </field>
  <field>
    <name>label</name>
    <type>varchar</type>
    <title>Label</title>
    <length>255</length>
    <localizable>true</localizable>
    <comment>Price field option label</comment>
    <html>
      <type>Text</type>
    </html>
    <add>3.3</add>
    <default>NULL</default>
  </field>
  <field>
    <name>description</name>
    <type>text</type>
    <html>
      <type>TextArea</type>
      <rows>2</rows>
      <cols>60</cols>
    </html>
    <default>NULL</default>
    <localizable>true</localizable>
    <comment>Price field option description.</comment>
    <add>3.3</add>
  </field>
  <field>
    <name>help_pre</name>
    <type>text</type>
    <html>
      <type>TextArea</type>
      <rows>2</rows>
      <cols>60</cols>
    </html>
    <default>NULL</default>
    <localizable>true</localizable>
    <comment>Price field option pre help text.</comment>
    <add>4.7</add>
  </field>
  <field>
    <name>help_post</name>
    <type>text</type>
    <html>
      <type>TextArea</type>
      <rows>2</rows>
      <cols>60</cols>
    </html>
    <default>NULL</default>
    <localizable>true</localizable>
    <comment>Price field option post field help.</comment>
    <add>4.7</add>
  </field>
  <field>
    <name>amount</name>
    <type>decimal</type>
    <title>Amount</title>
    <length>18,9</length>
    <html>
      <type>Text</type>
      <size>8</size>
    </html>
    <required>true</required>
    <comment>Price field option amount</comment>
    <add>3.3</add>
  </field>
  <field>
    <name>count</name>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>Number of participants per field option</comment>
    <add>3.3</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>max_value</name>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>Max number of participants per field options</comment>
    <add>3.3</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>weight</name>
    <title>Order</title>
    <type>int</type>
    <default>1</default>
    <comment>Order in which the field options should appear</comment>
    <add>3.3</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>membership_type_id</name>
    <title>Membership Type</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>FK to Membership Type</comment>
    <html>
      <type>Select</type>
    </html>
    <add>3.4</add>
  </field>
  <foreignKey>
    <name>membership_type_id</name>
    <table>civicrm_membership_type</table>
    <key>id</key>
    <add>3.4</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>membership_num_terms</name>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>Number of terms for this membership</comment>
    <add>4.3</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>is_default</name>
    <title>Is Default Price Field Option?</title>
    <type>boolean</type>
    <comment>Is this default price field option</comment>
    <default>0</default>
    <add>3.3</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>is_active</name>
    <title>Price Field Value is Active</title>
    <type>boolean</type>
    <comment>Is this price field value active</comment>
    <default>1</default>
    <add>3.3</add>
  </field>
  <field>
    <name>financial_type_id</name>
    <title>Financial Type</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <pseudoconstant>
      <table>civicrm_financial_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <comment>FK to Financial Type.</comment>
    <add>4.3</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <foreignKey>
    <name>financial_type_id</name>
    <table>civicrm_financial_type</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
    <add>4.3</add>
  </foreignKey>
  <field>
    <name>non_deductible_amount</name>
    <title>Non-deductible Amount</title>
    <type>decimal</type>
    <default>0.0</default>
    <headerPattern>/non?.?deduct/i</headerPattern>
    <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
    <required>true</required>
    <comment>Portion of total amount which is NOT tax deductible.</comment>
    <add>4.7</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>visibility_id</name>
    <title>Price Field Option Visibility</title>
    <type>int unsigned</type>
    <default>1</default>
    <comment>Implicit FK to civicrm_option_group with name = 'visibility'</comment>
    <add>4.7</add>
    <pseudoconstant>
      <optionGroupName>visibility</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</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>PriceFieldValue</class>
6a488035 TO	6	<name>civicrm_price_field_value</name>
	7	<add>3.3</add>
	8	<field>
	9	<name>id</name>
021ad66c	10	<title>Price Field Value ID</title>
6a488035 TO	11	<type>int unsigned</type>
	12	<required>true</required>
	13	<comment>Price Field Value</comment>
	14	<add>3.3</add>
	15	</field>
	16	<primaryKey>
	17	<name>id</name>
	18	<autoincrement>true</autoincrement>
	19	</primaryKey>
	20	<field>
	21	<name>price_field_id</name>
021ad66c	22	<title>Price Field</title>
6a488035 TO	23	<type>int unsigned</type>
	24	<required>true</required>
	25	<comment>FK to civicrm_price_field</comment>
	26	<add>3.3</add>
	27	</field>
	28	<foreignKey>
	29	<name>price_field_id</name>
	30	<table>civicrm_price_field</table>
	31	<key>id</key>
	32	<add>3.3</add>
	33	</foreignKey>
	34	<field>
	35	<name>name</name>
	36	<type>varchar</type>
	37	<title>Name</title>
	38	<length>255</length>
	39	<comment>Price field option name</comment>
614d72ec	40	<html>
	41	<type>Text</type>
	42	</html>
6a488035	43	<add>3.3</add>
7154c2c0	44	<default>NULL</default>
6a488035 TO	45	</field>
	46	<field>
	47	<name>label</name>
	48	<type>varchar</type>
	49	<title>Label</title>
	50	<length>255</length>
	51	<localizable>true</localizable>
	52	<comment>Price field option label</comment>
614d72ec	53	<html>
614d72ec	54	<type>Text</type>
6cc0b7bd	55	</html>
6a488035	56	<add>3.3</add>
7154c2c0	57	<default>NULL</default>
6a488035 TO	58	</field>
	59	<field>
	60	<name>description</name>
	61	<type>text</type>
7deea513	62	<html>
7deea513	63	<type>TextArea</type>
614d72ec	64	<rows>2</rows>
5435b737	65	<cols>60</cols>
614d72ec	66	</html>
6cc0b7bd	67	<default>NULL</default>
6a488035	68	<localizable>true</localizable>
509c8089	69	<comment>Price field option description.</comment>
6a488035 TO	70	<add>3.3</add>
6a488035 TO	71	</field>
5bfef8fa SL	72	<field>
	73	<name>help_pre</name>
	74	<type>text</type>
	75	<html>
	76	<type>TextArea</type>
	77	<rows>2</rows>
	78	<cols>60</cols>
	79	</html>
	80	<default>NULL</default>
	81	<localizable>true</localizable>
	82	<comment>Price field option pre help text.</comment>
	83	<add>4.7</add>
	84	</field>
	85	<field>
	86	<name>help_post</name>
	87	<type>text</type>
	88	<html>
	89	<type>TextArea</type>
	90	<rows>2</rows>
	91	<cols>60</cols>
	92	</html>
	93	<default>NULL</default>
	94	<localizable>true</localizable>
	95	<comment>Price field option post field help.</comment>
	96	<add>4.7</add>
	97	</field>
6a488035 TO	98	<field>
6a488035 TO	99	<name>amount</name>
25e0f950	100	<type>decimal</type>
6a488035	101	<title>Amount</title>
25e0f950	102	<length>18,9</length>
614d72ec	103	<html>
614d72ec	104	<type>Text</type>
54f5e87f	105	<size>8</size>
614d72ec	106	</html>
6a488035 TO	107	<required>true</required>
	108	<comment>Price field option amount</comment>
	109	<add>3.3</add>
	110	</field>
	111	<field>
	112	<name>count</name>
	113	<type>int unsigned</type>
	114	<default>NULL</default>
	115	<comment>Number of participants per field option</comment>
	116	<add>3.3</add>
614d72ec	117	<html>
	118	<type>Text</type>
	119	</html>
6a488035 TO	120	</field>
	121	<field>
	122	<name>max_value</name>
	123	<type>int unsigned</type>
	124	<default>NULL</default>
	125	<comment>Max number of participants per field options</comment>
	126	<add>3.3</add>
614d72ec	127	<html>
	128	<type>Text</type>
	129	</html>
6a488035 TO	130	</field>
	131	<field>
	132	<name>weight</name>
7ecddde4	133	<title>Order</title>
6a488035 TO	134	<type>int</type>
	135	<default>1</default>
	136	<comment>Order in which the field options should appear</comment>
	137	<add>3.3</add>
614d72ec	138	<html>
	139	<type>Text</type>
	140	</html>
6a488035 TO	141	</field>
	142	<field>
	143	<name>membership_type_id</name>
021ad66c	144	<title>Membership Type</title>
6a488035 TO	145	<type>int unsigned</type>
	146	<default>NULL</default>
	147	<comment>FK to Membership Type</comment>
614d72ec	148	<html>
	149	<type>Select</type>
	150	</html>
6a488035 TO	151	<add>3.4</add>
6a488035 TO	152	</field>
6f3f0f22	153	<foreignKey>
	154	<name>membership_type_id</name>
	155	<table>civicrm_membership_type</table>
6a488035 TO	156	<key>id</key>
	157	<add>3.4</add>
	158	<onDelete>SET NULL</onDelete>
	159	</foreignKey>
	160	<field>
	161	<name>membership_num_terms</name>
	162	<type>int unsigned</type>
	163	<default>NULL</default>
	164	<comment>Number of terms for this membership</comment>
	165	<add>4.3</add>
614d72ec	166	<html>
	167	<type>Text</type>
	168	</html>
6a488035 TO	169	</field>
	170	<field>
	171	<name>is_default</name>
021ad66c	172	<title>Is Default Price Field Option?</title>
6a488035 TO	173	<type>boolean</type>
	174	<comment>Is this default price field option</comment>
	175	<default>0</default>
	176	<add>3.3</add>
614d72ec	177	<html>
	178	<type>CheckBox</type>
	179	</html>
6a488035 TO	180	</field>
	181	<field>
	182	<name>is_active</name>
021ad66c	183	<title>Price Field Value is Active</title>
6a488035 TO	184	<type>boolean</type>
	185	<comment>Is this price field value active</comment>
	186	<default>1</default>
	187	<add>3.3</add>
	188	</field>
6f3f0f22	189	<field>
6f3f0f22	190	<name>financial_type_id</name>
6a488035	191	<title>Financial Type</title>
6f3f0f22	192	<type>int unsigned</type>
6a488035	193	<default>NULL</default>
6cc0b7bd EM	194	<pseudoconstant>
	195	<table>civicrm_financial_type</table>
	196	<keyColumn>id</keyColumn>
	197	<labelColumn>name</labelColumn>
	198	</pseudoconstant>
6a488035	199	<comment>FK to Financial Type.</comment>
6f3f0f22	200	<add>4.3</add>
614d72ec	201	<html>
	202	<type>Select</type>
	203	</html>
6f3f0f22	204	</field>
	205	<foreignKey>
	206	<name>financial_type_id</name>
	207	<table>civicrm_financial_type</table>
	208	<key>id</key>
6a488035 TO	209	<onDelete>SET NULL</onDelete>
6a488035 TO	210	<add>4.3</add>
6f3f0f22	211	</foreignKey>
6f3f0f22	212	<field>
5afce5ad	213	<name>non_deductible_amount</name>
5afce5ad	214	<title>Non-deductible Amount</title>
6f3f0f22	215	<type>decimal</type>
6a488035	216	<default>0.0</default>
5afce5ad	217	<headerPattern>/non?.?deduct/i</headerPattern>
6a488035	218	<dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
6f3f0f22	219	<required>true</required>
5afce5ad	220	<comment>Portion of total amount which is NOT tax deductible.</comment>
5afce5ad	221	<add>4.7</add>
614d72ec	222	<html>
	223	<type>Text</type>
	224	</html>
6f3f0f22	225	</field>
2db35bf6 AF	226	<field>
	227	<name>visibility_id</name>
	228	<title>Price Field Option Visibility</title>
	229	<type>int unsigned</type>
	230	<default>1</default>
	231	<comment>Implicit FK to civicrm_option_group with name = 'visibility'</comment>
	232	<add>4.7</add>
	233	<pseudoconstant>
	234	<optionGroupName>visibility</optionGroupName>
	235	</pseudoconstant>
	236	<html>
	237	<type>Select</type>
	238	</html>
	239	</field>
6a488035	240	</table>