ADDRESS_TYPE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| address_type_key | decimal (15,0) | |||
| address_type | varchar (25) | |||
| description | varchar (128) | YES | ||
References made to ADDRESS_TYPE |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| CONTACT_ADDRESS | address_type_key | fk_contact_address3 |
| CUSTOMER_ADDRESS | address_type_key | fk_customer_address3 |
Indexes on ADDRESS_TYPE |
|
| Index Name | Column(s) |
|---|---|
| idx_address_type1 | address_type |
| pk_address_type | address_type_key |