civicrm_product_en_US - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

sku

VARCHAR

√

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

√

null

3 character string, value from config setting or input via user.

financial_type_id

INT UNSIGNED

√

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

null

Disabling premium removes it from the premiums_premium join table below.

period_type

VARCHAR

√

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

√

101

Month and day (MMDD) that fixed period type subscription or membership starts.

duration_unit

VARCHAR

√

year

duration_interval

INT

√

null

Number of units for total duration of subscription, service, membership (e.g. 12 Months).

frequency_unit

VARCHAR

√

month

Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.

frequency_interval

INT

√

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

Showing 1 to 19 of 19 entries

View Definition

select `civicrm`.`civicrm_product`.`id` AS `id`,`civicrm`.`civicrm_product`.`sku` AS `sku`,`civicrm`.`civicrm_product`.`image` AS `image`,`civicrm`.`civicrm_product`.`thumbnail` AS `thumbnail`,`civicrm`.`civicrm_product`.`price` AS `price`,`civicrm`.`civicrm_product`.`currency` AS `currency`,`civicrm`.`civicrm_product`.`financial_type_id` AS `financial_type_id`,`civicrm`.`civicrm_product`.`min_contribution` AS `min_contribution`,`civicrm`.`civicrm_product`.`cost` AS `cost`,`civicrm`.`civicrm_product`.`is_active` AS `is_active`,`civicrm`.`civicrm_product`.`period_type` AS `period_type`,`civicrm`.`civicrm_product`.`fixed_period_start_day` AS `fixed_period_start_day`,`civicrm`.`civicrm_product`.`duration_unit` AS `duration_unit`,`civicrm`.`civicrm_product`.`duration_interval` AS `duration_interval`,`civicrm`.`civicrm_product`.`frequency_unit` AS `frequency_unit`,`civicrm`.`civicrm_product`.`frequency_interval` AS `frequency_interval`,`civicrm`.`civicrm_product`.`name_en_US` AS `name`,`civicrm`.`civicrm_product`.`description_en_US` AS `description`,`civicrm`.`civicrm_product`.`options_en_US` AS `options` from `civicrm`.`civicrm_product`

 
select `civicrm`.`civicrm_product`.`id` AS `id`,`civicrm`.`civicrm_product`.`sku` AS `sku`,`civicrm`.`civicrm_product`.`image` AS `image`,`civicrm`.`civicrm_product`.`thumbnail` AS `thumbnail`,`civicrm`.`civicrm_product`.`price` AS `price`,`civicrm`.`civicrm_product`.`currency` AS `currency`,`civicrm`.`civicrm_product`.`financial_type_id` AS `financial_type_id`,`civicrm`.`civicrm_product`.`min_contribution` AS `min_contribution`,`civicrm`.`civicrm_product`.`cost` AS `cost`,`civicrm`.`civicrm_product`.`is_active` AS `is_active`,`civicrm`.`civicrm_product`.`period_type` AS `period_type`,`civicrm`.`civicrm_product`.`fixed_period_start_day` AS `fixed_period_start_day`,`civicrm`.`civicrm_product`.`duration_unit` AS `duration_unit`,`civicrm`.`civicrm_product`.`duration_interval` AS `duration_interval`,`civicrm`.`civicrm_product`.`frequency_unit` AS `frequency_unit`,`civicrm`.`civicrm_product`.`frequency_interval` AS `frequency_interval`,`civicrm`.`civicrm_product`.`name_en_US` AS `name`,`civicrm`.`civicrm_product`.`description_en_US` AS `description`,`civicrm`.`civicrm_product`.`options_en_US` AS `options` from `civicrm`.`civicrm_product`

Possibly Referenced Tables/Views

civicrm_product