Re: Class::DBI has_a() relationships with multi-value keys

As noted, this is not supported. As a side note, albeit an unhelpful one, it should be pointed out that databases in third normal form with tables having simple (single column) primary keys, are automatically in fifth normal form. You can read the proof, if you like. Everyone who is serious about database design should read this paper.

How this applies to your work is obvious: with simple primary keys, your problem is solved. Of course, this also makes updating and deleting data a snap. It also simplifies lookup tables tremendously. I wish more DBAs knew about this.

Cheers,
Ovid

New address of my CGI Course.

Comment on Re: Class::DBI has_a() relationships with multi-value keys

Replies are listed 'Best First'.
Re^2: Class::DBI has_a() relationships with multi-value keys by MrCromeDome (Deacon) on Oct 29, 2004 at 21:15 UTC
Would have been nice for us to have read this say, oh, 8 years ago when we started all this ;) Changing our primary and foreign key columns at this point would be a ghastly thought, especially because we're just trying to throw some web-based lookups on top of our database. That being said, it is something we hope to address with the next version of our apps, whenever that may come to pass. We already have some ideas going though. Thanks for the link and the response. That was an excellent, informative read! MrCromeDome	[reply]

Replies are listed 'Best First'.

Re^2: Class::DBI has_a() relationships with multi-value keys
by MrCromeDome (Deacon) on Oct 29, 2004 at 21:15 UTC

That being said, it is something we hope to address with the next version of our apps, whenever that may come to pass. We already have some ideas going though.

Thanks for the link and the response. That was an excellent, informative read!

MrCromeDome

[reply]