Hi, 2011/2/25 Alex Pilon <alex.pi...@gmail.com>: > 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 >
It's simple Comment: actAs: Signable: created: name: created_by type: integer updated: name: updated_by type: integer Timestampable: columns: user_id: { type: integer(5), notnull: true } microblog_id: { type: integer(5) } blog_id: { type: integer(5) } gallery_id: { type: integer(5) } photo_id: { type: integer(5) } favourite_id: { type: integer(5) } game_id: { type: integer(5) } content: { type: string(65536), notnull: true } publication: { type: boolean, notnull: true, default: 1 } moderated: { type: boolean, notnull: true, default: 0 } visibility: { type: integer(1), notnull: true, default: 0 } indexes: comment_myindex: fields: [user_id, microblog_id, blog_id, gallery_id, photo_id, favourite_id, game_id, publication, moderated, created_at, updated_at] relations: User: class: sfGuardUser local: user_id foreign: id onDelete: CASCADE Microblog: class: Microblog local: microblog_id foreign: id onDelete: CASCADE Blog: class: Blog local: blog_id foreign: id onDelete: CASCADE Gallery: class: Gallery local: gallery_id foreign: id onDelete: CASCADE Photo: class: Photo local: photo_id foreign: id onDelete: CASCADE Favourite: class: Favourite local: favourite_id foreign: id onDelete: CASCADE Game: class: Game local: game_id foreign: id onDelete: CASCADE I'm using fk's, but you can use just table_name and one fk for object id. -- Best regards, Michal http://eventhorizon.pl/ -- 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