1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>Discount
</class>
6 <name>civicrm_discount
</name>
7 <comment>Stores discounts for events on the basis of date
</comment>
11 <title>Discount ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>primary key
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>entity_table
</name>
23 <title>Entity Table
</title>
26 <comment>physical tablename for entity being joined to discount, e.g. civicrm_event
</comment>
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>
38 <idColumn>entity_id
</idColumn>
39 <typeColumn>entity_table
</typeColumn>
43 <name>index_entity
</name>
44 <fieldName>entity_table
</fieldName>
45 <fieldName>entity_id
</fieldName>
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>
55 <comment>FK to civicrm_price_set
</comment>
60 <name>option_group_id
</name>
61 <table>civicrm_price_set
</table>
64 <onDelete>CASCADE
</onDelete>
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>
74 <table>civicrm_price_set
</table>
75 <keyColumn>id
</keyColumn>
76 <labelColumn>title
</labelColumn>
79 <comment>FK to civicrm_price_set
</comment>
83 <name>price_set_id
</name>
84 <table>civicrm_price_set
</table>
87 <onDelete>CASCADE
</onDelete>
90 <name>index_entity_option_id
</name>
91 <fieldName>entity_table
</fieldName>
92 <fieldName>entity_id
</fieldName>
93 <fieldName>price_set_id
</fieldName>
97 <name>start_date
</name>
98 <title>Discount Start Date
</title>
100 <comment>Date when discount starts.
</comment>
104 <name>end_date
</name>
105 <title>Discount End Date
</title>
107 <comment>Date when discount ends.
</comment>