PROJECT_STATUS |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| project_status_key | decimal (15,0) | |||
| status | varchar (50) | |||
| open_status | varchar (1) | |||
References made to PROJECT_STATUS |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| PROJECT | project_status_key | fk_project4 |
Dependent Views |
|
| View Name | |
|---|---|
| SEARCH_PROJECT_VIEW | |
| PROJECT_ASSIGNMENT_VIEW | |
Check Constraints for PROJECT_STATUS |
|
| Check Constraint Name | Definition |
|---|---|
| cc_pjts_open_status | (open_status = 'N' or (open_status = 'Y')) |
Indexes on PROJECT_STATUS |
|
| Index Name | Column(s) |
|---|---|
| idx_status1 | status |
| pk_project_status | project_status_key |