Table: task_budget_snapshot

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	task_budget_snapshot_key	decimal(15)
2.		project_key	decimal(15)		project	fk_task_budget_snapshot1
3.		task_key	decimal(15)		task	fk_task_budget_snapshot2
4.		eff_thru_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.		hours_budget	decimal(15,2)
11.		hours_etc	decimal(15,2)
12.		hours_est_tot	decimal(15,2)
13.		exp_bill_budget	decimal(15,2)
14.		exp_cost_budget	decimal(15,2)
15.		exp_cost_burden_budget	decimal(15,2)
16.		exp_bill_etc	decimal(15,2)
17.		exp_cost_etc	decimal(15,2)
18.		exp_bill_est_tot	decimal(15,2)
19.		exp_cost_est_tot	decimal(15,2)
20.		labor_bill_budget	decimal(15,2)
21.		labor_cost_budget	decimal(15,2)
22.		labor_cost_burden_budget	decimal(15,2)
23.		labor_bill_etc	decimal(15,2)
24.		labor_cost_etc	decimal(15,2)
25.		labor_bill_est_tot	decimal(15,2)
26.		labor_cost_est_tot	decimal(15,2)
27.		percent_complete	decimal(6,3)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
project_key	project	project_key	fk_task_budget_snapshot1
task_key	task	task_key	fk_task_budget_snapshot2

Check Constraints
Name	Definition
cc_tbs_completed_date	([completed_date]>='1900-01-01' AND [completed_date]<='2099-12-31')
cc_tbs_eff_thru_date	([eff_thru_date]>='1900-01-01' AND [eff_thru_date]<='2099-12-31')
cc_tbs_orig_end_date	([orig_end_date]>='1900-01-01' AND [orig_end_date]<='2099-12-31')
cc_tbs_orig_start_date	([orig_start_date]>='1900-01-01' AND [orig_start_date]<='2099-12-31')
cc_tbs_rev_end_date	([rev_end_date]>='1900-01-01' AND [rev_end_date]<='2099-12-31')
cc_tbs_rev_start_date	([rev_start_date]>='1900-01-01' AND [rev_start_date]<='2099-12-31')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_task_budget_snapshot	true	task_budget_snapshot_key	Asc
idx_task_budget_snapshot2	true	project_key	Asc
		task_key
		eff_thru_date
idx_task_budget_snapshot1	false	project_key	Asc
idx_task_budget_snapshot3	false	task_key	Asc