Column Type Size Nulls Auto Default Children Parents Comments

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?

title VARCHAR 64 null
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

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views