[civicrm-core.git] / xml / schema / Contribute / ContributionSoft.xml

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

<table>
  <base>CRM/Contribute</base>
  <class>ContributionSoft</class>
  <name>civicrm_contribution_soft</name>
  <title>Contribution Soft Credit</title>
  <titlePlural>Contribution Soft Credits</titlePlural>
  <add>2.2</add>
  <log>true</log>
  <component>CiviContribute</component>
  <title>Contribution Soft Credit</title>
  <titlePlural>Contribution Soft Credits</titlePlural>
  <field>
    <name>id</name>
    <uniqueName>contribution_soft_id</uniqueName>
    <title>Soft Credit ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <import>true</import>
    <comment>Soft Credit ID</comment>
    <html>
      <type>Number</type>
    </html>
    <add>2.2</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>contribution_id</name>
    <title>Contribution ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>FK to contribution table.</comment>
    <html>
      <label>Contribution</label>
    </html>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>contribution_id</name>
    <table>civicrm_contribution</table>
    <key>id</key>
    <add>2.2</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>contact_id</name>
    <uniqueName>contribution_soft_contact_id</uniqueName>
    <title>Contact ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <import>true</import>
    <headerPattern>/contact(.?id)?/i</headerPattern>
    <dataPattern>/^\d+$/</dataPattern>
    <comment>FK to Contact ID</comment>
    <html>
      <label>Contact</label>
    </html>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>contact_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <add>2.2</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>amount</name>
    <title>Soft Credit Amount</title>
    <type>decimal</type>
    <required>true</required>
    <import>true</import>
    <headerPattern>/total(.?am(ou)?nt)?/i</headerPattern>
    <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
    <comment>Amount of this soft credit.</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>currency</name>
    <type>varchar</type>
    <title>Soft Contribution Currency</title>
    <length>3</length>
    <default>NULL</default>
    <comment>3 character string, value from config setting or input via user.</comment>
    <add>3.2</add>
    <pseudoconstant>
      <table>civicrm_currency</table>
      <keyColumn>name</keyColumn>
      <labelColumn>full_name</labelColumn>
      <nameColumn>name</nameColumn>
      <abbrColumn>symbol</abbrColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>pcp_id</name>
    <type>int unsigned</type>
    <title>PCP ID</title>
    <default>NULL</default>
    <comment>FK to civicrm_pcp.id</comment>
    <html>
      <label>PCP</label>
    </html>
    <add>2.2</add>
    <pseudoconstant>
      <table>civicrm_pcp</table>
      <keyColumn>id</keyColumn>
      <labelColumn>title</labelColumn>
    </pseudoconstant>
  </field>
  <foreignKey>
    <name>pcp_id</name>
    <table>civicrm_pcp</table>
    <key>id</key>
    <add>3.1</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <index>
    <name>index_id</name>
    <fieldName>pcp_id</fieldName>
    <add>2.2</add>
  </index>
  <field>
    <name>pcp_display_in_roll</name>
    <type>boolean</type>
    <title>Soft Contribution Display on PCP</title>
    <default>0</default>
    <required>true</required>
    <add>2.2</add>
  </field>
  <field>
    <name>pcp_roll_nickname</name>
    <type>varchar</type>
    <title>Soft Contribution PCP Nickname</title>
    <length>255</length>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <field>
    <name>pcp_personal_note</name>
    <type>varchar</type>
    <title>Soft Contribution PCP Note</title>
    <length>255</length>
    <html>
      <type>TextArea</type>
    </html>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <field>
    <name>soft_credit_type_id</name>
    <type>int unsigned</type>
    <default>NULL</default>
    <title>Soft Credit Type</title>
    <pseudoconstant>
      <optionGroupName>soft_credit_type</optionGroupName>
    </pseudoconstant>
    <comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.</comment>
    <add>2.2</add>
  </field>
</table>
Commit	Line	Data
3c7d2158	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Contribute</base>
	5	<class>ContributionSoft</class>
	6	<name>civicrm_contribution_soft</name>
65efffdd ML	7	<title>Contribution Soft Credit</title>
65efffdd ML	8	<titlePlural>Contribution Soft Credits</titlePlural>
3c7d2158	9	<add>2.2</add>
6a488035	10	<log>true</log>
d31fb4e3	11	<component>CiviContribute</component>
65efffdd ML	12	<title>Contribution Soft Credit</title>
65efffdd ML	13	<titlePlural>Contribution Soft Credits</titlePlural>
3c7d2158	14	<field>
8f069c03 EM	15	<name>id</name>
8f069c03 EM	16	<uniqueName>contribution_soft_id</uniqueName>
c95977c3	17	<title>Soft Credit ID</title>
8f069c03 EM	18	<type>int unsigned</type>
	19	<required>true</required>
	20	<import>true</import>
c95977c3	21	<comment>Soft Credit ID</comment>
0481e12c A	22	<html>
	23	<type>Number</type>
	24	</html>
8f069c03	25	<add>2.2</add>
3c7d2158	26	</field>
3c7d2158	27	<primaryKey>
8f069c03 EM	28	<name>id</name>
8f069c03 EM	29	<autoincrement>true</autoincrement>
3c7d2158	30	</primaryKey>
3c7d2158	31	<field>
8f069c03	32	<name>contribution_id</name>
047c5009	33	<title>Contribution ID</title>
8f069c03 EM	34	<type>int unsigned</type>
	35	<required>true</required>
	36	<comment>FK to contribution table.</comment>
