1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contribute
</base>
5 <class>PremiumsProduct
</class>
6 <name>civicrm_premiums_product
</name>
7 <comment>joins premiums (settings) to individual product/premium items - determines which products are available for a given contribution page
</comment>
12 <title>Premium Product ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
15 <comment>Contribution ID
</comment>
20 <autoincrement>true
</autoincrement>
23 <name>premiums_id
</name>
24 <title>Premium
</title>
25 <type>int unsigned
</type>
26 <required>true
</required>
27 <comment>Foreign key to premiums settings record.
</comment>
31 <name>premiums_id
</name>
32 <table>civicrm_premiums
</table>
37 <name>product_id
</name>
38 <title>Product
</title>
39 <type>int unsigned
</type>
40 <required>true
</required>
41 <comment>Foreign key to each product object.
</comment>
45 <name>product_id
</name>
46 <table>civicrm_product
</table>
51 <name>sort_position
</name>
52 <title>Sort Position
</title>
53 <type>int unsigned
</type>
54 <required>true
</required>
61 <type>int unsigned
</type>
62 <required>true
</required>
66 <name>financial_type_id
</name>
67 <title>Financial Type
</title>
68 <type>int unsigned
</type>
69 <default>NULL
</default>
71 <table>civicrm_financial_type
</table>
72 <keyColumn>id
</keyColumn>
73 <labelColumn>name
</labelColumn>
75 <comment>FK to Financial Type.
</comment>
79 <name>financial_type_id
</name>
80 <table>civicrm_financial_type
</table>
82 <onDelete>SET NULL
</onDelete>