Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Unique table ID |
||
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is this form currently active? If false, hide all related fields for all sharing contexts. |
|
| group_type | VARCHAR | 255 | √ | null |
|
|
This column will store a comma separated list of the type(s) of profile fields. |
|
| description | TEXT | 65535 | √ | null |
|
|
Optional verbose description of the profile. |
|
| limit_listings_group_id | INT UNSIGNED | 10 | √ | null |
|
|
Group id, foriegn key from civicrm_group |
|
| post_URL | VARCHAR | 255 | √ | null |
|
|
Redirect to URL. |
|
| add_to_group_id | INT UNSIGNED | 10 | √ | null |
|
|
foreign key to civicrm_group_id |
|
| add_captcha | TINYINT | 3 | √ | 0 |
|
|
Should a CAPTCHA widget be included this Profile form. |
|
| is_map | TINYINT | 3 | √ | 0 |
|
|
Do we want to map results from this profile. |
|
| is_edit_link | TINYINT | 3 | √ | 0 |
|
|
Should edit link display in profile selector |
|
| is_uf_link | TINYINT | 3 | √ | 0 |
|
|
Should we display a link to the website profile in profile selector |
|
| is_update_dupe | TINYINT | 3 | √ | 0 |
|
|
Should we update the contact record if we find a duplicate |
|
| cancel_URL | VARCHAR | 255 | √ | null |
|
|
Redirect to URL when Cancle button clik . |
|
| is_cms_user | TINYINT | 3 | √ | 0 |
|
|
Should we create a cms user for this profile |
|
| notify | TEXT | 65535 | √ | null |
|
|
||
| is_reserved | TINYINT | 3 | √ | null |
|
|
Is this group reserved for use by some other CiviCRM functionality? |
|
| name | VARCHAR | 64 | √ | null |
|
|
Name of the UF group for directly addressing it in the codebase |
|
| created_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_contact, who created this UF group |
|
| created_date | DATETIME | 19 | √ | null |
|
|
Date and time this UF group was created. |
|
| is_proximity_search | TINYINT | 3 | √ | 0 |
|
|
Should we include proximity search feature in this profile search form? |
|
| TINYINT | 3 | √ | 1 |
|
|
Should a Cancel button be included in this Profile form. |
||
| title | VARCHAR | 64 | √ | null |
|
|
||
| frontend_title | VARCHAR | 64 | √ | null |
|
|
Profile Form Public title |
|
| help_pre | TEXT | 65535 | √ | null |
|
|
||
| help_post | TEXT | 65535 | √ | null |
|
|
||
| VARCHAR | 64 | √ | null |
|
|
Custom Text to display on the cancel button when used in create or edit mode |
||
| VARCHAR | 64 | √ | null |
|
|
Custom Text to display on the submit button on profile edit/create screens |