Table d44civi_9xzwf.civicrm_price_field_value 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_value_id FK_civicrm_line_item_price_field_value_id N
Price Field Value
price_field_id int unsigned 10
civicrm_price_field.id FK_civicrm_price_field_value_price_field_id R
FK to civicrm_price_field
name varchar 255  √  null Price field option name
label varchar 255  √  null Price field option label
description text 65535  √  null >Price field option description.
amount varchar 512 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_id N
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_id N
FK to Financial Type.
deductible_amount decimal 20,2 0.00 Tax-deductible portion of the amount

Table contained 21 rows at Wed Nov 11 17:14 EST 2015

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

Close relationships  within of separation: