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:
dev_x | 1234
|1234 |220.127.116.11 |18.104.22.168
dev_y | 2348
|7734 |10.2.3.4 |22.214.171.124
dev_z | 3934
|5634 |126.96.36.199 |188.8.131.52
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.