Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
|||
| sku | VARCHAR | 50 | √ | null |
|
|
Optional product sku or code. |
|
| image | VARCHAR | 255 | √ | null |
|
|
Full or relative URL to uploaded image - fullsize. |
|
| thumbnail | VARCHAR | 255 | √ | null |
|
|
Full or relative URL to image thumbnail. |
|
| price | DECIMAL | 20,2 | √ | null |
|
|
Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record. |
|
| currency | VARCHAR | 3 | √ | null |
|
|
3 character string, value from config setting or input via user. |
|
| financial_type_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Financial Type. |
|
| min_contribution | DECIMAL | 20,2 | √ | null |
|
|
Minimum contribution required to be eligible to select this premium. |
|
| cost | DECIMAL | 20,2 | √ | null |
|
|
Actual cost of this product. Useful to determine net return from sale or using this as an incentive. |
|
| is_active | TINYINT | 3 | null |
|
|
Disabling premium removes it from the premiums_premium join table below. |
||
| period_type | VARCHAR | 8 | √ | rolling |
|
|
Rolling means we set start/end based on current day, fixed means we set start/end for current year or month |
|
| fixed_period_start_day | INT | 10 | √ | 101 |
|
|
Month and day (MMDD) that fixed period type subscription or membership starts. |
|
| duration_unit | VARCHAR | 8 | √ | year |
|
|
||
| duration_interval | INT | 10 | √ | null |
|
|
Number of units for total duration of subscription, service, membership (e.g. 12 Months). |
|
| frequency_unit | VARCHAR | 8 | √ | month |
|
|
Frequency unit and interval allow option to store actual delivery frequency for a subscription or service. |
|
| frequency_interval | INT | 10 | √ | null |
|
|
Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months). |
|
| name | VARCHAR | 255 | √ | null |
|
|
||
| description | TEXT | 65535 | √ | null |
|
|
||
| options | TEXT | 65535 | √ | null |
|
|