Table: Privilege
Tags: read-only

Content of first 30 of 613 rows:
00CSP<Product_Name>1001CSP0010
1404SetupSetup Menu134003CSP_Menu_Setup0010_0020_1340
21Firm<Firm>135014CSP_Menu_Setup_Firm0010_0020_1340_1350
31Validation-- Validation Lists Deprecated173014CSP_Menu_Setup_Validation0010_0020_1340_1730
4449BillingBilling Data213004CSP_Data_Client_Billing0010_1750_1820_2130
51TemplatesTemplates143004CSP_Menu_Setup_Templates0010_0020_1340_1430
61SecuritySecurity Groups140014CSP_Menu_Setup_Security0010_0020_1340_1400
71RecurBillRecurring Bill Descriptions151014CSP_Menu_Setup_RecurBill0010_0020_1340_1510
81Clients<Clients>139014CSP_Menu_Setup_Clients0010_0020_1340_1390
91Staff<Staffs>137014CSP_Menu_Setup_Staff0010_0020_1340_1370
10469MainMain Data387004CSP_Data_Staff_Main0010_1750_3700_3870
1110ViewView388015CSP_Data_Staff_Main_View0010_1750_3700_3870_3880
1210EditEdit389015CSP_Data_Staff_Main_Edit0010_1750_3700_3870_3890
13585Staff<Staff> <Contacts>243504CSP_Data_Contact_Staff0010_1750_2325_2435
1413ViewView244505CSP_Data_Contact_Staff_View0010_1750_2325_2435_2445
1513EditEdit249505CSP_Data_Contact_Staff_Edit0010_1750_2325_2435_2495
16469Rates<Staff> Rates Data421004CSP_Data_Staff_Rates0010_1750_3700_4210
1716ViewView422015CSP_Data_Staff_Rates_View0010_1750_3700_4210_4220
1816EditEdit423015CSP_Data_Staff_Rates_Edit0010_1750_3700_4210_4230
19469SecuritySecurity Data427004CSP_Data_Staff_Security0010_1750_3700_4270
2019ViewView428015CSP_Data_Staff_Security_View0010_1750_3700_4270_4280
2119EditEdit429015CSP_Data_Staff_Security_Edit0010_1750_3700_4270_4290
22469MemoNotes436004CSP_Data_Staff_Memo0010_1750_3700_4360
2322ViewView437015CSP_Data_Staff_Memo_View0010_1750_3700_4360_4370
2422EditEdit438015CSP_Data_Staff_Memo_Edit0010_1750_3700_4360_4380
2526MOSSFor <Staffs> in Same <Office>374016CSP_Data_Staff_View_Others_MOSS0010_1750_3700_3710_3730_3740
26340OthersFor Other <Staffs>373005CSP_Data_Staff_View_Others0010_1750_3700_3710_3730
27345OthersFor Other <Staffs>381005CSP_Data_Staff_Edit_Others0010_1750_3700_3790_3810
28343MOSSFor <Staffs> in Same <Office>377015CSP_Data_Staff_Add_MOSS0010_1750_3700_3760_3770
29344MOSSFor <Staffs> in Same <Office>385015CSP_Data_Staff_Delete_MOSS0010_1750_3700_3840_3850
Columns
NameTypeConstraintsDescription
privilege_KEYintNOT NULLDatabase assigned primary key for this table.
parent__privilege_KEYintNOT NULLForeign key to the parent of this Privilege.
codenvarchar (10)NOT NULLThis is a shorter version of Description that is used for the privilege path.
descriptionnvarchar (50)NOT NULLThis is the description that users will see.
sortintNOT NULLIt is required that the privileges sort in a particular order. This is how the order is specified.
leaftinyint (3)NOT NULL1 if this is a privilege and 0 if it is a privilege folder.
tree_levelintNOT NULLThe level in the tree.
hierarchynvarchar (450)NOT NULLCalculated by the database to allow privileges to be sorted quickly in tree structure.
sort_hierarchynvarchar (450)NOT NULLSame as Hierarchy except that the values from Sort column are used.
Primary key
NameColumnsDescription
PK_Privilege$privilege_KEYprivilege_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Privilege$hierarchyhierarchy
UK_Privilege$sort_hierarchysort_hierarchy
Indexes
NameColumnsDescription
IX_Privilege$parent__privilege_KEYparent__privilege_KEYIndex supports foreign key FK_Privilege__Privilege__parent__privilege_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Privilege_Dependency__Privilege__dependent__privilege_KEYdependent__privilege_KEYPrivilege_Dependency
FK_Privilege_Dependency__Privilege__privilege_KEYprivilege_KEYPrivilege_Dependency
FK_Report_Definition_Privilege_Dependency__Privilege__privilege_KEYprivilege_KEYReport_Definition_Privilege_Dependency

Schema diagram