civicrm_price_field

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_line_item.price_field_id FK_civicrm_line_item_price_field_idN
civicrm_price_field_value.price_field_id FK_civicrm_price_field_value_price_field_idR

Price Field
price_set_id INT UNSIGNED 10 null
civicrm_price_set.id FK_civicrm_price_field_price_set_idR

FK to civicrm_price_set
name VARCHAR 255 null

Variable name/programmatic handle for this field.
html_type VARCHAR 12 null
is_enter_qty TINYINT 3 √ 0

Enter a quantity for this field?
weight INT 10 √ 1

Order in which the fields should appear
is_display_amounts TINYINT 3 √ 1

Should the price be displayed next to the label for each option?
options_per_line INT UNSIGNED 10 √ 1

number of options per line for checkbox and radio
is_active TINYINT 3 √ 1

Is this price field active
is_required TINYINT 3 √ 1

Is this price field required (value must be > 1)
active_on DATETIME 19 √ null

If non-zero, do not show this field before the date specified
expire_on DATETIME 19 √ null

If non-zero, do not show this field after the date specified
javascript VARCHAR 255 √ null

Optional scripting attributes for field
visibility_id INT UNSIGNED 10 √ 1

Implicit FK to civicrm_option_group with name = 'visibility'
label_en_US VARCHAR 255 √ null
help_pre_en_US TEXT 65535 √ null
help_post_en_US TEXT 65535 √ null
label_fr_CA VARCHAR 255 √ null
help_pre_fr_CA TEXT 65535 √ null
help_post_fr_CA TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_price_field_price_set_id Performance Asc price_set_id
index_name Performance Asc name

Relationships

Close relationships within degrees of separation