Groups |
Store all groups of users.
`Groups` table.
Name | Type | Description |
|---|---|---|
Id | INT [auto-generated] NOT NULL | ID of the group |
Name | NVARCHAR(255) NOT NULL | Name of the group |
Description | NVARCHAR(MAX) | Description of the group |
ParentId | INT FOREIGN KEY NULLABLE | Id of the parent group |
CreatedBy | INT FOREIGN KEY NOT NULL | Id of the user who has created the group |
CreatedAt | DATETIME NOT NULL | Date of creation |
UpdatedBy | INT FOREIGN KEY NOT NULL | Id of the latest user who has updated the group |
UpdatedAt | DATETIME NOT NULL | Date of the latest update |
IsDeleted | BIT NOT NULL | Indicates if the group is deleted |
DeletedBy | INT FOREIGN KEY NULLABLE | Id of the user who has deleted the group |
DeletedAt | DATETIME NULLABLE | Date of deletion |
See Also