civicrm_uf_group

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_pcp_block.supporter_profile_id FK_civicrm_pcp_block_supporter_profile_idN
civicrm_uf_field.uf_group_id FK_civicrm_uf_field_uf_group_idC
civicrm_uf_join.uf_group_id FK_civicrm_uf_join_uf_group_idR

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
civicrm_group.id FK_civicrm_uf_group_limit_listings_group_idN

Group id, foriegn key from civicrm_group
post_URL VARCHAR 255 √ null

Redirect to URL.
add_to_group_id INT UNSIGNED 10 √ null
civicrm_group.id FK_civicrm_uf_group_add_to_group_idN

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
civicrm_contact.id FK_civicrm_uf_group_created_idN

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?
title_en_US VARCHAR 64 √ null
help_pre_en_US TEXT 65535 √ null
help_post_en_US TEXT 65535 √ null
title_fr_CA VARCHAR 64 √ null
help_pre_fr_CA TEXT 65535 √ null
help_post_fr_CA TEXT 65535 √ null
cancel_button_text_en_US VARCHAR 64 √ null

Custom Text to display on the cancel button when used in create or edit mode
cancel_button_text_fr_CA VARCHAR 64 √ null

Custom Text to display on the cancel button when used in create or edit mode
submit_button_text_en_US VARCHAR 64 √ null

Custom Text to display on the submit button on profile edit/create screens
submit_button_text_fr_CA VARCHAR 64 √ null

Custom Text to display on the submit button on profile edit/create screens
frontend_title_en_US VARCHAR 64 √ null

Profile Form Public title
frontend_title_fr_CA VARCHAR 64 √ null

Profile Form Public title
add_cancel_button TINYINT 3 √ 1

Should a Cancel button be included in this Profile form.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_uf_group_add_to_group_id Performance Asc add_to_group_id
FK_civicrm_uf_group_created_id Performance Asc created_id
FK_civicrm_uf_group_limit_listings_group_id Performance Asc limit_listings_group_id

Relationships

Close relationships within degrees of separation