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>
12 <title>Discount ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
15 <comment>primary key
</comment>
23 <autoincrement>true
</autoincrement>
26 <name>entity_table
</name>
27 <title>Entity Table
</title>
30 <comment>physical tablename for entity being joined to discount, e.g. civicrm_event
</comment>
34 <name>entity_id
</name>
35 <title>Entity ID
</title>
36 <type>int unsigned
</type>
37 <required>true
</required>
38 <comment>FK to entity table specified in entity_table column.
</comment>
42 <idColumn>entity_id
</idColumn>
43 <typeColumn>entity_table
</typeColumn>
47 <name>index_entity
</name>
48 <fieldName>entity_table
</fieldName>
49 <fieldName>entity_id
</fieldName>
53 <name>price_set_id
</name>
54 <uniqueName>participant_discount_name
</uniqueName>
55 <title>Price Set ID
</title>
56 <type>int unsigned
</type>
57 <required>true
</required>
59 <table>civicrm_price_set
</table>
60 <keyColumn>id
</keyColumn>
61 <labelColumn>title
</labelColumn>
64 <comment>FK to civicrm_price_set
</comment>
66 <label>Price Set
</label>
71 <name>price_set_id
</name>
72 <table>civicrm_price_set
</table>
75 <onDelete>CASCADE
</onDelete>
78 <name>index_entity_option_id
</name>
79 <fieldName>entity_table
</fieldName>
80 <fieldName>entity_id
</fieldName>
81 <fieldName>price_set_id
</fieldName>
85 <name>start_date
</name>
86 <title>Discount Start Date
</title>
88 <comment>Date when discount starts.
</comment>
93 <title>Discount End Date
</title>
95 <comment>Date when discount ends.
</comment>