CUSTOMER_ADDRESS |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| customer_key | decimal (15,0) | CUSTOMER | fk_customer_address1 | |
| address_key | decimal (15,0) | ADDRESS | fk_customer_address2 | |
| address_type_key | decimal (15,0) | ADDRESS_TYPE | fk_customer_address3 | |
Indexes on CUSTOMER_ADDRESS |
|
| Index Name | Column(s) |
|---|---|
| pk_customer_address | customer_key, address_key, address_type_key |