Well why not just haven non-members in the members table, and simple have a column that flags them as a guest?
On Sep 8, 11:23 am, brian <[email protected]> wrote: > I'm building a site for an industry organisation and have a tricky (I > think) architecture problem. There's a table for members, with first & > last name, email, password, etc. The org has meetings--usually > annually--for which anyone can attend. However, there is a charge for > attendance, and all attendees must be recorded. Because there may be > both members and non-members, I thought that the simplest solution > would be to create a non_members table, which has many of the same > columns as members. I'm not really keen on doing any sub-classing > here. > > Anyway, so, if I have members, non_members, and meetings tables, I > figure that I can then create a meetings_attendees table. Basically, > the attendee can be either a member or a non_member. Should I go with > a schema like this? > > meeting_id > member_id > non_member_id > > This seems like a kludge, at best (if not broken). Can anyone suggest > a better approach? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
