Overview / Tables at a Glance |
Column |
Type |
---|---|
DeviceID |
VARCHAR(20) |
BadgeMACAddr |
VARCHAR(12) |
SerialNo |
VARCHAR(20) |
Label |
VARCHAR(30) |
Type |
VARCHAR(15) |
Color |
VARCHAR(20) |
Owner |
VARCHAR(50) |
Site |
VARCHAR(50) |
TrackingDate |
DATE |
BadgeUsage |
TINYINT(1) |
Notes |
TEXT |
DeviceCode |
INT(5) |
FirmwareVersion |
INT(5) |
LastStatus |
VARCHAR(50) |
LastUser |
VARCHAR(70) |
LasLastLocation |
VARCHAR(50) |
LastAccessed |
TIMESTAMP |
InternalSerialNo |
VARCHAR(20) |