TIME_CUST_APPROVAL_STATUS |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| person_time_key | decimal (15,0) | PERSON_TIME | fk_time_cust_approval_status1 | |
| project_key | decimal (15,0) | PROJECT | fk_time_cust_approval_status2 | |
| approved | varchar (1) | |||
Check Constraints for TIME_CUST_APPROVAL_STATUS |
|
| Check Constraint Name | Definition |
|---|---|
| cc_tcas_approved | (approved = 'N' or (approved = 'Y')) |
Indexes on TIME_CUST_APPROVAL_STATUS |
|
| Index Name | Column(s) |
|---|---|
| pk_time_cust_approval_status | person_time_key, project_key |