In Progress

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.

This project can be done with MySQL/SQL and php/html/asp.

Skills: HTML, PHP, SQL

See more: rack location, sas web, sas front end, global equipment, example of inventory database, closet mobile, sas, sas database, POWER SUPPLY, NIC, global power, equipment, datacenter, closet, cage, cable, cable network, build database sql, php mobile network site, create web based inventory, web based database browser, create sql report, web browser ports, equipment database sql, create access database reports

About the Employer:
( 2 reviews ) Miami, United States

Project ID: #4171282