Originally Posted by Pat Hartman
I can't make any sense out of table1. Looks like everything to the right of email has a data value as the column name and the values are all empty so I have no idea what they are for.
You started out with a description of the types of data you have. Now try to map the columns to each of the entities you defined.
Field labels to the right of Customer Email are part number designations for individual components.
is looking for the manufacturing order (-MO) we used to build a 6 pin configured connector (140087) for the 60cm product line (60cm).
would be a specific product line. The database I provided was only configured (or set up) to capture one product line (and a few components). My predecessor had just started data capture and had not used these fields yet. The database will have multiple product lines. Each product line will have it's own starting designation, set of component part numbers, and similar data to capture.
The 6 digit number 140087
is the component part number.
Characters after the (-) dash indicate the data type being collected for this part number.
is a manufacturing Order
is the part revision or software version
is is to capture contract data from a bar code scan.
is to capture data from a bar code scan.
is the component serial number.
Those items with a yes/no
data type would be checked off to indicate the item was shipped with the system.
Thus a full 60cm
system may (or may not) require a data capture for each 60cm
part number if the component is shipped as part of the system.
Hopefully this makes sense.
I am finding that as I answer these questions I am readjusting how I think the data structure should be. So thank you for all the prodding.
I have most of the data fields for a second product line defined and entered in Table1. (No data, just field names and data types.) I figure that once I can normalize the data, the effort would just move into a different table. (or so I hope.) I will try to map the entity types to the columns and post in the next day or so. Thank you.