Skip navigation links

MySQL Forums :: Newbie :: multiple tables with single common column id


Advanced Search

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


Subject Written By Posted
multiple tables with single common column id brad thurston 12/06/2012 11:34AM
Re: multiple tables with single common column id Peter Brawley 12/06/2012 12:23PM


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.