57e94608	37	<html>
047c5009	38	<label>Contribution</label>
57e94608	39	</html>
8f069c03	40	<add>2.2</add>
3c7d2158	41	</field>
3c7d2158	42	<foreignKey>
8f069c03 EM	43	<name>contribution_id</name>
	44	<table>civicrm_contribution</table>
	45	<key>id</key>
	46	<add>2.2</add>
	47	<onDelete>CASCADE</onDelete>
6a488035	48	</foreignKey>
3c7d2158	49	<field>
8f069c03 EM	50	<name>contact_id</name>
8f069c03 EM	51	<uniqueName>contribution_soft_contact_id</uniqueName>
047c5009	52	<title>Contact ID</title>
8f069c03 EM	53	<type>int unsigned</type>
	54	<required>true</required>
	55	<import>true</import>
	56	<headerPattern>/contact(.?id)?/i</headerPattern>
	57	<dataPattern>/^\d+$/</dataPattern>
	58	<comment>FK to Contact ID</comment>
57e94608	59	<html>
047c5009	60	<label>Contact</label>
57e94608	61	</html>
8f069c03	62	<add>2.2</add>
3c7d2158	63	</field>
3c7d2158	64	<foreignKey>
8f069c03 EM	65	<name>contact_id</name>
	66	<table>civicrm_contact</table>
	67	<key>id</key>
	68	<add>2.2</add>
	69	<onDelete>CASCADE</onDelete>
3c7d2158	70	</foreignKey>
3c7d2158	71	<field>
8f069c03	72	<name>amount</name>
c95977c3	73	<title>Soft Credit Amount</title>
8f069c03 EM	74	<type>decimal</type>
	75	<required>true</required>
	76	<import>true</import>
	77	<headerPattern>/total(.?am(ou)?nt)?/i</headerPattern>
	78	<dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
c95977c3	79	<comment>Amount of this soft credit.</comment>
8f069c03	80	<add>2.2</add>
6a488035 TO	81	</field>
6a488035 TO	82	<field>
8f069c03 EM	83	<name>currency</name>
8f069c03 EM	84	<type>varchar</type>
83396bf9	85	<title>Soft Contribution Currency</title>
8f069c03 EM	86	<length>3</length>
	87	<default>NULL</default>
	88	<comment>3 character string, value from config setting or input via user.</comment>
	89	<add>3.2</add>
	90	<pseudoconstant>
	91	<table>civicrm_currency</table>
	92	<keyColumn>name</keyColumn>
	93	<labelColumn>full_name</labelColumn>
c3de5c5a	94	<nameColumn>name</nameColumn>
a8fdb24e	95	<abbrColumn>symbol</abbrColumn>
8f069c03 EM	96	</pseudoconstant>
	97	<html>
	98	<type>Select</type>
	99	</html>
6a488035	100	</field>
3c7d2158	101	<field>
8f069c03 EM	102	<name>pcp_id</name>
8f069c03 EM	103	<type>int unsigned</type>
047c5009	104	<title>PCP ID</title>
8f069c03 EM	105	<default>NULL</default>
8f069c03 EM	106	<comment>FK to civicrm_pcp.id</comment>
57e94608	107	<html>
047c5009	108	<label>PCP</label>
57e94608	109	</html>
8f069c03	110	<add>2.2</add>
3c151c70	111	<pseudoconstant>
	112	<table>civicrm_pcp</table>
	113	<keyColumn>id</keyColumn>
	114	<labelColumn>title</labelColumn>
	115	</pseudoconstant>
3c7d2158	116	</field>
6a488035	117	<foreignKey>
8f069c03 EM	118	<name>pcp_id</name>
	119	<table>civicrm_pcp</table>
	120	<key>id</key>
	121	<add>3.1</add>
	122	<onDelete>SET NULL</onDelete>
6a488035 TO	123	</foreignKey>
6a488035 TO	124	<index>
8f069c03 EM	125	<name>index_id</name>
	126	<fieldName>pcp_id</fieldName>
	127	<add>2.2</add>
	128	</index>
	129	<field>
	130	<name>pcp_display_in_roll</name>
	131	<type>boolean</type>
83396bf9	132	<title>Soft Contribution Display on PCP</title>
8f069c03	133	<default>0</default>
c1e814c7	134	<required>true</required>
8f069c03	135	<add>2.2</add>
3c7d2158	136	</field>
6a488035	137	<field>
8f069c03 EM	138	<name>pcp_roll_nickname</name>
8f069c03 EM	139	<type>varchar</type>
83396bf9	140	<title>Soft Contribution PCP Nickname</title>
8f069c03 EM	141	<length>255</length>
	142	<default>NULL</default>
	143	<add>2.2</add>
6a488035 TO	144	</field>
6a488035 TO	145	<field>
8f069c03 EM	146	<name>pcp_personal_note</name>
8f069c03 EM	147	<type>varchar</type>
83396bf9	148	<title>Soft Contribution PCP Note</title>
8f069c03	149	<length>255</length>
bddddc63	150	<html>
	151	<type>TextArea</type>
	152	</html>
8f069c03 EM	153	<default>NULL</default>
8f069c03 EM	154	<add>2.2</add>
6a488035	155	</field>
51fa20cb	156	<field>
8f069c03 EM	157	<name>soft_credit_type_id</name>
	158	<type>int unsigned</type>
	159	<default>NULL</default>
	160	<title>Soft Credit Type</title>
	161	<pseudoconstant>
	162	<optionGroupName>soft_credit_type</optionGroupName>
	163	</pseudoconstant>
	164	<comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.</comment>
	165	<add>2.2</add>
51fa20cb	166	</field>
6a488035	167	</table>