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.