xml/schema/Core/Discount.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Discount</class>
   6   <name>civicrm_discount</name>
   7   <comment>Stores discounts for events on the basis of date</comment>
   8   <log>true</log>
   9   <field>
  10     <name>id</name>
  11     <title>Discount ID</title>
  12     <type>int unsigned</type>
  13     <required>true</required>
  14     <comment>primary key</comment>
  15     <add>2.1</add>
  16   </field>
  17   <primaryKey>
  18     <name>id</name>
  19     <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22     <name>entity_table</name>
  23     <title>Entity Table</title>
  24     <type>varchar</type>
  25     <length>64</length>
  26     <comment>physical tablename for entity being joined to discount, e.g. civicrm_event</comment>
  27     <add>2.1</add>
  28   </field>
  29   <field>
  30     <name>entity_id</name>
  31     <title>Entity ID</title>
  32     <type>int unsigned</type>
  33     <required>true</required>
  34     <comment>FK to entity table specified in entity_table column.</comment>
  35     <add>2.1</add>
  36   </field>
  37   <dynamicForeignKey>
  38     <idColumn>entity_id</idColumn>
  39     <typeColumn>entity_table</typeColumn>
  40     <add>2.1</add>
  41   </dynamicForeignKey>
  42   <index>
  43     <name>index_entity</name>
  44     <fieldName>entity_table</fieldName>
  45     <fieldName>entity_id</fieldName>
  46     <add>2.1</add>
  47   </index>
  48   <field>
  49     <name>option_group_id</name>
  50     <uniqueName>participant_discount_name</uniqueName>
  51     <title>Discount Name</title>
  52     <type>int unsigned</type>
  53     <required>true</required>
  54     <export>true</export>
  55     <comment>FK to civicrm_price_set</comment>
  56     <add>2.1</add>
  57     <drop>4.3</drop>
  58   </field>
  59   <foreignKey>
  60     <name>option_group_id</name>
  61     <table>civicrm_price_set</table>
  62     <key>id</key>
  63     <add>2.1</add>
  64     <onDelete>CASCADE</onDelete>
  65     <drop>4.3</drop>
  66   </foreignKey>
  67   <field>
  68     <name>price_set_id</name>
  69     <uniqueName>participant_discount_name</uniqueName>
  70     <title>Discount Name</title>
  71     <type>int unsigned</type>
  72     <required>true</required>
  73     <pseudoconstant>
  74       <table>civicrm_price_set</table>
  75       <keyColumn>id</keyColumn>
  76       <labelColumn>title</labelColumn>
  77     </pseudoconstant>
  78     <export>true</export>
  79     <comment>FK to civicrm_price_set</comment>
  80     <add>4.3</add>
  81   </field>
  82   <foreignKey>
  83     <name>price_set_id</name>
  84     <table>civicrm_price_set</table>
  85     <key>id</key>
  86     <add>4.3</add>
  87     <onDelete>CASCADE</onDelete>
  88   </foreignKey>
  89   <index>
  90     <name>index_entity_option_id</name>
  91     <fieldName>entity_table</fieldName>
  92     <fieldName>entity_id</fieldName>
  93     <fieldName>price_set_id</fieldName>
  94     <add>2.1</add>
  95   </index>
  96   <field>
  97     <name>start_date</name>
  98     <title>Discount Start Date</title>
  99     <type>date</type>
 100     <comment>Date when discount starts.</comment>
 101     <add>2.1</add>
 102   </field>
 103   <field>
 104     <name>end_date</name>
 105     <title>Discount End Date</title>
 106     <type>date</type>
 107     <comment>Date when discount ends.</comment>
 108     <add>2.1</add>
 109   </field>
 110 </table>