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

Close relationships within degrees of separation