Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Price Set |
||
| domain_id | INT UNSIGNED | 10 | √ | null |
|
|
Which Domain is this price-set for |
|
| name | VARCHAR | 255 | null |
|
|
Variable name/programmatic handle for this set of price fields. |
||
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is this price set active |
|
| javascript | VARCHAR | 64 | √ | null |
|
|
Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional |
|
| extends | VARCHAR | 255 | null |
|
|
What components are using this price set? |
||
| financial_type_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Financial Type(for membership price sets only). |
|
| is_quick_config | TINYINT | 3 | √ | 0 |
|
|
Is set if edited on Contribution or Event Page rather than through Manage Price Sets |
|
| is_reserved | TINYINT | 3 | √ | 0 |
|
|
Is this a predefined system price set (i.e. it can not be deleted, edited)? |
|
| min_amount | INT UNSIGNED | 10 | √ | 0 |
|
|
Minimum Amount required for this set. |
|
| title | VARCHAR | 255 | √ | null |
|
|
||
| help_pre | TEXT | 65535 | √ | null |
|
|
||
| help_post | TEXT | 65535 | √ | null |
|
|