civicrm_price_set

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_discount.price_set_id FK_civicrm_discount_price_set_idC
civicrm_price_field.price_set_id FK_civicrm_price_field_price_set_idR
civicrm_price_set_entity.price_set_id FK_civicrm_price_set_entity_price_set_idR

Price Set

domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_price_set_domain_idR

Which Domain is this price-set for

name VARCHAR 255 null

Variable name/programmatic handle for this set of price fields.

is_active TINYINT 3 1

Is this price set active

javascript VARCHAR 64 null

Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional

extends VARCHAR 255 null

What components are using this price set?

financial_type_id INT UNSIGNED 10 null
civicrm_financial_type.id FK_civicrm_price_set_financial_type_idN

FK to Financial Type(for membership price sets only).

is_quick_config TINYINT 3 0

Is set if edited on Contribution or Event Page rather than through Manage Price Sets

is_reserved TINYINT 3 0

Is this a predefined system price set (i.e. it can not be deleted, edited)?

title_en_US VARCHAR 255 null
help_pre_en_US TEXT 65535 null
help_post_en_US TEXT 65535 null
title_fr_CA VARCHAR 255 null
help_pre_fr_CA TEXT 65535 null
help_post_fr_CA TEXT 65535 null
min_amount INT UNSIGNED 10 0

Minimum Amount required for this set.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_price_set_domain_id Performance Asc domain_id
FK_civicrm_price_set_financial_type_id Performance Asc financial_type_id
UI_name Must be unique Asc name

Relationships