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). |
Showing 1 to 10 of 10 entries