|
|
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 |
|
|
|
|