Table: request_allocation

Previous: qrtz_triggers

Unanet Data Model

Next: request_expense_data

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	request_allocation_key	decimal(15)
2.		request_expense_report_key	decimal(15)		request_expense_report	fk_request_allocation1
3.		customer_key	decimal(15)
4.		project_key	decimal(15)
5.		task_key	decimal(15)
6.		project_name	varchar(255)
7.		task_name	varchar(255)
8.		allocation	decimal(6,3)
9.		sequence	decimal(3)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
request_expense_report_key	request_expense_report	request_expense_report_key	fk_request_allocation1

Referenced from

Table	Column	Foreign Key Name
request_expense_data	request_allocation_key	fk_request_expense_data2

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_request_allocation	true	request_allocation_key	Asc