[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