civicrm_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_premiums_product.product_id FK_civicrm_premiums_product_product_idR
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
civicrm_financial_type.id FK_civicrm_product_financial_type_idN

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_en_US VARCHAR 255 null
description_en_US TEXT 65535 null
options_en_US TEXT 65535 null
name_fr_CA VARCHAR 255 null
description_fr_CA TEXT 65535 null
options_fr_CA TEXT 65535 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_product_financial_type_id Performance Asc financial_type_id

Relationships