Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Slightly Off Topic - mysql, scalability, and splitting ':' strings

by krisahoch (Deacon)
on Sep 05, 2002 at 22:32 UTC ( [id://195527]=note: print w/replies, xml ) Need Help??


in reply to Slightly Off Topic - mysql, scalability, and splitting ':' strings

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

+--------------+ +-------------+ | OWNER | | NODE | +---+----------+ <---+ +---> +---+---------+ |PK | OWNER_id | | | |PK | NODE_id | | | other | | | | | other | +---+----------+ | | +---+---------+ | | +--------------+ | MAILING_LIST | +---+----------+ |FK | OWNER_id | |FK | NODE_id | +---+----------+
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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-03-29 07:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found