Column Type Size Nulls Auto Default Children Parents Comments
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 (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006)

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

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views