Table: project_budget_history

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	project_budget_history_key	decimal(15)
2.		project_key	decimal(15)		project	fk_project_budget_history2
3.		modified_by	decimal(15)		person	fk_project_budget_history1
4.		modified_date	datetime
5.		orig_start_date	datetime
6.		orig_end_date	datetime
7.		rev_start_date	datetime
8.		rev_end_date	datetime
9.		completed_date	datetime
10.		total_value	decimal(15,2)
11.		funded_value	decimal(15,2)
12.		hours_budget	decimal(15,2)
13.		hours_etc	decimal(15,2)
14.		hours_est_tot	decimal(15,2)
15.		exp_bill_budget	decimal(15,2)
16.		exp_cost_budget	decimal(15,2)
17.		exp_cost_burden_budget	decimal(15,2)
18.		exp_bill_etc	decimal(15,2)
19.		exp_cost_etc	decimal(15,2)
20.		exp_bill_est_tot	decimal(15,2)
21.		exp_cost_est_tot	decimal(15,2)
22.		labor_bill_budget	decimal(15,2)
23.		labor_cost_budget	decimal(15,2)
24.		labor_cost_burden_budget	decimal(15,2)
25.		labor_bill_etc	decimal(15,2)
26.		labor_cost_etc	decimal(15,2)
27.		labor_bill_est_tot	decimal(15,2)
28.		labor_cost_est_tot	decimal(15,2)
29.		probability_percent	decimal(3)
30.		percent_complete	decimal(6,3)
31.		pct_complete_rule	char(1)
32.		enforce_wbs_dates	char(1)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
modified_by	person	person_key	fk_project_budget_history1
project_key	project	project_key	fk_project_budget_history2

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_project_budget_history	true	project_budget_history_key	Asc
idx_project_budget_history1	false	project_key	Asc
		modified_date
		modified_by