Table: expense_report_attachment

Previous: expense_report

Unanet Data Model

Next: expense_task_budget

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_report_key	decimal(15)		expense_report	fk_expense_report_attachment1
2.	PK	attachment_key	decimal(15)		attachment	fk_expense_report_attachment2
3.		created	datetime	(getdate())

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
attachment_key	attachment	attachment_key	fk_expense_report_attachment2
expense_report_key	expense_report	expense_report_key	fk_expense_report_attachment1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_expense_report_attachment	true	expense_report_key	Asc
		attachment_key
idx_expense_report_attachment1	true	attachment_key	Asc