civicrm_price_field_value_en_US

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 0

Price Field Value

price_field_id INT UNSIGNED 10 null

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

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

FK to Financial Type.

non_deductible_amount DECIMAL 20,2 0.00

Portion of total amount which is NOT tax deductible.

visibility_id INT UNSIGNED 10 1

Implicit FK to civicrm_option_group with name = ‘visibility’

label VARCHAR 255 null
description TEXT 65535 null
help_pre TEXT 65535 null

Price field option pre help text.

help_post TEXT 65535 null

Price field option post help text.

View Definition


Possibly Referenced Tables/Views