Table: role

Previous: resource_request_skill

Unanet Data Model

Next: sequence_number

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