1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contribute
</base>
5 <class>ContributionProduct
</class>
6 <name>civicrm_contribution_product
</name>
9 <component>CiviContribute
</component>
12 <title>Contribution Product ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
19 <autoincrement>true
</autoincrement>
22 <name>product_id
</name>
23 <title>Product ID
</title>
24 <type>int unsigned
</type>
25 <required>true
</required>
29 <name>contribution_id
</name>
30 <title>Contribution ID
</title>
31 <type>int unsigned
</type>
32 <required>true
</required>
36 <name>contribution_id
</name>
37 <table>civicrm_contribution
</table>
40 <onDelete>CASCADE
</onDelete>
43 <name>product_option
</name>
44 <title>Product Option
</title>
48 <comment>Option value selected if applicable - e.g. color, size etc.
</comment>
53 <title>Quantity
</title>
60 <name>fulfilled_date
</name>
62 <title>Fulfilled Date
</title>
64 <comment>Optional. Can be used to record the date this product was fulfilled or shipped.
</comment>
67 <type>Select Date
</type>
68 <formatType>activityDate
</formatType>
72 <name>start_date
</name>
73 <uniqueName>contribution_start_date
</uniqueName>
74 <title>Start date for premium
</title>
77 <comment>Actual start date for a time-delimited premium (subscription, service or membership)
</comment>
82 <uniqueName>contribution_end_date
</uniqueName>
84 <title>End date for premium
</title>
86 <comment>Actual end date for a time-delimited premium (subscription, service or membership)
</comment>
91 <title>Premium comment
</title>
96 <name>financial_type_id
</name>
97 <title>Financial Type
</title>
98 <type>int unsigned
</type>
99 <default>NULL
</default>
101 <table>civicrm_financial_type
</table>
102 <keyColumn>id
</keyColumn>
103 <labelColumn>name
</labelColumn>
105 <comment>FK to Financial Type(for membership price sets only).
</comment>
109 <name>financial_type_id
</name>
110 <table>civicrm_financial_type
</table>
112 <onDelete>SET NULL
</onDelete>