[civicrm-core.git] / xml / schema / Pledge / PledgePayment.xml

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

<table>
  <base>CRM/Pledge</base>
  <class>PledgePayment</class>
  <name>civicrm_pledge_payment</name>
  <comment>Pledge Payment</comment>
  <add>2.1</add>
  <log>true</log>
  <component>CiviPledge</component>
  <field>
    <name>id</name>
    <uniqueName>pledge_payment_id</uniqueName>
    <title>Payment ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <import>true</import>
    <html>
      <type>Number</type>
    </html>
    <add>2.1</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>pledge_id</name>
    <title>Pledge ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>FK to Pledge table</comment>
    <html>
      <label>Pledge</label>
    </html>
    <add>2.1</add>
  </field>
  <foreignKey>
    <name>pledge_id</name>
    <table>civicrm_pledge</table>
    <key>id</key>
    <add>2.1</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>contribution_id</name>
    <title>Contribution ID</title>
    <type>int unsigned</type>
    <comment>FK to contribution table.</comment>
    <html>
      <label>Contribution</label>
    </html>
    <add>2.1</add>
  </field>
  <foreignKey>
    <name>contribution_id</name>
    <table>civicrm_contribution</table>
    <key>id</key>
    <add>2.1</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <index>
    <name>index_contribution_pledge</name>
    <fieldName>contribution_id</fieldName>
    <fieldName>pledge_id</fieldName>
    <add>2.1</add>
  </index>
  <field>
    <name>scheduled_amount</name>
    <uniqueName>pledge_payment_scheduled_amount</uniqueName>
    <title>Scheduled Amount</title>
    <import>true</import>
    <export>true</export>
    <type>decimal</type>
    <required>true</required>
    <comment>Pledged amount for this payment (the actual contribution amount might be different).</comment>
    <add>2.1</add>
  </field>
  <field>
    <name>actual_amount</name>
    <uniqueName>pledge_payment_actual_amount</uniqueName>
    <title>Actual Amount</title>
    <import>true</import>
    <type>decimal</type>
    <comment>Actual amount that is paid as the Pledged installment amount.</comment>
    <add>3.2</add>
  </field>
  <field>
    <name>currency</name>
    <title>Currency</title>
    <type>varchar</type>
    <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>scheduled_date</name>
    <uniqueName>pledge_payment_scheduled_date</uniqueName>
    <title>Scheduled Date</title>
    <import>true</import>
    <export>true</export>
    <type>datetime</type>
    <required>true</required>
    <comment>The date the pledge payment is supposed to happen.</comment>
    <add>2.1</add>
    <html>
      <type>Select Date</type>
      <formatType>activityDate</formatType>
    </html>
    <uniqueTitle>Payment Scheduled</uniqueTitle>
  </field>
  <field>
    <name>reminder_date</name>
    <uniqueName>pledge_payment_reminder_date</uniqueName>
    <title>Last Reminder</title>
    <import>true</import>
    <type>datetime</type>
    <comment>The date that the most recent payment reminder was sent.</comment>
    <add>2.1</add>
  </field>
  <field>
    <name>reminder_count</name>
    <uniqueName>pledge_payment_reminder_count</uniqueName>
    <title>Reminders Sent</title>
    <import>true</import>
    <type>int unsigned</type>
    <default>0</default>
    <comment>The number of payment reminders sent.</comment>
    <add>2.1</add>
  </field>
  <field>
    <name>status_id</name>
    <title>Payment Status</title>
    <uniqueName>pledge_payment_status_id</uniqueName>
    <import>true</import>
    <export>false</export>
    <type>int unsigned</type>
    <add>2.1</add>
    <pseudoconstant>
      <optionGroupName>contribution_status</optionGroupName>
    </pseudoconstant>
  </field>
  <index>
    <name>index_status</name>
    <fieldName>status_id</fieldName>
    <add>2.1</add>
  </index>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Pledge</base>
	5	<class>PledgePayment</class>
	6	<name>civicrm_pledge_payment</name>
	7	<comment>Pledge Payment</comment>
	8	<add>2.1</add>
	9	<log>true</log>
d31fb4e3	10	<component>CiviPledge</component>
6a488035	11	<field>
e244747c EM	12	<name>id</name>
	13	<uniqueName>pledge_payment_id</uniqueName>
	14	<title>Payment ID</title>
	15	<type>int unsigned</type>
	16	<required>true</required>
	17	<import>true</import>
0481e12c A	18	<html>
	19	<type>Number</type>
	20	</html>
e244747c	21	<add>2.1</add>
6a488035 TO	22	</field>
6a488035 TO	23	<primaryKey>
e244747c EM	24	<name>id</name>
e244747c EM	25	<autoincrement>true</autoincrement>
6a488035 TO	26	</primaryKey>
6a488035 TO	27	<field>
e244747c	28	<name>pledge_id</name>
57e94608	29	<title>Pledge ID</title>
e244747c EM	30	<type>int unsigned</type>
	31	<required>true</required>
	32	<comment>FK to Pledge table</comment>
57e94608 A	33	<html>
	34	<label>Pledge</label>
	35	</html>
