MySQL Forums
Forum List  »  Newbie

multiple tables with single common column id
Posted by: brad thurston
Date: December 06, 2012 11:34AM

Hello all, obviously a sql noob here. I am trying to learn sql and have a question about my first database and tables within. Currently my db contains 4 tables; tools, materials, personelreq, and references . Each table starts off with a common column "WP' which corresponds to the workpacket number. The tables have up to 50 columns a piece and approx 4k rows. First off, im not even sure if this is the correct/proper way to design such a database.

Can someone relate some insight on this design and issues i may encounter. Most queries would be to gather the tools,materials,personel,and or references associated with a particualar work packet.

Options: ReplyQuote

Written By
multiple tables with single common column id
December 06, 2012 11:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.