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 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Contribution ID
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>premiums_id
</name>
23 <type>int unsigned
</type>
24 <required>true
</required>
25 <comment>Foreign key to premiums settings record.
</comment>
29 <name>premiums_id
</name>
30 <table>civicrm_premiums
</table>
35 <name>product_id
</name>
36 <type>int unsigned
</type>
37 <required>true
</required>
38 <comment>Foreign key to each product object.
</comment>
42 <name>product_id
</name>
43 <table>civicrm_product
</table>
48 <name>sort_position
</name>
49 <title>Sort Position
</title>
50 <type>int unsigned
</type>
51 <required>true
</required>
58 <type>int unsigned
</type>
59 <required>true
</required>
63 <name>financial_type_id
</name>
64 <title>Financial Type
</title>
65 <type>int unsigned
</type>
66 <default>NULL
</default>
68 <table>civicrm_financial_type
</table>
69 <keyColumn>id
</keyColumn>
70 <labelColumn>name
</labelColumn>
72 <comment>FK to Financial Type.
</comment>
76 <name>financial_type_id
</name>
77 <table>civicrm_financial_type
</table>
79 <onDelete>SET NULL
</onDelete>