Table: role

Previous: resource_request_skill Unanet Data Model Next: section_status
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
fin_document_approval role_key fk_fd_approval5
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
project_restrict_access role_key fk_project_restrict_access2
purchase_order_approval role_key fk_po_approval5
purchase_requisition_approval role_key fk_pr_approval5
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]='poVIApprover' OR [role_name]='poOwner' OR [role_name]='projectDocumentViewer' OR [role_name]='documentViewer' OR [role_name]='documentManager' OR [role_name]='apManager' OR [role_name]='purchasingManager' OR [role_name]='projectPOViewer' OR [role_name]='purchaseOrderViewer' OR [role_name]='purchaseOrderAssigner' OR [role_name]='purchaser' OR [role_name]='projectPRViewer' OR [role_name]='purchaseRequisitionViewer' OR [role_name]='purchaseRequestor' 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