| privilege_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
| parent__privilege_KEY | int (4) | NOT NULL | Foreign key to the parent of this Privilege. |
| code | nvarchar (30) | NOT NULL | This is a shorter version of Description that is used for the privilege path. |
| description | nvarchar (120) | NOT NULL | This is the description that users will see. |
| sort | int (4) | NOT NULL | It is required that the privileges sort in a particular order. This is how the order is specified. |
| leaf | tinyint (1) | NOT NULL | 1 if this is a privilege and 0 if it is a privilege folder. |
| tree_level | int (4) | NOT NULL | The level in the tree. |
| hierarchy | nvarchar (900) | NOT NULL | Calculated by the database to allow privileges to be sorted quickly in tree structure. |
| sort_hierarchy | nvarchar (900) | NOT NULL | Same as Hierarchy except that the values from Sort column are used. |