Table: assignment_display

Previous: approval_history

Unanet Data Model

Next: attachment

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.		project_key	decimal(15)		project	fk_assignment_display1
2.		task_key	decimal(15)		task	fk_assignment_display2
3.		person_key	decimal(15)		person	fk_assignment_display3
4.		show	char(1)	('Y')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_assignment_display3
project_key	project	project_key	fk_assignment_display1
task_key	task	task_key	fk_assignment_display2

Check Constraints

Name	Definition
cc_ad_show	([show]='Y' OR [show]='N')

Indices

Index Name	Unique	Column Name	Asc Or Desc
idx_assignment_display1	true	person_key	Asc
		project_key
		task_key
idx_assignment_display2	false	project_key	Asc
idx_assignment_display3	false	task_key	Asc