Michal's idea is one way, although personally wouldn't add that many fk's into Comment model. Each new model that will get commented, will result in modifying Comment table. If it'll grow up, ALTER TABLE might take long time. Second idea is to create association tables for each commented model (i'd prefer that), - Each new model will result ony in new association table, without the need to alter comment table Third idea is used in vjCommentPlugin: http://www.symfony-project.org/plugins/vjCommentPlugin There are no foreign keys, instead there is field which indicates commented object's model, and it's id.
On 25 Lut, 16:51, Alex Pilon <alex.pi...@gmail.com> wrote: > Hello Everyone, > > I have a schema in which I have several entities, lets call them Shows, > Broadcasters and Pitches. > > A Show is essentially pitched to a Broadcaster which creates the Pitch which > is an entity that sits between Show and Broadcaster and creates a many to > many relationship. > > This is all fine and good, however there is a Note model which is meant to > be attached to Show and Broadcaster (and potentially Pitch in the future). > > It seems to me that this sort of multi use comments table won't work quite > right unless Show and Broadcaster have a common primary key, as there > wouldn't be anyway to guarentee unique ids between the Show and Broadcaster > and therefore Note would have an invalid foreign key. > > The idea I had to solve this was to create an entity table in which the > other Models inherit from, but the types of inheritance don't seem to solve > this problem, as simple puts everything in one table, which is rather > undesirable, and concrete doesn't seem to allow shared ids with a base > table. > > Anyone ever have a similar set up? > > -- > Alex Pilon > (613) 608-1480 -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
