Re: Database design considerations

2008-01-25 Thread John David Anderson (_psychic_)
On Jan 25, 2008, at 3:11 PM, judouk wrote: ///sorry, gmail let me post it first before I'd finished and now that I've had the time to rethink what I was typing, I think I've solved my own problem ! snip CREATE TABLE jobs ( id int(10) not null auto_increment, typeofjob

Database design considerations

2008-01-25 Thread judouk
Hi guys Before I start to create a database structure which I may end up changing, I wanted to run something past you all first. I have a list of jobs to do (JOBS). Each of these jobs may require one or more actions to complete it (ACTION). It would be nice to be able to report on how many