Merge pull request #20666 from civicrm/5.39
[civicrm-core.git] / xml / schema / Pledge / PledgeBlock.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2<table>
3 <base>CRM/Pledge</base>
4 <class>PledgeBlock</class>
5 <name>civicrm_pledge_block</name>
6 <add>2.1</add>
7 <log>true</log>
d31fb4e3 8 <component>CiviPledge</component>
6a488035 9 <field>
e244747c 10 <name>id</name>
f3ea5182 11 <title>Pledge Block ID</title>
e244747c
EM
12 <type>int unsigned</type>
13 <required>true</required>
14 <comment>Pledge ID</comment>
15 <add>2.1</add>
0481e12c
A
16 <html>
17 <type>Number</type>
18 </html>
6a488035
TO
19 </field>
20 <primaryKey>
e244747c
EM
21 <name>id</name>
22 <autoincrement>true</autoincrement>
6a488035
TO
23 </primaryKey>
24 <field>
e244747c
EM
25 <name>entity_table</name>
26 <title>Entity Table</title>
27 <type>varchar</type>
28 <length>64</length>
29 <comment>physical tablename for entity being joined to pledge, e.g. civicrm_contact</comment>
30 <add>2.1</add>
6a488035
TO
31 </field>
32 <field>
e244747c 33 <name>entity_id</name>
047c5009 34 <title>Entity ID</title>
e244747c
EM
35 <type>int unsigned</type>
36 <required>true</required>
37 <comment>FK to entity table specified in entity_table column.</comment>
38 <add>2.1</add>
6a488035 39 </field>
71e5aa5c 40 <dynamicForeignKey>
e244747c
EM
41 <idColumn>entity_id</idColumn>
42 <typeColumn>entity_table</typeColumn>
43 <add>2.1</add>
71e5aa5c 44 </dynamicForeignKey>
6a488035 45 <index>
e244747c
EM
46 <name>index_entity</name>
47 <fieldName>entity_table</fieldName>
48 <fieldName>entity_id</fieldName>
49 <add>2.1</add>
6a488035
TO
50 </index>
51 <field>
e244747c
EM
52 <name>pledge_frequency_unit</name>
53 <title>Pledge Frequency Unit</title>
54 <type>varchar</type>
55 <length>128</length>
56 <comment>Delimited list of supported frequency units</comment>
2a5c9b4d 57 <serialize>SEPARATOR_TRIMMED</serialize>
e244747c 58 <add>2.1</add>
6a488035 59 </field>
3c7d2158 60 <field>
e244747c 61 <name>is_pledge_interval</name>
f3ea5182 62 <title>Expose Frequency Interval?</title>
e244747c
EM
63 <type>boolean</type>
64 <default>0</default>
65 <comment>Is frequency interval exposed on the contribution form.</comment>
66 <add>2.1</add>
6a488035
TO
67 </field>
68 <field>
e244747c
EM
69 <name>max_reminders</name>
70 <title>Maximum Number of Reminders</title>
71 <type>int unsigned</type>
72 <default>1</default>
73 <comment>The maximum number of payment reminders to send for any given payment.</comment>
74 <add>2.1</add>
6a488035
TO
75 </field>
76 <field>
e244747c
EM
77 <name>initial_reminder_day</name>
78 <title>Initial Reminder Day</title>
79 <type>int unsigned</type>
80 <default>5</default>
81 <comment>Send initial reminder this many days prior to the payment due date.</comment>
82 <add>2.1</add>
6a488035
TO
83 </field>
84 <field>
e244747c
EM
85 <name>additional_reminder_day</name>
86 <title>Additional Reminder Days</title>
87 <type>int unsigned</type>
88 <default>5</default>
89 <comment>Send additional reminder this many days after last one sent, up to maximum number of reminders.</comment>
90 <add>2.1</add>
6a488035 91 </field>
dccd9f4f
ERL
92 <field>
93 <name>pledge_start_date</name>
94 <type>varchar</type>
95 <length>64</length>
96 <title>Pledge Start Date</title>
97 <comment>The date the first scheduled pledge occurs.</comment>
98 <add>4.7</add>
99 </field>
100 <field>
101 <name>is_pledge_start_date_visible</name>
102 <type>boolean</type>
103 <title>Show Recurring Donation Start Date?</title>
104 <default>0</default>
105 <required>true</required>
106 <comment>If true - recurring start date is shown.</comment>
107 <add>4.7</add>
108 </field>
109 <field>
110 <name>is_pledge_start_date_editable</name>
111 <type>boolean</type>
112 <title>Allow Edits to Recurring Donation Start Date?</title>
113 <default>0</default>
114 <required>true</required>
115 <comment>If true - recurring start date is editable.</comment>
116 <add>4.7</add>
117 </field>
6a488035 118</table>