prodcalc database table

prodcalc

Column List

Name	Code	Type	M
Product ID	product_id	char(20)	Yes
Standard Duration	std_duration	float	No
Standard Duration Forced	std_duration_forced	tinyint	No
Modified Duration	mod_duration	float	No
Modified Duration Forced	mod_duration_forced	tinyint	No
Basis Point Value	basis_point_value	float	No
Basis Point Value Forced	basis_point_value_forced	tinyint	No
Average Life	average_life	float	No
Average Life Forced	average_life_forced	tinyint	No
Yield to Maturity	yield_maturity	float	No
Yield to Maturity Forced	yield_maturity_forced	tinyint	No
Yield to Call	yield_call	float	No
Yield to Call Forced	yield_call_forced	tinyint	No
Yield to Worst	yield_worst	float	No
Yield to Worst Forced	yield_worst_forced	tinyint	No
Years Worst	years_worst	float	No
Effective Mat Date	effective_mat_date	datetime	No
Years Worst Forced	years_worst_forced	tinyint	No
Effective Mat Date Forced	effective_mat_date_forced	tinyint	No

Index List

Index Code	P	F	A	U	C	Sort
pk_prodcalc	Yes	Yes	No	Yes	No	ASC

Reference to List

Primary Key	Reference to	Foreign Key
product_id	product	product_id