|
Database Documentation |
The group table. Each group belongs to a single domain and contains zero or more users (from the same domain). If a group is removed, care must be taken to also remove all referencing rows in other tables.
| Column Summary | |
|---|---|
| COMMENT | VARCHAR(200) NOT NULLThe group comment. |
| DESCRIPTION | VARCHAR(100) NOT NULLThe informative description of the group. |
| DOMAIN | VARCHAR(30) NOT NULLThe name of the domain that the group belongs to. |
| NAME | VARCHAR(30) NOT NULLThe unique group name. |
| PUBLIC | SMALLINT NOT NULLThe public group flag. |
| Index Summary | |
|---|---|
| PRIMARY KEY | (DOMAIN, NAME)The group is uniquely indexed by domain and name. |
DOMAIN VARCHAR(30) NOT NULL
The name of the domain that the group belongs to.
LS_DOMAIN.NAME
LS_USER_GROUP.DOMAIN
NAME VARCHAR(30) NOT NULL
The unique group name. The group name is only unique within the domain, and may overlap with other groups in other domains. The group name SHOULD NOT be modified after creation, unless all referencing tables also are updated.
LS_USER_GROUP.GROUP
LS_PERMISSION.GROUP
DESCRIPTION VARCHAR(100) NOT NULL
The informative description of the group.
PUBLIC SMALLINT NOT NULL
The public group flag. This flag is set to one (1) if the group allows users to add or remove themselves from the group. This is used for non-security related groups, such as mailing list memberships and similar.
COMMENT VARCHAR(200) NOT NULL
The group comment. The comment can be used to add additional information about a group.
PRIMARY KEY (DOMAIN, NAME)
The group is uniquely indexed by domain and name.
|
Database Documentation |