Equipment to do data collection, there are dozens of devices, each device has a unique serial number, each one device can do a lot of kinds, may also have multiple devices to do the same, a single entity information including equipment to collect, run time, failure time, yield, production count, and so on (10 sets of data). Information data and the data on the equipment these entities a reset once the class meeting, so the database must accumulate processing to do! How do data table design!

CodePudding user response:

In a few tables:
Equipment list, product list, work order table, production data table
Production data table basic fields:
Automatic ID, device ID, order ID, frequency, time, number of production, if you want to collect the production parameters of each product, each product a record, if there is no article records the parameters of a product is to replace each increased a record, the production of a product update quantity or number of products update database