Fields, Relations and their Definitions

1-1-4 SO_status Description:

1. ST_No. 2. Version 3. FEL Order No. 4. FIP?

5. Item_No. 6. Item Issue 7. Cast_No. 8. Cast Letter

(Steel Order Status)

This relation is used to link Steel Order with Forging Definition file through Forging Status file in order to draw information stored in Forging Definition file. It also shows all related FEL Order Numbers to which the Steel Order is related.

Num.String 6, the first identifier in the Steelord. Text 1, the second identifier in the Steelord.

(The composite key o f ST_No. and Version is used as the primary key in Steelord relation.)

Num.String 7, to show how FEL Order No.s are related to the Steel

Orders. It is a foreign key from the Forging Status relation and used to link them together.)

Choice of Yes or No to indicate whether or not the forgings are in progress in this Steel Order.

Num.String 5, the first identifier in the Steelmaking programme relations. Text o f 2, the second identifier in Steelmaking Programme relations. (Item_No. and Item_Issue are used as the composite primary key in the

Steelmaking Programme relations.)

Text o f 5, the first identifier in the Cast Analysis relations. Text of 5, the second identifier in the Cast Analysis relations.

(Cast_No. and Cast_Letter are used as the composite primary key in the Steelmaking Programme relations.)

1-2 Fields in the Relations in the Forging Definition Planning Area 1-2-1 Forging Definition Description: 1. ID No. 2. ID Ver. 3. Works O No. 4. 5. 6. 7. 8. 9. RP? Date_Crd Initial Customer_No. Sales_No. FES 10. Group 11. Description 12. Application 13. Product Cat's 14. Cust. Drawing

Forging Definition file stores common data which can be shared by other relations within the database. It identifies, for each bundle o f FEL Order Numbers, the customer, the specification requirements, the record creation date the order and dispatch date, etc.

Num.String of 5, the first identifier in this relation. The value will never be changed

for all its versions.

Text o f 1, Issue Letter, the second identifier.

(ID_No. and ID_Ver. are used as the composite primary key in the Forging Definition relation.)

Num.String 11, to indicate a certain range o f FEL Order No.(s) related.

(Both Works_0_No. and ID_Ver. can be used as the alternative key to identify a unique record when the Works Order Number is preferable.)

Text of 2, to indicate whether the forgings are replacement or not. Date of the record creation.

Text o f 15, for the initiator's name.

Text o f 8, to identify the customer in the Customer relation. Num.String 8, indicating sales reference number.

Num.String 5, the first identifier in the Specification relation. Text o f 1, the second identifier in the Specification relation.

(FES and Group are the composite primary key in the Specification relation.) Text o f 42, to indicate what the forgings are.

Text o f 27, to indicate the forging's application. Choice o f product category.

Appendix 1 Fields, Relations and their Definitions

15. FEL Draw. No. 16. Customer Order 17. Inspection 18. Other Spec. 19. Comment 20. Date_Ordered 21. Date_Delivery

Text o f 31, to indicate the FEL drawing numbers. Text of 35, to show the customer order number. Text of 39, to show the specified inspection authority.

Text o f 56, to show any specifications, other than that defined by fields 9 and 10. Text o f 68, for comments.

Date, for ordered date. Date, for delivery date. 1-2-2 Specifications

Description: This relation is used to link a chemical range with several set o f mechanical properties. It can also indicate, for each chemical range under certain conditions, what the mechanical properties will be.

1. FES Num.String 5, the first identifier in this relation. 2. Group Text o f 1, the second identifier in this relation.

(FES and Group are the composite primary key.)

3. Approve Choice of Y/N, to indicate whether or not the Spec, has been approved. 4. Initial Text o f 15, name of the person who creates the Spec.

5. Date Date, that the Spec, is created.

6. Spec. Cat's Choice o f Specification categories, to show whether it is a customer Spec., FEL Spec., or international standard Spec., etc.

7. Cond._l Text o f 8, to indicate heat treatment cycle. 8. Cond._2 Text of 8, to indicate forging size or others. 9. Comment Text o f 68, any comments on the Specification. 1-2-3 Chemical Range

Description: This relation is used to store chemical range for up to 22 elements with Max. and Min. values. Fields 2-5 indicate precisely the meaning o f the FES identifier.

1. FES Num.String 5, the unique Spec, code for the sake of brevity to represent the composite attributes {Spec. Source, Spec. Name, Grade, Issue}.

2. Spec. Source Text of 10, to indicate the Spec, sources. 3. Spec. Name Text o f 12, to indicate the Spec, names. 4. Grade Text of 15, to indicate the Spec, grades. 5. Issue Text o f 15, to indicate the Spec, issues. 6. CMin Num.String, minimum content of Carbon. 7. CMax Num.String, maximum content o f Carbon. 8. SiMin Num.String, minimum content of Silicon. 9. SiMax Num.String, maximum content of Silicon. 10. MnMin Num.String, minimum content o f Manganese. 11. MnMax Num.String, maximum content of Manganese. 12. PMin Num.String, minimum content of Phosphorus. 13. PMax Num.String, maximum content of Phosphorous. 14. SMin Num.String, minimum content o f Sulphur. 15. SMax Num.String, maximum content o f Sulphur. 16. CriMin Num.String, minimum content of Chromium. 17. CrMax Num.String, maximum content of Chromium.

18. Other elements (There are 22 other solute elements with Min. and Max. value fields, similar to Carbon or Silicon. 18 elements are named, four are available for definition by the user.)

Appendix 1 Fields, Relations and their Definitions