APPROVAL_HISTORY |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| approval_history_key | decimal (15,0) | |||
| person_time_key | decimal (15,0) | PERSON_TIME | fk_approval_history1 | |
| person_key | decimal (15,0) | YES | PERSON | fk_approval_history2 |
| action_date | datetime | |||
| approved | varchar (1) | |||
| passed_to | decimal (15,0) | YES | PERSON | fk_approval_history4 |
| project_key | decimal (15,0) | YES | PROJECT | fk_approval_history3 |
| comments | text | YES | ||
| status | varchar (25) | |||
| role_key | decimal (15,0) | YES | ROLE | fk_approval_history5 |
Check Constraints for APPROVAL_HISTORY |
|
| Check Constraint Name | Definition |
|---|---|
| cc_ah_approved | (approved = 'N' or (approved = 'Y')) |
| cc_ah_status | (status = 'LOCKED' or (status = 'EXTRACTED' or (status = 'COMPLETED' or (status = 'DISAPPROVED' or (status = 'APPROVING' or (status = 'SUBMITTED' or (status = 'INUSE'))))))) |
Indexes on APPROVAL_HISTORY |
|
| Index Name | Column(s) |
|---|---|
| pk_approval_history | approval_history_key |