Cable, Equipment Database

Looking to build a database for cables. The lowest item here is the cable. Each cable is a type with each end having a connector type. Each cable needs to have Type, Connector A, Connector B, Color, Length, ID. Each cable will connect two ports. The two ports will generally be a Type (network, serial, power) will belong to equipment. Equipment will have many ports, and belong to a location. Equipment also needs a label for each port, so we can say Front Serial port, Power Supply 1, MB NIC 1, PCI SAS Port 0, PCI Infiniband, etc. Each location will belong to a location or Customer. Multiple levels of locations is necessary. Client A (Client) Client A Site 1 Main Telco Closet (Location) Client A Site 2 (Location) West Access Closet (Location) Client B (Client) Client A Site 1 Server Room (Location) Client C (Client) DataCenter 1 (Location) Floor 6 (Location) Cage 203 (Location) Rack 01 (Location) Will need reports to allow removal of Customer/Site/Equipment and list report of cables that will be removed, and where the other ends are. An option to return these cables into inventory at Customer/Site will be necessary, or the option to move cable inventory to global inventory. If we add an equipment, will need the ability to create multiple ports quickly. For example, a 48 port switch will have 44 copper ports, 4 combo ports, 1 power port, 1 serial port. Should be web based to allow access from any browser, including mobile.