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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
