| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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. |
||||
| 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’ |
Showing 1 to 22 of 22 entries
| 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 |
Showing 1 to 4 of 4 entries
