fantomel Posted September 26, 2011 Share Posted September 26, 2011 Hello can someone help me please with a database design for network topology? i need to store a list of network terminals and for the data center ( including computer specifications ) and i'm not sure how to do it never did something like this. any ideeas, advices or models are welcomed thank you for your help. Link to comment https://forums.phpfreaks.com/topic/247877-database-design/ Share on other sites More sharing options...
SparK_BR Posted September 26, 2011 Share Posted September 26, 2011 hmm... it's a single table "computers" I guess, then you store the name and specs and type (server, client, terminal, etc...) not sure what use that would have but I guess that's it Link to comment https://forums.phpfreaks.com/topic/247877-database-design/#findComment-1272832 Share on other sites More sharing options...
fantomel Posted September 26, 2011 Author Share Posted September 26, 2011 hmm... it's a single table "computers" I guess, then you store the name and specs and type (server, client, terminal, etc...) not sure what use that would have but I guess that's it yes.. i'm thinking the same way but still .. before i go for this design i`m looking for more ideeas / options.. see how it fits better. was thinking separating in two tables end user computer and one table for the data center split in two 1 for nodes and 1 for main computer/s Link to comment https://forums.phpfreaks.com/topic/247877-database-design/#findComment-1272835 Share on other sites More sharing options...
jpcicero Posted October 12, 2011 Share Posted October 12, 2011 What about to have the following tables. device (PC,Router,etc) device_type (descriptive table) device_network (how devices are linked ) device_spec I should use a device_spec table (device specification, where all specific properties are stored for each device). For instance, device_spec_id | device_id | attribute | value 1 | 1 | ip address | 168.... 1 | 1 | location | server room Using the device_type you now witch attributes belongs to each device. But I not very sure about what is the problem you are trying so solve. Hope to help you. Link to comment https://forums.phpfreaks.com/topic/247877-database-design/#findComment-1278771 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.