search

habrazilay / NetMapp

Network Mapping Application
MIT License
0 stars 0 forks source link

Create a page "Add advice" #9

Open habrazilay opened 7 years ago

habrazilay commented 7 years ago

id - unique row identifier. cabid - cabinet row identifier where the device is placed. masterid - unique id to easily identify the device by technicians. (Ex. A-0192,B-9813) uLoc - the lowest Unit location of the device inside the cabinet. uHeight - the size of the device in Units. uLenght - the length of the device in Units. (Ex. 0.5 for half U device). name - name to identify the device by the client. typeid - referencing device row identifier of the base database, for more details about the device. powerFeedType - referencing power socket row identifier matching this device.
powerFeedAmount - amount of power sockets availiable for this device. activePorts - indicates how many required to be mapped on this device. (for estimation and status reports) intallationType* - indicates in which way the device installed to the cabin. (ear/rails/shelf) arrivalDate - date of arrival. description - device description.

`id` int PRIMARY KEY AUTO_INCREMENT,
`cabid` int NOT NULL,
FOREIGN KEY (cabid)
    REFERENCES mapping.cabinets(id)
    ON DELETE CASCADE,
`masterid` varchar(20) NOT NULL,
`uLoc` tinyint DEFAULT NULL,
`uHeight` tinyint DEFAULT 1,
`uLenght` DECIMAL(4,3) DEFAULT 1.0,
`name` varchar(50) DEFAULT NULL,
`typeid` int NOT NULL ,
FOREIGN KEY (typeid)
    REFERENCES base.devices(id)
    ON DELETE RESTRICT,
`powerFeedType` int NOT NULL ,
FOREIGN KEY (powerFeedType)
    REFERENCES base.powerSocketAndPlugTypes(id)
    ON DELETE RESTRICT,
`powerFeedAmount` tinyint DEFAULT 1,
`activePorts` smallint DEFAULT NULL,
`installationType` tinyint DEFAULT 0,
`arrivalDate` datetime DEFAULT NULL,
`faceFront` boolean DEFAULT TRUE,
`description` varchar(100) DEFAULT NULL,