ADDRESS |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| address_key | decimal (15,0) | |||
| address | varchar (50) | YES | ||
| address2 | varchar (50) | YES | ||
| address3 | varchar (50) | YES | ||
| address4 | varchar (50) | YES | ||
| city | varchar (25) | YES | ||
| state | varchar (25) | YES | ||
| postal_code | varchar (10) | YES | ||
| country | varchar (25) | YES | ||
| description | varchar (128) | YES | ||
References made to ADDRESS |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| CONTACT_ADDRESS | address_key | fk_contact_address2 |
| CUSTOMER_ADDRESS | address_key | fk_customer_address2 |
Indexes on ADDRESS |
|
| Index Name | Column(s) |
|---|---|
| pk_address | address_key |