Table: customer_contact

Previous: customer_attachment

Unanet Data Model

Next: customer_contact_category

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	customer_contact_key	decimal(15)
2.		customer_key	decimal(15)		customer	fk_customer_contact1
3.		first_name	varchar(50)
4.		last_name	varchar(50)
5.		middle_initial	char(1)
6.		suffix	varchar(10)
7.		salutation	varchar(120)
8.		title	varchar(240)
9.		active	char(1)	('Y')
10.		default_bill_to	char(1)	('N')
11.		default_ship_to	char(1)	('N')
12.		default_remit_to	char(1)	('N')
13.		comments	varchar(2000)
14.		created_timestamp	datetime
15.		created_by	decimal(15)		person	fk_customer_contact2
16.		last_updated_timestamp	datetime
17.		last_updated_by	decimal(15)		person	fk_customer_contact3

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
customer_key	customer	customer_key	fk_customer_contact1
created_by	person	person_key	fk_customer_contact2
last_updated_by	person	person_key	fk_customer_contact3

Referenced from

Table	Column	Foreign Key Name
contact_address	customer_contact_key	fk_contact_address1
contact_email	customer_contact_key	fk_contact_email1
contact_phone	customer_contact_key	fk_contact_phone1
customer_contact_category	customer_contact_key	fk_customer_contact_category1
project_invoice	bill_to_contact_key	fk_project_invoice7
project_invoice	remit_to_contact_key	fk_project_invoice9
project_invoice	ship_to_contact_key	fk_project_invoice11

Check Constraints

Name	Definition
cc_cust_contact_active	([active]='N' OR [active]='Y')
cc_cust_contact_bill	([default_bill_to]='N' OR [default_bill_to]='Y')
cc_cust_contact_remit	([default_remit_to]='N' OR [default_remit_to]='Y')
cc_cust_contact_ship	([default_ship_to]='N' OR [default_ship_to]='Y')
cc_cust_created_timestamp	([created_timestamp]>='1900-01-01' AND [created_timestamp]<='2099-12-31')
cc_cust_last_updated_timestamp	([last_updated_timestamp]>='1900-01-01' AND [last_updated_timestamp]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_customer_contact	true	customer_contact_key	Asc
idx_customer_contact1	false	customer_key	Asc