Table d45civi_b72v5.civicrm_uf_field 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  √  Unique table ID
uf_group_id int unsigned 10
civicrm_uf_group.id FK_civicrm_uf_field_uf_group_id C
Which form does this field belong to.
field_name varchar 64 Name for CiviCRM field which is being exposed for sharing.
is_active tinyint 3  √  1 Is this field currently shareable? If false, hide the field for all sharing contexts.
is_view tinyint 3  √  0 the field is view only and not editable in user forms.
is_required tinyint 3  √  0 Is this field required when included in a user or registration form?
weight int 10 1 Controls field display order when user framework fields are displayed in registration and account editing forms.
help_post text 65535  √  null Description and/or help text to display after this field.
help_pre text 65535  √  null Description and/or help text to display before this field.
visibility varchar 32  √  User and User Admin Only In what context(s) is this field visible.
in_selector tinyint 3  √  0 Is this field included as a column in the selector table?
is_searchable tinyint 3  √  0 Is this field included search form of profile?
location_type_id int unsigned 10  √  null
civicrm_location_type.id FK_civicrm_uf_field_location_type_id N
Location type of this mapping, if required
phone_type_id int unsigned 10  √  null Phone Type Id, if required
website_type_id int unsigned 10  √  null Website Type Id, if required
label varchar 255 To save label for fields.
field_type varchar 255  √  null This field saves field type (ie individual,household.. field etc).
is_reserved tinyint 3  √  null Is this field reserved for use by some other CiviCRM functionality?
is_multi_summary tinyint 3  √  0 Include in multi-record listing?

Table contained 74 rows at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
location_type_id Performance Asc FK_civicrm_uf_field_location_type_id
uf_group_id Performance Asc FK_civicrm_uf_field_uf_group_id
website_type_id Performance Asc IX_website_type_id

Close relationships  within of separation: