Table: project_type_exp_type_acct

Previous: project_type_account

Unanet Data Model

Next: purchase_order

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	project_type_key	decimal(15)		project_type	fk_project_type_exp_type_acct1
2.	PK	expense_type_key	decimal(15)		expense_type	fk_project_type_exp_type_acct2
3.		account_key	decimal(15)		account	fk_project_type_exp_type_acct3

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_project_type_exp_type_acct3
expense_type_key	expense_type	expense_type_key	fk_project_type_exp_type_acct2
project_type_key	project_type	project_type_key	fk_project_type_exp_type_acct1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_project_type_exp_type_acct	true	project_type_key	Asc
		expense_type_key
idx_proj_type_exp_type_acct1	false	expense_type_key	Asc
idx_proj_type_exp_type_acct2	false	account_key	Asc