civicrm_uf_field_fr_CA - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

Unique table ID

uf_group_id

INT UNSIGNED

null

Which form does this field belong to.

field_name

VARCHAR

null

Name for CiviCRM field which is being exposed for sharing.

is_active

TINYINT

√

Is this field currently shareable? If false, hide the field for all sharing contexts.

is_view

TINYINT

√

the field is view only and not editable in user forms.

is_required

TINYINT

√

Is this field required when included in a user or registration form?

weight

INT

Controls field display order when user framework fields are displayed in registration and account editing forms.

visibility

VARCHAR

√

User and User Admin Only

In what context(s) is this field visible.

in_selector

TINYINT

√

Is this field included as a column in the selector table?

is_searchable

TINYINT

√

Is this field included search form of profile?

location_type_id

INT UNSIGNED

√

null

Location type of this mapping, if required

phone_type_id

INT UNSIGNED

√

null

Phone Type Id, if required

website_type_id

INT UNSIGNED

√

null

Website Type Id, if required

field_type

VARCHAR

255

√

null

This field saves field type (ie individual,household.. field etc).

is_reserved

TINYINT

√

null

Is this field reserved for use by some other CiviCRM functionality?

is_multi_summary

TINYINT

√

Include in multi-record listing?

help_post

TEXT

65535

√

null

help_pre

TEXT

65535

√

null

label

VARCHAR

255

√

null

Showing 1 to 19 of 19 entries

View Definition

select `civicrm`.`civicrm_uf_field`.`id` AS `id`,`civicrm`.`civicrm_uf_field`.`uf_group_id` AS `uf_group_id`,`civicrm`.`civicrm_uf_field`.`field_name` AS `field_name`,`civicrm`.`civicrm_uf_field`.`is_active` AS `is_active`,`civicrm`.`civicrm_uf_field`.`is_view` AS `is_view`,`civicrm`.`civicrm_uf_field`.`is_required` AS `is_required`,`civicrm`.`civicrm_uf_field`.`weight` AS `weight`,`civicrm`.`civicrm_uf_field`.`visibility` AS `visibility`,`civicrm`.`civicrm_uf_field`.`in_selector` AS `in_selector`,`civicrm`.`civicrm_uf_field`.`is_searchable` AS `is_searchable`,`civicrm`.`civicrm_uf_field`.`location_type_id` AS `location_type_id`,`civicrm`.`civicrm_uf_field`.`phone_type_id` AS `phone_type_id`,`civicrm`.`civicrm_uf_field`.`website_type_id` AS `website_type_id`,`civicrm`.`civicrm_uf_field`.`field_type` AS `field_type`,`civicrm`.`civicrm_uf_field`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_uf_field`.`is_multi_summary` AS `is_multi_summary`,`civicrm`.`civicrm_uf_field`.`help_post_fr_CA` AS `help_post`,`civicrm`.`civicrm_uf_field`.`help_pre_fr_CA` AS `help_pre`,`civicrm`.`civicrm_uf_field`.`label_fr_CA` AS `label` from `civicrm`.`civicrm_uf_field`

 
select `civicrm`.`civicrm_uf_field`.`id` AS `id`,`civicrm`.`civicrm_uf_field`.`uf_group_id` AS `uf_group_id`,`civicrm`.`civicrm_uf_field`.`field_name` AS `field_name`,`civicrm`.`civicrm_uf_field`.`is_active` AS `is_active`,`civicrm`.`civicrm_uf_field`.`is_view` AS `is_view`,`civicrm`.`civicrm_uf_field`.`is_required` AS `is_required`,`civicrm`.`civicrm_uf_field`.`weight` AS `weight`,`civicrm`.`civicrm_uf_field`.`visibility` AS `visibility`,`civicrm`.`civicrm_uf_field`.`in_selector` AS `in_selector`,`civicrm`.`civicrm_uf_field`.`is_searchable` AS `is_searchable`,`civicrm`.`civicrm_uf_field`.`location_type_id` AS `location_type_id`,`civicrm`.`civicrm_uf_field`.`phone_type_id` AS `phone_type_id`,`civicrm`.`civicrm_uf_field`.`website_type_id` AS `website_type_id`,`civicrm`.`civicrm_uf_field`.`field_type` AS `field_type`,`civicrm`.`civicrm_uf_field`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_uf_field`.`is_multi_summary` AS `is_multi_summary`,`civicrm`.`civicrm_uf_field`.`help_post_fr_CA` AS `help_post`,`civicrm`.`civicrm_uf_field`.`help_pre_fr_CA` AS `help_pre`,`civicrm`.`civicrm_uf_field`.`label_fr_CA` AS `label` from `civicrm`.`civicrm_uf_field`

Possibly Referenced Tables/Views

civicrm_uf_field