PHONE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| phone_key | decimal (15,0) | |||
| phone_number | varchar (25) | |||
| extension | varchar (10) | YES | ||
| description | varchar (128) | YES | ||
References made to PHONE |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| CONTACT_PHONE | phone_key | fk_contact_phone2 |
| CUSTOMER_PHONE | phone_key | fk_customer_phone2 |
Indexes on PHONE |
|
| Index Name | Column(s) |
|---|---|
| pk_phone | phone_key |