Thanks for that plug in link and the ideas. 2011/2/26 Grzegorz Śliwiński <fi...@fizyk.net.pl>
> 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 > -- 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