'MATERIAL' Table

The ‘Material’ table in the database stores all required information regarding the material used for the manufacturing of the products. It is tied to the ‘Products’ table of the database using the foreign key ‘Material_ID’. This relation would be used to verify the availability of material required to produce the ordered quantity of a particular product. Other fields in the table would provide the information required to make the ‘manufacturability’ decision. The field definitions and their intended use is shown in the above figure.

The rationale behind adding fields regarding quantities (available and allocated), ordered date, consignment date, supplier information is that this table can then provide a suitable data structure necessary to link an ‘optimizer’ (scheduler, MRP,...), to the existing framework. Web-based manufacturing principles can also be experimented using the new database structure.

 

 

 

 

 

 

The Harold & Inge Marcus Department of
Industrial & Manufacturing Engineering
310 Leonhard Building
University Park, PA 16802