Table: customer_assignment

Previous: customer_address

Unanet Data Model

Next: customer_attachment

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	customer_key	decimal(15)		customer	fk_customer_assignment1
2.	PK	project_key	decimal(15)		project	fk_customer_assignment2

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
customer_key	customer	customer_key	fk_customer_assignment1
project_key	project	project_key	fk_customer_assignment2

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_customer_assignment	true	customer_key	Asc
		project_key
idx_customer_assignment1	false	project_key	Asc

Dependent Views

View Name
assignment_view