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) |
|
| 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 |
|
|