Problems? Is your data what you think it is? | |
PerlMonks |
Re: Slightly Off Topic - mysql, scalability, and splitting ':' stringsby krisahoch (Deacon) |
on Sep 05, 2002 at 22:32 UTC ( [id://195527]=note: print w/replies, xml ) | Need Help?? |
I think that you may want to use a join table. If both your 'OWNER', and 'NODE' entities have a primary key (unique number), then creating a join table that has a foreign key for each table would create a unique join table. A NODE could be associated with any number of OWNERS and an OWNER can have any number of NODES Join tables work great for associating data from one table with data from another. Updated: Oops. misnamed an element. Updated: Forgot to name the join table:\ HTH - Kristofer
In Section
Seekers of Perl Wisdom
|
|