Table: expense_plan

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_plan_key	decimal(15)
2.		project_key	decimal(15)		project	fk_expense_plan1
3.		task_key	decimal(15)		task	fk_expense_plan2
4.		expense_type_key	decimal(15)		expense_type	fk_expense_plan3
5.		description	varchar(50)
6.		begin_date	datetime	('01/01/1900')
7.		end_date	datetime	('12/31/2099')
8.		amount	decimal(18,3)
9.		use_wbs_dates	char(1)	('N')
10.		plan_set_key	decimal(15)		plan_set	fk_expense_plan4
11.		markup	decimal(5,2)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
expense_type_key	expense_type	expense_type_key	fk_expense_plan3
plan_set_key	plan_set	plan_set_key	fk_expense_plan4
project_key	project	project_key	fk_expense_plan1
task_key	task	task_key	fk_expense_plan2

Check Constraints
Name	Definition
cc_ep_date_range	([begin_date]<=[end_date])
cc_ep_use_wbs_dates	([use_wbs_dates]='N' OR [use_wbs_dates]='Y')
cc_expense_plan_begin_date	([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_expense_plan_end_date	([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_expense_plan	true	expense_plan_key	Asc
idx_expense_plan1	true	project_key	Asc
		plan_set_key
		task_key
		expense_type_key
		description
		begin_date
idx_expense_plan2	false	project_key	Asc
idx_expense_plan3	false	task_key	Asc
idx_expense_plan4	false	expense_type_key	Asc
idx_expense_plan5	false	plan_set_key	Asc