deviceinfo

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)