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 <type>int unsigned
</type>
12 <required>true
</required>
17 <autoincrement>true
</autoincrement>
20 <name>product_id
</name>
21 <type>int unsigned
</type>
22 <required>true
</required>
26 <name>contribution_id
</name>
27 <type>int unsigned
</type>
28 <required>true
</required>
32 <name>contribution_id
</name>
33 <table>civicrm_contribution
</table>
36 <onDelete>CASCADE
</onDelete>
39 <name>product_option
</name>
40 <title>Product Option
</title>
44 <comment>Option value selected if applicable - e.g. color, size etc.
</comment>
49 <title>Quantity
</title>
57 <name>total_cost
</name>
59 <required>true
</required>
61 <headerPattern>/^total|(.?^am(ou)?nt)/i
</headerPattern>
62 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
63 <comment>quantity X civicrm_product.cost.
</comment>
68 <name>fulfilled_date
</name>
71 <comment>Optional. Can be used to record the date this product was fulfilled or shipped.
</comment>
75 <name>start_date
</name>
76 <uniqueName>contribution_start_date
</uniqueName>
79 <comment>Actual start date for a time-delimited premium (subscription, service or membership)
</comment>
84 <uniqueName>contribution_end_date
</uniqueName>
87 <comment>Actual end date for a time-delimited premium (subscription, service or membership)
</comment>
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>