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 actions I have had to use within a specific period so I was thinking of separating them into different tables. Then I realised how much of a problem this could potentially be. How would you recommend designing this layout? Most of the time, the values will simply be true/false but, for some of the actions, I may need to record a comment - such as who performed this action. I know I could do it all in one table but that seems very wasteful of space. CREATE TABLE Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
