Topic Last Modified: 2011-01-27
The RoleType table 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 three available roles:
- Member: Chat room member
- Manager: Chat room manager
- Voiced: Presenter for an auditorium chat room
|
rtypeAllowedPermSet
|
bigint, not null
|
Permission set for the role. The used values are:
- 2: True if the role can manage nodes.
- 4: True if the role can create children nodes.
- 5: True if the role can modify roles (obsolete).
- 6: True if the role can modify settings (obsolete).
- 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).
- 9: True if the role can leave a chat room (or 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.
|
honorsOverride
|
bit, not null
|
True if the role can be overridden by children nodes. False if
the role cannot.
|
honorsScope
|
bit, not null
|
True if the role obeys scope. False if the role does not.
|
Key
Column |
Description |
rtypeID
|
Primary key.
|