tblRoleType
tblRoleType is a static lookup table with role types and their associated permission sets.
Columns
| Column | Type | Description |
|---|---|---|
| rtypeID |
int, not null |
Role type ID. |
| rtypeDesc |
nvarchar (256), not null |
Role type description. There are four available roles: Member: Chat room member Manager: Chat room manager Voiced: Presenter for an auditorium chat room Creator: Can create chat rooms |
| rtypeAllowedPermSet |
bigint, not null |
Permission set for the role. The used bits are: 2: True if the role can manage nodes. 4: True if the role can create children nodes. 7: True if the role can join a chat room (or children chat rooms of a category). 8: True if the role can chat in a chat room (or in children chat rooms of a category). 10: True if the role can read chat history even when not joined to a chat room. 11: True if the role can see the chat room. (This is further refined by factors such as scope and visibility.) 12: True if the role can chat in an auditorium chat room. 13: True if the role can bypass visibility rules when viewing nodes. |
Key
| Column | Description |
|---|---|
| rtypeID |
Primary key. |