| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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_en_US | VARCHAR | 255 | √ | null |
|
|
||||||
| help_pre_en_US | TEXT | 65535 | √ | null |
|
|
||||||
| help_post_en_US | TEXT | 65535 | √ | null |
|
|
||||||
| label_fr_CA | VARCHAR | 255 | √ | null |
|
|
||||||
| help_pre_fr_CA | TEXT | 65535 | √ | null |
|
|
||||||
| help_post_fr_CA | TEXT | 65535 | √ | null |
|
|
Showing 1 to 20 of 20 entries
