Data Dictionary

Class/Field Name	Data Type	Field Length	Key	Sample
Product
Product_ID	Int	10	PK	10527
Product_Description	Char	256		Solar Panel
Product_Category	Int	10	FK	5
Supplier_ID	Int	10	FK	12
Qty_On_Hand	Int	10		50
ReOrder_QTY	Int	10		30
Product_Category
Category_ID	Int	10	PK	5
Category_Description	Char	256		Solar
Supplier
Supplier_ID	Int	10	PK
Supplier_Name	Char	50		Welch Allyn
Supplier_Address1	Char	50		20155 156th Ave E
Supplier_City	Char	50		Phoenix
Supplier_State	Char	2		AZ
Supplier_Zip	Char	10		85711
Supplier_Country	Char	2		US
Supplier_Phone	Char	15		211-367-2789
Customer
Customer_ID	Int	10	PK
Customer_Name	Char	50		Feemont Hospital
Customer_Address1	Char	50		3691 41st PL
Customer_City	Char	50		Las Angeles
Customer_State	Char	2		CA
Customer_Zip	Char	10		89876
Customer_Country	Char	2		US
Customer_Phone	Char	15		256-567-8907
Invoice
Invoice_ID	Int	10	PK	1901
Customer_ID	Int	10	FK	7
Invoice_Date	Date	10		11/8/2007
Sold_By	Int	10		56789
Invoice Line
Invoice_ID	Int	10	PK	1901
Line_Number	Int	10	PK	1
Product_ID	Int	10	FK	132
QTY_Sold	Int	10		12
Sale_Price	Decimal	10,2		1200.00
Employee
Employee_ID	Int	10	PK	34687
Employee_Last_Name	Char	50		Barnes
Employee_First_Name	Char	50		Fred
Employee_MI	Char	1		G
Employee_Hire_Date	Date	10		2/1/1996
Employee_Job_Title	Char	50		Freight Supervisor
Employee_Salary	Decimal	10,2		55,000
R&D
Document_ID	Int	10	PK	1209
Document_Description				Heat tolerance study
Product_Category			FK	6
R&D Tracking
Document_ID	Int	10	PK	1209
Work_Order_No	Int	10	PK	1123
Employee_ID	Int	10	FK	5478
Begin_Date	Date	10		3/1/2007
End_Date	Date	10		5/1/2007
Total_hours	Decimal	10,2		300