Cable, Equipment Database

W Toku Opublikowano Jan 24, 2013 Płatność przy odbiorze
W Toku Płatność przy odbiorze

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.

HTML PHP SQL

Numer ID Projektu: #4171282

O projekcie

7 ofert Zdalny projekt Aktywny Jan 29, 2013