Cable, Equipment Database

IN PROGRESS
Bids
7
Avg Bid (USD)
$536
Project Budget (USD)
$250 - $750

Project Description:
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.

Skills required:
HTML, PHP, SQL
Hire carlosmp
Project posted by:
carlosmp United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.