Table d47civi_0z3xa.civicrm_price_field Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_line_item.price_field_id FK_civicrm_line_item_price_field_id N
civicrm_price_field_value.price_field_id FK_civicrm_price_field_value_price_field_id R
Price Field
price_set_id int unsigned 10
civicrm_price_set.id FK_civicrm_price_field_price_set_id R
FK to civicrm_price_set
name varchar 255 Variable name/programmatic handle for this field.
label varchar 255 Text for form field label (also friendly name for administering this field).
html_type varchar 12
is_enter_qty tinyint 3  √  0 Enter a quantity for this field?
help_pre text 65535  √  null Description and/or help text to display before this field.
help_post text 65535  √  null Description and/or help text to display after 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'

Table contained 9 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: