Table for storing device information
| `DEVICES` | |
|---|---|
| `UID` int(10) unsigned NOT NULL auto_increment | PRIMARY KEY |
| `COMPANY` varchar(100) NOT NULL | |
| `PASSWORD` varchar(20) NOT NULL | Not Used |
| `DEVICEID` varchar(100) NOT NULL | |
| `ICON` varchar(100) NOT NULL | |
| `X` float NOT NULL | |
| `Y` float NOT NULL | |
| `POINTSTODAY` int(11) NOT NULL default '0' | |
| `VER` char(50) NOT NULL | Software Version |
| `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP | Server Timestamp |
| `HASMESSAGE` smallint(6) NOT NULL default '0' | |
| `USER` varchar(50) NOT NULL | |
| `POINTSTOTAL` int(11) NOT NULL default '0' | |
| `USERS_UID` int(11) NOT NULL | |
| `LASTEVENT_UID` int(11) NOT NULL | |
| `TEAM` varchar(50) NOT NULL | |
| `DATESTAMP` datetime NOT NULL | Sent by Device |
Tracking data for each device
| `DEVICELOCATIONS` | |
|---|---|
| `UID` int(11) NOT NULL auto_increment | |
| `DEVICES_UID` int(11) NOT NULL | |
| `USER` varchar(100) NOT NULL | |
| `X` float NOT NULL | |
| `Y` float NOT NULL | |
| `Z` float NOT NULL | |
| `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP | Server Timestamp |
| `TEAM` varchar(50) NOT NULL | |
| `USERS_UID` int(11) NOT NULL | |
| `DATESTAMP` datetime NOT NULL | Sent by Device |
Each stored event gets an entry here
| `FMW_EVENTS` | |
|---|---|
| `UID` int(11) NOT NULL auto_increment | PRIMARY KEY |
| `DEVICES_UID` int(11) NOT NULL | LINK TO DEVICES TABLE |
| `USER` varchar(100) NOT NULL | |
| `X` float NOT NULL | |
| `Y` float NOT NULL | |
| `Z` float NOT NULL | |
| `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP | |
| `TYPE` varchar(50) NOT NULL | |
| `CLASS` varchar(50) NOT NULL | |
| `ICON` varchar(20) default NULL | |
| `JOBNAME` varchar(50) NOT NULL | |
| `USERS_UID` int(11) NOT NULL | |
| `TEAM` varchar(50) NOT NULL | |
| `STATUS` varchar(50) NOT NULL | |
| `DATESTAMP` datetime NOT NULL | |
| `FOID` varchar(50) NOT NULL | |
| `DEVICEID` varchar(50) NOT NULL | |
General storage for unknown items in parameter list
| `EVENTDATA` | |
|---|---|
| `UID` int(11) NOT NULL auto_increment | PRIMARY KEY |
| `EVENT_UID` int(11) NOT NULL | LINK TO EVENTS TABLE |
| `NAME` varchar(20) NOT NULL | |
| `VALUE` varchar(200) NOT NULL | |
Messages to/from device
| `FMW_MESSAGES` | |
|---|---|
| `UID` int(10) NOT NULL auto_increment | PRIMARY KEY |
| `DEVICES_UID` int(10) NOT NULL | LINK TO DEVICES TABLE |
| `DATECREATED` timestamp NOT NULL default CURRENT_TIMESTAMP | |
| `DATESENT` timestamp NOT NULL default '0000-00-00 00:00:00' | |
| `SENT` tinyint(1) NOT NULL | |
| `MESSAGE` varchar(255) NOT NULL | |
| `LATLONG` varchar(50) NOT NULL | |
| `ADDRESS` varchar(500) NOT NULL | |
| `FOID` char(20) NOT NULL | |
| `CLASS` varchar(50) NOT NULL | |
| `TYPE` varchar(50) NOT NULL | |
| `STATUS` varchar(50) NOT NULL | |
| `FROM_DEVICEID` varchar(50) NOT NULL | |
User information
| `FMW_USERS` | |
|---|---|
| `UID` int(11) NOT NULL auto_increment | PRIMARY KEY |
| `NAME` varchar(50) NOT NULL | |
| `MOBILE` varchar(50) NOT NULL | |
| `PHOTO` varchar(50) NOT NULL | |
| `LOOKUPNAME` varchar(50) NOT NULL | |
| `COMPANY` varchar(100) NOT NULL | |