suggestion needed for table design and relationship

2012-08-15 Thread Rajeev Prasad
I have to keep this data in MySql, and i am not sure (as SQL/databse is not my field) how to organise this into one or many tables? right now I would represent my info as follows: device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specific_to_device|associated_service  

Re: suggestion needed for table design and relationship

2012-08-15 Thread Peter Brawley
On 2012-08-15 1:54 PM, Rajeev Prasad wrote: I have to keep this data in MySql, and i am not sure (as SQL/databse is not my field) how to organise this into one or many tables? right now I would represent my info as follows:

Re: suggestion needed for table design and relationship

2012-08-15 Thread Rajeev Prasad
thx in advance. Rajeev From: Peter Brawley peter.braw...@earthlink.net To: Rajeev Prasad rp.ne...@yahoo.com; mysql@lists.mysql.com mysql@lists.mysql.com Sent: Wednesday, August 15, 2012 4:01 PM Subject: Re: suggestion needed for table design and relationship

Re: suggestion needed for table design and relationship

2012-08-15 Thread Peter Brawley
, 2012 4:01 PM Subject: Re: suggestion needed for table design and relationship On 2012-08-15 1:54 PM, Rajeev Prasad wrote: I have to keep this data in MySql, and i am not sure (as SQL/databse is not my field) how to organise this into one or many tables? right now I would represent my info