Topic Last Modified: 2012-06-25

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.