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. |