Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GroupId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each user group |
||||
| GroupName | nvarchar | 400 | √ | null |
|
|
Group name - Name of the user group for identification and display |
||||
| GroupDesc | nvarchar | 400 | √ | null |
|
|
Group description - Detailed description of the group purpose and permissions |
||||
| CreateBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this group |
||||
| CreateDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the group was created |
||||
| UpdateBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this group |
||||
| UpdateDate | datetime | 16,3 | √ | null |
|
|
Last update date - Date when the group was last updated |
||||
| DeleteBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted this group (soft delete) |
||||
| DeleteDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the group was deleted (soft delete for audit trail) |
||||
| IsLocked | bit | 1 | ((0)) |
|
|
Locked flag - Boolean indicating if the group is locked from modifications |
|||||
| IsAllowChat | bit | 1 | √ | null |
|
|
Chat allowed flag - Boolean indicating if group members are allowed to use chat features |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Groups | Primary key | Asc | GroupId |
Relationships
Close relationships within degrees of separation
