Table d47civi_0z3xa.civicrm_uf_group Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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.
title varchar 64 Form title.
description text 65535  √  null Optional verbose description of the profile.
help_pre text 65535  √  null Description and/or help text to display before fields in form.
help_post text 65535  √  null Description and/or help text to display after fields in form.
limit_listings_group_id int unsigned 10  √  null
civicrm_group.id FK_civicrm_uf_group_limit_listings_group_id N
Group id, foreign 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?

Table contained 15 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
add_to_group_id Performance Asc FK_civicrm_uf_group_add_to_group_id  
created_id Performance Asc FK_civicrm_uf_group_created_id  
limit_listings_group_id Performance Asc FK_civicrm_uf_group_limit_listings_group_id  
name Must be unique Asc UI_name This unique column is also nullable

Close relationships  within of separation: