Table: alternate
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
alternate_key |
decimal(15) |
|
person |
fk_alternate1 |
| 2. |
PK |
person_key |
decimal(15) |
|
member |
fk_alternate2 |
| 3. |
PK |
role_key |
decimal(15) |
|
member |
fk_alternate2 |
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| person_key |
member |
person_key |
fk_alternate2 |
| role_key |
|
role_key |
|
| alternate_key |
person |
person_key |
fk_alternate1 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_alternate |
true |
alternate_key |
Asc |
| |
|
person_key |
|
| |
|
role_key |
|
| idx_alternate1 |
false |
person_key |
Asc |