e244747c	36	<add>2.1</add>
6a488035	37	</field>
3c7d2158	38	<foreignKey>
	39	<name>pledge_id</name>
	40	<table>civicrm_pledge</table>
	41	<key>id</key>
6a488035 TO	42	<add>2.1</add>
6a488035 TO	43	<onDelete>CASCADE</onDelete>
3c7d2158	44	</foreignKey>
6a488035	45	<field>
e244747c	46	<name>contribution_id</name>
57e94608	47	<title>Contribution ID</title>
e244747c EM	48	<type>int unsigned</type>
e244747c EM	49	<comment>FK to contribution table.</comment>
57e94608 A	50	<html>
	51	<label>Contribution</label>
	52	</html>
e244747c	53	<add>2.1</add>
6a488035	54	</field>
3c7d2158	55	<foreignKey>
	56	<name>contribution_id</name>
	57	<table>civicrm_contribution</table>
	58	<key>id</key>
6a488035 TO	59	<add>2.1</add>
6a488035 TO	60	<onDelete>CASCADE</onDelete>
3c7d2158	61	</foreignKey>
6a488035 TO	62	<index>
	63	<name>index_contribution_pledge</name>
	64	<fieldName>contribution_id</fieldName>
	65	<fieldName>pledge_id</fieldName>
	66	<add>2.1</add>
	67	</index>
	68	<field>
e244747c EM	69	<name>scheduled_amount</name>
	70	<uniqueName>pledge_payment_scheduled_amount</uniqueName>
	71	<title>Scheduled Amount</title>
	72	<import>true</import>
c4853004	73	<export>true</export>
e244747c EM	74	<type>decimal</type>
	75	<required>true</required>
	76	<comment>Pledged amount for this payment (the actual contribution amount might be different).</comment>
	77	<add>2.1</add>
6a488035 TO	78	</field>
6a488035 TO	79	<field>
e244747c EM	80	<name>actual_amount</name>
	81	<uniqueName>pledge_payment_actual_amount</uniqueName>
	82	<title>Actual Amount</title>
	83	<import>true</import>
	84	<type>decimal</type>
	85	<comment>Actual amount that is paid as the Pledged installment amount.</comment>
	86	<add>3.2</add>
6a488035 TO	87	</field>
6a488035 TO	88	<field>
e244747c	89	<name>currency</name>
e9029de3	90	<title>Currency</title>
e244747c EM	91	<type>varchar</type>
	92	<length>3</length>
	93	<default>NULL</default>
	94	<comment>3 character string, value from config setting or input via user.</comment>
	95	<add>3.2</add>
	96	<pseudoconstant>
	97	<table>civicrm_currency</table>
	98	<keyColumn>name</keyColumn>
	99	<labelColumn>full_name</labelColumn>
c3de5c5a	100	<nameColumn>name</nameColumn>
a8fdb24e	101	<abbrColumn>symbol</abbrColumn>
e244747c EM	102	</pseudoconstant>
	103	<html>
	104	<type>Select</type>
	105	</html>
6a488035 TO	106	</field>
6a488035 TO	107	<field>
e244747c EM	108	<name>scheduled_date</name>
	109	<uniqueName>pledge_payment_scheduled_date</uniqueName>
	110	<title>Scheduled Date</title>
	111	<import>true</import>
a5e468ff	112	<export>true</export>
e244747c EM	113	<type>datetime</type>
	114	<required>true</required>
	115	<comment>The date the pledge payment is supposed to happen.</comment>
	116	<add>2.1</add>
267fb11a SL	117	<html>
	118	<type>Select Date</type>
	119	<formatType>activityDate</formatType>
	120	</html>
1519c828	121	<uniqueTitle>Payment Scheduled</uniqueTitle>
6a488035 TO	122	</field>
6a488035 TO	123	<field>
e244747c EM	124	<name>reminder_date</name>
	125	<uniqueName>pledge_payment_reminder_date</uniqueName>
	126	<title>Last Reminder</title>
	127	<import>true</import>
	128	<type>datetime</type>
	129	<comment>The date that the most recent payment reminder was sent.</comment>
	130	<add>2.1</add>
6a488035 TO	131	</field>
6a488035 TO	132	<field>
e244747c EM	133	<name>reminder_count</name>
	134	<uniqueName>pledge_payment_reminder_count</uniqueName>
	135	<title>Reminders Sent</title>
	136	<import>true</import>
	137	<type>int unsigned</type>
	138	<default>0</default>
	139	<comment>The number of payment reminders sent.</comment>
	140	<add>2.1</add>
6a488035 TO	141	</field>
6a488035 TO	142	<field>
e244747c EM	143	<name>status_id</name>
	144	<title>Payment Status</title>
	145	<uniqueName>pledge_payment_status_id</uniqueName>
	146	<import>true</import>
	147	<export>false</export>
	148	<type>int unsigned</type>
	149	<add>2.1</add>
294cc627	150	<pseudoconstant>
	151	<optionGroupName>contribution_status</optionGroupName>
	152	</pseudoconstant>
6a488035 TO	153	</field>
	154	<index>
	155	<name>index_status</name>
	156	<fieldName>status_id</fieldName>
	157	<add>2.1</add>
	158	</index>
	159	</table>