Table: Privilege
Tags: read-only Content of first 30 of 614 rows:
0 | 0 | CSP | <Product_Name> | 10 | 0 | 1 | CSP | 0010
1 | 404 | Setup | Setup Menu | 1340 | 0 | 3 | CSP_Menu_Setup | 0010_0020_1340
2 | 1 | Firm | <Firm> | 1350 | 1 | 4 | CSP_Menu_Setup_Firm | 0010_0020_1340_1350
3 | 1 | Validation | -- Validation Lists Deprecated | 1730 | 1 | 4 | CSP_Menu_Setup_Validation | 0010_0020_1340_1730
4 | 449 | Billing | Billing Data | 2130 | 0 | 4 | CSP_Data_Client_Billing | 0010_1750_1820_2130
5 | 1 | Templates | Templates | 1430 | 0 | 4 | CSP_Menu_Setup_Templates | 0010_0020_1340_1430
6 | 1 | Security | Security Groups | 1400 | 1 | 4 | CSP_Menu_Setup_Security | 0010_0020_1340_1400
7 | 1 | RecurBill | Recurring Bill Descriptions | 1510 | 1 | 4 | CSP_Menu_Setup_RecurBill | 0010_0020_1340_1510
8 | 1 | Clients | <Clients> | 1390 | 1 | 4 | CSP_Menu_Setup_Clients | 0010_0020_1340_1390
9 | 1 | Staff | <Staffs> | 1370 | 1 | 4 | CSP_Menu_Setup_Staff | 0010_0020_1340_1370
10 | 469 | Main | Main Data | 3870 | 0 | 4 | CSP_Data_Staff_Main | 0010_1750_3700_3870
11 | 10 | View | View | 3880 | 1 | 5 | CSP_Data_Staff_Main_View | 0010_1750_3700_3870_3880
12 | 10 | Edit | Edit | 3890 | 1 | 5 | CSP_Data_Staff_Main_Edit | 0010_1750_3700_3870_3890
13 | 585 | Staff | <Staff> <Contacts> | 2435 | 0 | 4 | CSP_Data_Contact_Staff | 0010_1750_2325_2435
14 | 13 | View | View | 2445 | 0 | 5 | CSP_Data_Contact_Staff_View | 0010_1750_2325_2435_2445
15 | 13 | Edit | Edit | 2495 | 0 | 5 | CSP_Data_Contact_Staff_Edit | 0010_1750_2325_2435_2495
16 | 469 | Rates | <Staff> Rates Data | 4210 | 0 | 4 | CSP_Data_Staff_Rates | 0010_1750_3700_4210
17 | 16 | View | View | 4220 | 1 | 5 | CSP_Data_Staff_Rates_View | 0010_1750_3700_4210_4220
18 | 16 | Edit | Edit | 4230 | 1 | 5 | CSP_Data_Staff_Rates_Edit | 0010_1750_3700_4210_4230
19 | 469 | Security | Security Data | 4270 | 0 | 4 | CSP_Data_Staff_Security | 0010_1750_3700_4270
20 | 19 | View | View | 4280 | 1 | 5 | CSP_Data_Staff_Security_View | 0010_1750_3700_4270_4280
21 | 19 | Edit | Edit | 4290 | 1 | 5 | CSP_Data_Staff_Security_Edit | 0010_1750_3700_4270_4290
22 | 469 | Memo | Notes | 4360 | 0 | 4 | CSP_Data_Staff_Memo | 0010_1750_3700_4360
23 | 22 | View | View | 4370 | 1 | 5 | CSP_Data_Staff_Memo_View | 0010_1750_3700_4360_4370
24 | 22 | Edit | Edit | 4380 | 1 | 5 | CSP_Data_Staff_Memo_Edit | 0010_1750_3700_4360_4380
25 | 26 | MOSS | For <Staffs> in Same <Office> | 3740 | 1 | 6 | CSP_Data_Staff_View_Others_MOSS | 0010_1750_3700_3710_3730_3740
26 | 340 | Others | For Other <Staffs> | 3730 | 0 | 5 | CSP_Data_Staff_View_Others | 0010_1750_3700_3710_3730
27 | 345 | Others | For Other <Staffs> | 3810 | 0 | 5 | CSP_Data_Staff_Edit_Others | 0010_1750_3700_3790_3810
28 | 343 | MOSS | For <Staffs> in Same <Office> | 3770 | 1 | 5 | CSP_Data_Staff_Add_MOSS | 0010_1750_3700_3760_3770
29 | 344 | MOSS | For <Staffs> in Same <Office> | 3850 | 1 | 5 | CSP_Data_Staff_Delete_MOSS | 0010_1750_3700_3840_3850
Columns
Name | Type | Constraints | Description
privilege_KEY | int | NOT NULL | Database assigned primary key for this table.
parent__privilege_KEY | int | NOT NULL | Foreign key to the parent of this Privilege.
code | nvarchar (10) | NOT NULL | This is a shorter version of Description that is used for the privilege path.
description | nvarchar (50) | NOT NULL | This is the description that users will see.
sort | int | NOT NULL | It is required that the privileges sort in a particular order. This is how the order is specified.
leaf | tinyint (3) | NOT NULL | 1 if this is a privilege and 0 if it is a privilege folder.
tree_level | int | NOT NULL | The level in the tree.
hierarchy | nvarchar (450) | NOT NULL | Calculated by the database to allow privileges to be sorted quickly in tree structure.
sort_hierarchy | nvarchar (450) | NOT NULL | Same as Hierarchy except that the values from Sort column are used.

Primary key
Name | Columns | Description
PK_Privilege$privilege_KEY | privilege_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Privilege$hierarchy | hierarchy |
UK_Privilege$sort_hierarchy | sort_hierarchy |
Indexes
Name | Columns | Description
IX_Privilege$parent__privilege_KEY | parent__privilege_KEY | Index supports foreign key FK_Privilege__Privilege__parent__privilege_KEY

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Privilege_Dependency__Privilege__dependent__privilege_KEY | dependent__privilege_KEY | Privilege_Dependency |
FK_Privilege_Dependency__Privilege__privilege_KEY | privilege_KEY | Privilege_Dependency |
FK_Report_Definition_Privilege_Dependency__Privilege__privilege_KEY | privilege_KEY | Report_Definition_Privilege_Dependency |