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 |
|
|
|||||
| 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 |
|
|
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
Close relationships within degrees of separation
