civicrm_uf_group


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_id N
civicrm_uf_field.uf_group_id FK_civicrm_uf_field_uf_group_id C
civicrm_uf_join.uf_group_id FK_civicrm_uf_join_uf_group_id R

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_id N

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_id N

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_id N

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

Table contained 13 rows

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