Hi, I'm new to the list and ask you for design advice. I'm working on a
Catalyst project, trying to preserve old code if possible, so this is my
idea:
What I call "multi-related table" is something like having a table Href
that could be addressed by different tables:
Text->has_many(links, Href);
Bookmark->has_many(links, Href);
Author->has_one(homepage, Href);
I tried different geometries but it seem to be impossible to succesfully
create all the inverse relashionships simultaneously:
Href->belongs_to(Text);
Href->belongs_to(Bookmark);
Href->belongs_to(Author);
Maybe I'm looking for something like might_belong_to, which doesn't
exists, maybe it's just bad design. As a matter of fact, Href knows
nothing about which objects its foreign keys come from, so probably
those inverse relationships are be pointless anyway. Is it ok to go on
without'em?
Thanks,
Silvio Almeida
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]