[Dbix-class] Adding an additional custom join parameter
Andrew Beverley
andy at andybev.com
Tue Dec 10 17:42:09 GMT 2013
On Tue, 2013-12-10 at 14:13 +0000, Gavin Rogers wrote:
> > You raise a valid point though, in that this is probably a poor way to
> > design such a database. Maybe I should only have one "site_task" table
> > to link the "sites" and "tasks" tables, and then have appropriate fields
> > within that single table to signify whether the entry is linking the 2
> > tables for reason of an "issue" or a "task".
> >
> > http://files.andybev.com/schema.png
>
> I can't see anything different in this png.
Sorry, I just reposted the same link for context, as it disappeared when
I trimmed the top-posting ;-)
> But I get what you're talking about... I have a very basic example of
> this. In my many_to_many table I have boolean values for PRIMARY_GROUP
> and AFFILIATION_GROUP.
> https://github.com/cessna-cowboy/UserDatabase/blob/master/password_propagation_schema.pdf
[...]
Great, thanks for that, good to see someone else's implementation of
something similar. I'll revisit the design and see what I can come up
with.
Thanks,
Andy
More information about the DBIx-Class
mailing list