Thanks Chad, Initially I had the same thought to have every type of events in the same table, but due to the nature of all these events are slightly different from each other, and I am planning to store the specific details for each different type of event, so they will need different columns/fields in the table.
For example for event such as conference, i might have special columns/ fields to store information on the speaker and their profile and for event such as seminar/talk, i might have special columns/ fields to store information to see whether the seminar can be offered as inhouse where as event such as motor_show or exhibition, I will not need to store information such as speaker profile and inhouse... Therefore in my database, I will have table for each group of events with similar nature, and a generic 'event' table to hold common columns/fields. Please advise... thanks! Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
