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