Need some work done? Post a Project Today
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.
Additional Project Description:
01/24/2013 at 15:31 EST
This project can be done with MySQL/SQL and php/html/asp.