bogwog — 2011-06-20T13:57:41-04:00 — #1
Can someone please lend expertise to the following? Also, is this called a one-to-one relationship?
I have a table containing name and id of a wireless access point. Each access point has two or three radios. Each radio has ten separate items requiring unique configuration details. I would like to do this:
radio1 (value of rc_id below)
radio2 (value of rc_id below)
radio3 (value of rc_id below)
I feel doing this would be better than having the accessPoint table containing 30 different fields.
My question is, what is the best method for tying the two tables together?
Thanks in advance.
spacephoenix — 2011-06-20T14:34:25-04:00 — #2
Add a 3rd "linking" table with 2 fields ap_id and rc_id each row would record 1 radio and access point combination.
bogwog — 2011-06-20T16:03:41-04:00 — #3
okay, thanks for the reply.
then I would have this:
What type of query would I write to obtain:
all access points with 'config_item1' = 'x'