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.
