civicrm_contribution_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
product_id INT UNSIGNED 10 null
contribution_id INT UNSIGNED 10 null
civicrm_contribution.id FK_civicrm_contribution_product_contribution_idC
product_option VARCHAR 255 null

Option value selected if applicable - e.g. color, size etc.

quantity INT 10 null
fulfilled_date DATE 10 null

Optional. Can be used to record the date this product was fulfilled or shipped.

start_date DATE 10 null

Actual start date for a time-delimited premium (subscription, service or membership)

end_date DATE 10 null

Actual end date for a time-delimited premium (subscription, service or membership)

comment TEXT 65535 null
financial_type_id INT UNSIGNED 10 null
civicrm_financial_type.id FK_civicrm_contribution_product_financial_type_idN

FK to Financial Type(for membership price sets only).

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_contribution_product_contribution_id Performance Asc contribution_id
FK_civicrm_contribution_product_financial_type_id Performance Asc financial_type_id

Relationships