Table: project_status

Previous: project_post_history

Unanet Data Model

Next: project_type

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	project_status_key	decimal(15)
2.		status	varchar(50)
3.		open_status	char(1)

Referenced from

Table	Column	Foreign Key Name
project	project_status_key	fk_project4

Check Constraints

Name	Definition
cc_pjts_open_status	([open_status]='N' OR [open_status]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_project_status	true	project_status_key	Asc
idx_status1	true	status	Asc