Table: time_cust_approval_status

Previous: task_depends

Unanet Data Model

Next: time_period

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	person_time_key	decimal(15)		person_time	fk_time_cust_approval_status1
2.	PK	project_key	decimal(15)		project	fk_time_cust_approval_status2
3.		approved	char(1)
4.		customer_approves_first	char(1)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_time_key	person_time	person_time_key	fk_time_cust_approval_status1
project_key	project	project_key	fk_time_cust_approval_status2

Check Constraints

Name	Definition
cc_tcas_approved	([approved]='N' OR [approved]='Y')
cc_tcas_cust_appr_first	([customer_approves_first]='N' OR [customer_approves_first]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_time_cust_approval_status	true	person_time_key	Asc
		project_key
idx_time_cust_approval_status1	false	project_key	Asc