Table d45civi_b72v5.civicrm_contribution_product Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
product_id int unsigned 10
contribution_id int unsigned 10
civicrm_contribution.id FK_civicrm_contribution_product_contribution_id C
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_id N
FK to Financial Type(for membership price sets only).

Table contained 0 rows at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: