Table: project_fee

Previous: project_expense_type

Unanet Data Model

Next: project_invoice

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	project_key	decimal(15)		project	fk_project_fee1
2.	PK	fee_method_key	decimal(15)		fee_method	fk_project_fee2
3.		fee_factor_type	char(1)	('P')
4.		fee_factor	decimal(5,2)
5.		fixed_fee_amount	decimal(15,2)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
fee_method_key	fee_method	fee_method_key	fk_project_fee2
project_key	project	project_key	fk_project_fee1

Check Constraints

Name	Definition
cc_project_fee_factor_type	([fee_factor_type]='N' OR [fee_factor_type]='P')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_project_fee_key	true	project_key	Asc
		fee_method_key
idx_project_fee1	false	fee_method_key	Asc