civicrm_group_en_US

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 0

Group ID

name VARCHAR 64 null

Internal name of Group.

description TEXT 65535 null

Optional verbose description of the group.

source VARCHAR 64 null

Module or process which created this group.

saved_search_id INT UNSIGNED 10 null

FK to saved search table.

is_active TINYINT 3 null

Is this entry active?

visibility VARCHAR 24 User and User Admin Only

In what context(s) is this field visible.

where_clause TEXT 65535 null

the sql where clause if a saved search acl

select_tables TEXT 65535 null

the tables to be included in a select data

where_tables TEXT 65535 null

the tables to be included in the count statement

group_type VARCHAR 128 null

FK to group type

cache_date TIMESTAMP 19 null
refresh_date TIMESTAMP 19 null
parents TEXT 65535 null

IDs of the parent(s)

children TEXT 65535 null

IDs of the child(ren)

is_hidden TINYINT 3 0

Is this group hidden?

is_reserved TINYINT 3 0
created_id INT UNSIGNED 10 null

FK to contact table.

modified_id INT UNSIGNED 10 null

FK to contact table.

title VARCHAR 64 null

View Definition


Possibly Referenced Tables/Views