Project Data Tables Database > td Schema : td.GROUPS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
GR_ID | The record ID. | int | 4 | ||||
GR_GROUP_ID | The ID of the group serves as its bit-offset in masks that define characteristics of groups. | int | 4 | ||||
GR_GROUP_NAME | The name of the group. | varchar | 60 | ||||
GR_IS_SYSTEM | A value of Y indicates that this is a default user group created automatically in new projects. N indicates that the group was added. | varchar | 1 | ||||
GR_PREDEF_FILTER | The default view filter for members of the group. | varchar | 16 | ||||
GR_LOGICAL_NAME | A name, unique in the scope of this table, that refers to this record. | varchar | 64 |
Index | Description | Primary | Unique |
---|---|---|---|
GR_LOGICAL_NAME_IDX | |||
GROUPS_PK | |||
GROUPS_UK |