| Previous: company_car_detail | Unanet Data Model | Next: contact_address_type |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | contact_address_key | decimal(15) | |||
| 2. | customer_contact_key | decimal(15) | customer_contact | fk_contact_address1 | ||
| 3. | address_key | decimal(15) | address | fk_contact_address3 | ||
| 4. | contact_address_type_key | decimal(15) | contact_address_type | fk_contact_address2 | ||
| 5. | primary_ind | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| address_key | address | address_key | fk_contact_address3 |
| contact_address_type_key | contact_address_type | contact_address_type_key | fk_contact_address2 |
| customer_contact_key | customer_contact | customer_contact_key | fk_contact_address1 |
| Name | Definition |
| cc_contact_addr_primary | ([primary_ind]='N' OR [primary_ind]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_contact_address | true | contact_address_key | Asc |
| idx_contact_address2 | true | customer_contact_key | Asc |
| address_key | |||
| idx_contact_address1 | false | customer_contact_key | Asc |
| idx_contact_address3 | false | address_key | Asc |