xml/schema/Pledge/PledgeBlock.xml

   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>
   8   <field>
   9     <name>id</name>
  10     <type>int unsigned</type>
  11     <required>true</required>
  12     <comment>Pledge ID</comment>
  13     <add>2.1</add>
  14   </field>
  15   <primaryKey>
  16     <name>id</name>
  17     <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20     <name>entity_table</name>
  21     <title>Entity Table</title>
  22     <type>varchar</type>
  23     <length>64</length>
  24     <comment>physical tablename for entity being joined to pledge, e.g. civicrm_contact</comment>
  25     <add>2.1</add>
  26   </field>
  27   <field>
  28     <name>entity_id</name>
  29     <title>Entity Id</title>
  30     <type>int unsigned</type>
  31     <required>true</required>
  32     <comment>FK to entity table specified in entity_table column.</comment>
  33     <add>2.1</add>
  34   </field>
  35   <dynamicForeignKey>
  36     <idColumn>entity_id</idColumn>
  37     <typeColumn>entity_table</typeColumn>
  38     <add>2.1</add>
  39   </dynamicForeignKey>
  40   <index>
  41     <name>index_entity</name>
  42     <fieldName>entity_table</fieldName>
  43     <fieldName>entity_id</fieldName>
  44     <add>2.1</add>
  45   </index>
  46   <field>
  47     <name>pledge_frequency_unit</name>
  48     <title>Pledge Frequency Unit</title>
  49     <type>varchar</type>
  50     <length>128</length>
  51     <comment>Delimited list of supported frequency units</comment>
  52     <add>2.1</add>
  53   </field>
  54   <field>
  55     <name>is_pledge_interval</name>
  56     <type>boolean</type>
  57     <default>0</default>
  58     <comment>Is frequency interval exposed on the contribution form.</comment>
  59     <add>2.1</add>
  60   </field>
  61   <field>
  62     <name>max_reminders</name>
  63     <title>Maximum Number of Reminders</title>
  64     <type>int unsigned</type>
  65     <default>1</default>
  66     <comment>The maximum number of payment reminders to send for any given payment.</comment>
  67     <add>2.1</add>
  68   </field>
  69   <field>
  70     <name>initial_reminder_day</name>
  71     <title>Initial Reminder Day</title>
  72     <type>int unsigned</type>
  73     <default>5</default>
  74     <comment>Send initial reminder this many days prior to the payment due date.</comment>
  75     <add>2.1</add>
  76   </field>
  77   <field>
  78     <name>additional_reminder_day</name>
  79     <title>Additional Reminder Days</title>
  80     <type>int unsigned</type>
  81     <default>5</default>
  82     <comment>Send additional reminder this many days after last one sent, up to maximum number of reminders.</comment>
  83     <add>2.1</add>
  84   </field>
  85 </table>