tblRoleType

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.
  

rtypeID

Primary key.