Hi, I'm having a problem with my database design. I'm creating a nightlife listings site and there are a few tables that rely on FK constraints.
The most important is the 'listings' table, which stores events that can be viewed from a calendar. The listing can be of a few types e.g. an event at a night club, a gig, a special event at a bar etc... There are tables that hold data about the place that is hosting the event e.g. there are 'clubs' 'bars' and gigs' tables. So, each listing needs a parent in one of these tables, and that's where I'm getting confused. If I give each parent a FK in the listing table there will be problems leaving fields blank, and all listings will only have one parent. I know I could break it up into a separate listings table for each type but I'd like to be able to add types with out having to make a new table each time. Also, with cake how do you name the fields in a link table? Just a bit confused there too. Any advice would be much appreciated. Cheers TWIOF Foreign --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
