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_device dev_x | 1234 |1234 |1.2.3.4 |9.8.7.6 |data_specific_to_x |SVC_A,SVC_B,SVC_C... |dev_y,dev_z,dev_n,dev_m... dev_y | 2348 |7734 |10.2.3.4 |99.8.7.6 |data_specific_to_y.....|SVC_B,SVC_X... |dev_x,dev_m... dev_z | 3934 |5634 |11.2.3.4 |79.8.7.6 |data_specific_to_z.....|SVC_M |dev_n,dev_m... ... pl advice. what would be the best design? data_specific_to_device could be more than one column, as i get to explore the data a bit more. and do i really need a device_id field? which any SQL table normally has. ty.
