I did some more brainstorming on how I wanted to visually represent a network along with it's address structure. I've incorporated some additional tables into the design to handle a hierarchical network map.
The core of the database schema is still represented by the host, interface, circuit, address,
location, organization, and ianaiftype tables.
The Image table contains references to all pictures of hosts and locations. All other associated tables
reference the images managed by this table.
The WeatherMap group of tables allows a Network Weathermap to be defined for a collection of circuits.
By requesting a certain weathermap, the WeathermapCircuit table provides a list of associated circuits.
The circuit links to interfaces and their respective hosts. By looking for hosts in the HostOnImage table
that reference the same hostid and imageid, a weather map can be automatically drawn with the appropriate
host picture from the HostImage table along with the collected interface statistics.
The HostType table represents names such as 'Router', 'Switch', 'Server', 'Access Point', etc.
Two tables have been added to the Location group of tables. LocationImage represents images of
locations: a building, a floor, a cabinet, a back panel, with each image suggesting a collection of
sub-locations. The LocationOnImage table provides the ability to click on an active area on LocationImage
and drill down to the more specific LocationImage.