Table: approval_chain
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
chain_key |
decimal(15) |
|
chain |
fk_approval_chain1 |
| 2. |
PK |
person_key |
decimal(15) |
|
person |
fk_approval_chain2 |
| 3. |
|
priority_level |
decimal(3) |
|
|
|
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| chain_key |
chain |
chain_key |
fk_approval_chain1 |
| person_key |
person |
person_key |
fk_approval_chain2 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_approval_chain |
true |
chain_key |
Asc |
| |
|
person_key |
|
| idx_approval_chain1 |
false |
person_key |
Asc |