civicrm_price_field_value

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_line_item.price_field_value_id FK_civicrm_line_item_price_field_value_idN

Price Field Value
price_field_id INT UNSIGNED 10 null
civicrm_price_field.id FK_civicrm_price_field_value_price_field_idR

FK to civicrm_price_field
name VARCHAR 255 √ null

Price field option name
amount DECIMAL 18,9 null

Price field option amount
count INT UNSIGNED 10 √ null

Number of participants per field option
max_value INT UNSIGNED 10 √ null

Max number of participants per field options
weight INT 10 √ 1

Order in which the field options should appear
membership_type_id INT UNSIGNED 10 √ null
civicrm_membership_type.id FK_civicrm_price_field_value_membership_type_idN

FK to Membership Type
membership_num_terms INT UNSIGNED 10 √ null

Number of terms for this membership
is_default TINYINT 3 √ 0

Is this default price field option
is_active TINYINT 3 √ 1

Is this price field value active
financial_type_id INT UNSIGNED 10 √ null
civicrm_financial_type.id FK_civicrm_price_field_value_financial_type_idN

FK to Financial Type.
non_deductible_amount DECIMAL 20,2 0.00

Portion of total amount which is NOT tax deductible.
label_en_US VARCHAR 255 √ null
description_en_US TEXT 65535 √ null
label_fr_CA VARCHAR 255 √ null
description_fr_CA TEXT 65535 √ null
help_pre_en_US TEXT 65535 √ null

Price field option pre help text.
help_post_en_US TEXT 65535 √ null

Price field option post help text.
help_pre_fr_CA TEXT 65535 √ null

Price field option pre help text.
help_post_fr_CA TEXT 65535 √ null

Price field option post help text.
visibility_id INT UNSIGNED 10 √ 1

Implicit FK to civicrm_option_group with name = ‘visibility’

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_price_field_value_financial_type_id Performance Asc financial_type_id
FK_civicrm_price_field_value_membership_type_id Performance Asc membership_type_id
FK_civicrm_price_field_value_price_field_id Performance Asc price_field_id

Relationships

Close relationships within degrees of separation