1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contribute
</base>
5 <class>ContributionProduct
</class>
6 <name>civicrm_contribution_product
</name>
11 <title>Contribution Product ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
18 <autoincrement>true
</autoincrement>
21 <name>product_id
</name>
22 <title>Product ID
</title>
23 <type>int unsigned
</type>
24 <required>true
</required>
28 <name>contribution_id
</name>
29 <title>Contribution ID
</title>
30 <type>int unsigned
</type>
31 <required>true
</required>
35 <name>contribution_id
</name>
36 <table>civicrm_contribution
</table>
39 <onDelete>CASCADE
</onDelete>
42 <name>product_option
</name>
43 <title>Product Option
</title>
47 <comment>Option value selected if applicable - e.g. color, size etc.
</comment>
52 <title>Quantity
</title>
59 <name>fulfilled_date
</name>
61 <title>Fulfilled Date
</title>
63 <comment>Optional. Can be used to record the date this product was fulfilled or shipped.
</comment>
66 <type>Select Date
</type>
67 <formatType>activityDate
</formatType>
71 <name>start_date
</name>
72 <uniqueName>contribution_start_date
</uniqueName>
73 <title>Start date for premium
</title>
76 <comment>Actual start date for a time-delimited premium (subscription, service or membership)
</comment>
81 <uniqueName>contribution_end_date
</uniqueName>
83 <title>End date for premium
</title>
85 <comment>Actual end date for a time-delimited premium (subscription, service or membership)
</comment>
90 <title>Premium comment
</title>
95 <name>financial_type_id
</name>
96 <title>Financial Type
</title>
97 <type>int unsigned
</type>
98 <default>NULL
</default>
100 <table>civicrm_financial_type
</table>
101 <keyColumn>id
</keyColumn>
102 <labelColumn>name
</labelColumn>
104 <comment>FK to Financial Type(for membership price sets only).
</comment>
108 <name>financial_type_id
</name>
109 <table>civicrm_financial_type
</table>
111 <onDelete>SET NULL
</onDelete>