CONTACT_TYPE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| contact_type_key | decimal (15,0) | |||
| contact_type | varchar (25) | |||
| description | varchar (128) | YES | ||
References made to CONTACT_TYPE |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| CUSTOMER_CONTACT | contact_type_key | fk_customer_contact3 |
| PROJECT_CONTACT | contact_type_key | fk_project_contact3 |
Indexes on CONTACT_TYPE |
|
| Index Name | Column(s) |
|---|---|
| idx_contact_type1 | contact_type |
| pk_contact_type | contact_type_key |