You have not designed db? Have you reviewed the referenced tutorial site? Have you looked at other threads on topic of manufacturing db as suggested earlier?
Identify data entities and relationships, build tables or at least a diagram of the structure. This is called an Entity Relationship Diagram. An ERD is a basic tool for planning db.