List:General Discussion« Previous MessageNext Message »
From:Rajeev Prasad Date:August 15 2012 6:54pm
Subject:suggestion needed for table design and relationship
View as plain text  
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.
Thread
suggestion needed for table design and relationshipRajeev Prasad15 Aug
  • Re: suggestion needed for table design and relationshipPeter Brawley15 Aug
    • Re: suggestion needed for table design and relationshipRajeev Prasad15 Aug
      • Re: suggestion needed for table design and relationshipPeter Brawley16 Aug