| 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? |
|
| add_cancel_button | 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 |
|
|
||
| cancel_button_text | VARCHAR | 64 | √ | null |
|
|
Custom Text to display on the cancel button when used in create or edit mode |
|
| submit_button_text | VARCHAR | 64 | √ | null |
|
|
Custom Text to display on the submit button on profile edit/create screens |
select `civicrm`.`civicrm_uf_group`.`id` AS `id`,`civicrm`.`civicrm_uf_group`.`is_active` AS `is_active`,`civicrm`.`civicrm_uf_group`.`group_type` AS `group_type`,`civicrm`.`civicrm_uf_group`.`description` AS `description`,`civicrm`.`civicrm_uf_group`.`limit_listings_group_id` AS `limit_listings_group_id`,`civicrm`.`civicrm_uf_group`.`post_URL` AS `post_URL`,`civicrm`.`civicrm_uf_group`.`add_to_group_id` AS `add_to_group_id`,`civicrm`.`civicrm_uf_group`.`add_captcha` AS `add_captcha`,`civicrm`.`civicrm_uf_group`.`is_map` AS `is_map`,`civicrm`.`civicrm_uf_group`.`is_edit_link` AS `is_edit_link`,`civicrm`.`civicrm_uf_group`.`is_uf_link` AS `is_uf_link`,`civicrm`.`civicrm_uf_group`.`is_update_dupe` AS `is_update_dupe`,`civicrm`.`civicrm_uf_group`.`cancel_URL` AS `cancel_URL`,`civicrm`.`civicrm_uf_group`.`is_cms_user` AS `is_cms_user`,`civicrm`.`civicrm_uf_group`.`notify` AS `notify`,`civicrm`.`civicrm_uf_group`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_uf_group`.`name` AS `name`,`civicrm`.`civicrm_uf_group`.`created_id` AS `created_id`,`civicrm`.`civicrm_uf_group`.`created_date` AS `created_date`,`civicrm`.`civicrm_uf_group`.`is_proximity_search` AS `is_proximity_search`,`civicrm`.`civicrm_uf_group`.`add_cancel_button` AS `add_cancel_button`,`civicrm`.`civicrm_uf_group`.`title_fr_CA` AS `title`,`civicrm`.`civicrm_uf_group`.`frontend_title_fr_CA` AS `frontend_title`,`civicrm`.`civicrm_uf_group`.`help_pre_fr_CA` AS `help_pre`,`civicrm`.`civicrm_uf_group`.`help_post_fr_CA` AS `help_post`,`civicrm`.`civicrm_uf_group`.`cancel_button_text_fr_CA` AS `cancel_button_text`,`civicrm`.`civicrm_uf_group`.`submit_button_text_fr_CA` AS `submit_button_text` from `civicrm`.`civicrm_uf_group`