Your Bookings will belongTo User, Time, Resource - as the foreign id is on the Booking itself. If a Booking "has" a time, then that time will have the booking_id, which is not the case for you.
Also, are your timeslots so flexible/dynamic that they need a database table, or do they follow a fixed business rule (ie only during business hours, chunks of 30 minutes, max of 3 hours)? If the latter, then don't bother with a table, just let each booking store a start_time and end_time, and let your business logic determine how long a booking can be made for. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
