Table: role

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK role_key decimal(15)      
2.   role_name varchar(25)      
3.   role_description varchar(50)      
4.   assignable char(1)      
5.   deleteable char(1)      
6.   editable char(1) ('Y')    
7.   category tinyint      
Referenced from
Table Column Foreign Key Name
approval_history role_key fk_approval_history5
expense_history role_key fk_expense_history5
leave_request_approval role_key fk_leave_request_approval4
member role_key fk_member2
org_access_person role_key fk_org_access_person2
project_controller role_key fk_project_controller3
project_note_role role_key fk_project_note_role2
resource_request_history role_key fk_resource_request_history4
Check Constraints
Name Definition
cc_role_category ([category]=(30) OR [category]=(20) OR [category]=(10))
cc_role_key_reservation ([role_key]>(100) OR ([role_name]='dataManager' OR [role_name]='costBudgetViewer' OR [role_name]='billBudgetViewer' OR [role_name]='costBudgetManager' OR [role_name]='billBudgetManager' OR [role_name]='contactViewer' OR [role_name]='contactManager' OR [role_name]='glBudgetManager' OR [role_name]='glViewer' OR [role_name]='glUser' OR [role_name]='glPoster' OR [role_name]='glAdmin' OR [role_name]='apViewer' OR [role_name]='apUser' OR [role_name]='apPoster' OR [role_name]='apAdmin' OR [role_name]='arViewer' OR [role_name]='arUser' OR [role_name]='arPoster' OR [role_name]='arAdmin' OR [role_name]='prAdministrator' OR [role_name]='billingViewer' OR [role_name]='billingManager' OR [role_name]='resourceRequestor' OR [role_name]='resourceAssigner' OR [role_name]='billRateManager' OR [role_name]='resourcePlanner' OR [role_name]='projectViewer' OR [role_name]='projectApprover' OR [role_name]='projectLead' OR [role_name]='HRAdministrator' OR [role_name]='costRateManager' OR [role_name]='unaSourceUser' OR [role_name]='viewer' OR [role_name]='customer' OR [role_name]='expenseUser' OR [role_name]='timesheetUser' OR [role_name]='projectManager' OR [role_name]='manager' OR [role_name]='administrator'))
Indices
Index Name Unique Column Name Asc Or Desc
pk_role true role_key Asc