Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Price Field |
||
| price_set_id | INT UNSIGNED | 10 | null |
|
|
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 | VARCHAR | 255 | √ | null |
|
|
||
| help_pre | TEXT | 65535 | √ | null |
|
|
||
| help_post | TEXT | 65535 | √ | null |
|
|