Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Class::DBI has_many

by kal (Hermit)
on Dec 29, 2003 at 13:32 UTC ( [id://317424]=note: print w/replies, xml ) Need Help??


in reply to Class::DBI has_many

Actually, I think your second step is wrong. You still have a one to many relation - page has many page_columns - but now a one to one relation between page_column and column. I'm sure that's wrong: 1:1 usually indicates the two tables are the same object, and you would amalgamate the tables.

I don't think there is anything wrong with the original 1:N design - are you sure you're not confusing the rule about M:N relations? Then you would have a new entity table (as you have) and two one-to-many relations to the original tables.

I know this isn't answering your question, and I always hate it when monks answer "Your question is wrong, here is the answer". But, I'm fairly sure you don't want the above design, and it not working in Class::DBI easily is a good indicator of that.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://317424]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (4)
As of 2024-04-25 23:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found