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

Close relationships within degrees of separation