CUSTOMER_APPROVER |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| project_key | decimal (15,0) | PROJECT | fk_customer_approver2 | |
| person_key | decimal (15,0) | PERSON | fk_customer_approver | |
| approve_time | varchar (1) | |||
| approve_expense | varchar (1) | |||
| approve_sequence | varchar (1) | |||
| last_update | datetime | |||
Check Constraints for CUSTOMER_APPROVER |
|
| Check Constraint Name | Definition |
|---|---|
| cc_ca_approve_sequence | (approve_sequence = 'P' or (approve_sequence = 'C' or (approve_sequence = 'N'))) |
Indexes on CUSTOMER_APPROVER |
|
| Index Name | Column(s) |
|---|---|
| pk_customer_approver | project_key, person_key |