civicrm_custom_group_en_US - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

Unique Custom Group ID

name

VARCHAR

√

null

Variable name/programmatic handle for this group.

extends

VARCHAR

255

√

Contact

Type of object this group extends (can add other options later e.g. contact_address, etc.).

extends_entity_column_id

INT UNSIGNED

√

null

FK to civicrm_option_value.id (for option group custom_data_type.)

extends_entity_column_value

VARCHAR

255

√

null

linking custom group for dynamic object

style

VARCHAR

√

null

Visual relationship between this form and its parent.

collapse_display

INT UNSIGNED

√

Will this group be in collapsed or expanded mode on initial display ?

weight

INT

Controls display order when multiple extended property groups are setup for the same class.

is_active

TINYINT

√

Is this property active?

table_name

VARCHAR

255

√

null

Name of the table that holds the values for this group.

is_multiple

TINYINT

√

Does this group hold multiple values?

min_multiple

INT UNSIGNED

√

null

minimum number of multiple records (typically 0?)

max_multiple

INT UNSIGNED

√

null

maximum number of multiple records, if 0 - no max

collapse_adv_display

INT UNSIGNED

√

Will this group be in collapsed or expanded mode on advanced search display ?

created_id

INT UNSIGNED

√

null

FK to civicrm_contact, who created this custom group

created_date

DATETIME

√

null

Date and time this custom group was created.

is_reserved

TINYINT

√

Is this a reserved Custom Group?

is_public

BIT

√

Is this property public?

title

VARCHAR

√

null

help_pre

TEXT

65535

√

null

help_post

TEXT

65535

√

null

Showing 1 to 21 of 21 entries

View Definition

select `civicrm`.`civicrm_custom_group`.`id` AS `id`,`civicrm`.`civicrm_custom_group`.`name` AS `name`,`civicrm`.`civicrm_custom_group`.`extends` AS `extends`,`civicrm`.`civicrm_custom_group`.`extends_entity_column_id` AS `extends_entity_column_id`,`civicrm`.`civicrm_custom_group`.`extends_entity_column_value` AS `extends_entity_column_value`,`civicrm`.`civicrm_custom_group`.`style` AS `style`,`civicrm`.`civicrm_custom_group`.`collapse_display` AS `collapse_display`,`civicrm`.`civicrm_custom_group`.`weight` AS `weight`,`civicrm`.`civicrm_custom_group`.`is_active` AS `is_active`,`civicrm`.`civicrm_custom_group`.`table_name` AS `table_name`,`civicrm`.`civicrm_custom_group`.`is_multiple` AS `is_multiple`,`civicrm`.`civicrm_custom_group`.`min_multiple` AS `min_multiple`,`civicrm`.`civicrm_custom_group`.`max_multiple` AS `max_multiple`,`civicrm`.`civicrm_custom_group`.`collapse_adv_display` AS `collapse_adv_display`,`civicrm`.`civicrm_custom_group`.`created_id` AS `created_id`,`civicrm`.`civicrm_custom_group`.`created_date` AS `created_date`,`civicrm`.`civicrm_custom_group`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_custom_group`.`is_public` AS `is_public`,`civicrm`.`civicrm_custom_group`.`title_en_US` AS `title`,`civicrm`.`civicrm_custom_group`.`help_pre_en_US` AS `help_pre`,`civicrm`.`civicrm_custom_group`.`help_post_en_US` AS `help_post` from `civicrm`.`civicrm_custom_group`

 
select `civicrm`.`civicrm_custom_group`.`id` AS `id`,`civicrm`.`civicrm_custom_group`.`name` AS `name`,`civicrm`.`civicrm_custom_group`.`extends` AS `extends`,`civicrm`.`civicrm_custom_group`.`extends_entity_column_id` AS `extends_entity_column_id`,`civicrm`.`civicrm_custom_group`.`extends_entity_column_value` AS `extends_entity_column_value`,`civicrm`.`civicrm_custom_group`.`style` AS `style`,`civicrm`.`civicrm_custom_group`.`collapse_display` AS `collapse_display`,`civicrm`.`civicrm_custom_group`.`weight` AS `weight`,`civicrm`.`civicrm_custom_group`.`is_active` AS `is_active`,`civicrm`.`civicrm_custom_group`.`table_name` AS `table_name`,`civicrm`.`civicrm_custom_group`.`is_multiple` AS `is_multiple`,`civicrm`.`civicrm_custom_group`.`min_multiple` AS `min_multiple`,`civicrm`.`civicrm_custom_group`.`max_multiple` AS `max_multiple`,`civicrm`.`civicrm_custom_group`.`collapse_adv_display` AS `collapse_adv_display`,`civicrm`.`civicrm_custom_group`.`created_id` AS `created_id`,`civicrm`.`civicrm_custom_group`.`created_date` AS `created_date`,`civicrm`.`civicrm_custom_group`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_custom_group`.`is_public` AS `is_public`,`civicrm`.`civicrm_custom_group`.`title_en_US` AS `title`,`civicrm`.`civicrm_custom_group`.`help_pre_en_US` AS `help_pre`,`civicrm`.`civicrm_custom_group`.`help_post_en_US` AS `help_post` from `civicrm`.`civicrm_custom_group`

Possibly Referenced Tables/Views

civicrm_custom_group