Re: suggestion needed for table design and relationship

2012-08-15 Thread Peter Brawley
On 2012-08-15 5:27 PM, Rajeev Prasad wrote: hello Peter, data_specific_to_device = contains diff values, and is different for different devices associated_service = will also be a list of values which will be different for different devices and same for associated_device column. this data ra

Re: suggestion needed for table design and relationship

2012-08-15 Thread Rajeev Prasad
hello Peter, data_specific_to_device = contains diff values, and is different for different devices associated_service = will also be a list of values which will be different for different devices and same for associated_device column. this data rarely(almost never) changes and add happens onl

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: device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specifi

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   |associated_