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 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>primary key
</comment>
18 <autoincrement>true
</autoincrement>
21 <name>entity_table
</name>
24 <comment>physical tablename for entity being joined to discount, e.g. civicrm_event
</comment>
28 <name>entity_id
</name>
29 <type>int unsigned
</type>
30 <required>true
</required>
31 <comment>FK to entity table specified in entity_table column.
</comment>
35 <idColumn>entity_id
</idColumn>
36 <typeColumn>entity_table
</typeColumn>
40 <name>index_entity
</name>
41 <fieldName>entity_table
</fieldName>
42 <fieldName>entity_id
</fieldName>
46 <name>option_group_id
</name>
47 <uniqueName>participant_discount_name
</uniqueName>
48 <title>Discount Name
</title>
49 <type>int unsigned
</type>
50 <required>true
</required>
52 <comment>FK to civicrm_price_set
</comment>
57 <name>option_group_id
</name>
58 <table>civicrm_price_set
</table>
61 <onDelete>CASCADE
</onDelete>
65 <name>price_set_id
</name>
66 <uniqueName>participant_discount_name
</uniqueName>
67 <title>Discount Name
</title>
68 <type>int unsigned
</type>
69 <required>true
</required>
71 <comment>FK to civicrm_price_set
</comment>
75 <name>price_set_id
</name>
76 <table>civicrm_price_set
</table>
79 <onDelete>CASCADE
</onDelete>
82 <idColumn>entity_id
</idColumn>
83 <typeColumn>entity_table
</typeColumn>
86 <name>index_entity_option_id
</name>
87 <fieldName>entity_table
</fieldName>
88 <fieldName>entity_id
</fieldName>
89 <fieldName>price_set_id
</fieldName>
93 <name>start_date
</name>
95 <comment>Date when discount starts.
</comment>
101 <comment>Date when discount ends.
</comment>