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>
20 <autoincrement>true
</autoincrement>
23 <name>entity_table
</name>
24 <title>Entity Table
</title>
27 <comment>physical tablename for entity being joined to discount, e.g. civicrm_event
</comment>
31 <name>entity_id
</name>
32 <title>Entity ID
</title>
33 <type>int unsigned
</type>
34 <required>true
</required>
35 <comment>FK to entity table specified in entity_table column.
</comment>
39 <idColumn>entity_id
</idColumn>
40 <typeColumn>entity_table
</typeColumn>
44 <name>index_entity
</name>
45 <fieldName>entity_table
</fieldName>
46 <fieldName>entity_id
</fieldName>
50 <name>price_set_id
</name>
51 <uniqueName>participant_discount_name
</uniqueName>
52 <title>Discount Name
</title>
53 <type>int unsigned
</type>
54 <required>true
</required>
56 <table>civicrm_price_set
</table>
57 <keyColumn>id
</keyColumn>
58 <labelColumn>title
</labelColumn>
61 <comment>FK to civicrm_price_set
</comment>
65 <name>price_set_id
</name>
66 <table>civicrm_price_set
</table>
69 <onDelete>CASCADE
</onDelete>
72 <name>index_entity_option_id
</name>
73 <fieldName>entity_table
</fieldName>
74 <fieldName>entity_id
</fieldName>
75 <fieldName>price_set_id
</fieldName>
79 <name>start_date
</name>
80 <title>Discount Start Date
</title>
82 <comment>Date when discount starts.
</comment>
87 <title>Discount End Date
</title>
89 <comment>Date when discount ends.
</comment>