Version: 2.4.7
================================================================================================
This document contains database schema information for the tables defined within the OpenGTS
system.  Optional tables (if any) will be indicated by the term "[optional]" next to the table
name.

Additional information may be obtained by examining the source module for the specified class.

The schema listing below should match the installed configuration, however, there may still be
minor differences depending on the specific version installed, or changes that have been made
to the configuration.  The current schema configuration can be generated from the actual
database configuration by executing the following command:
(executed from within the OpenGTS directory)

   bin/dbAdmin.pl -schema

Or, on Windows:

   bin\dbConfig.bat -schema


================================================================================================
Table: Account [required]
Class: org.opengts.db.tables.Account

This table defines the top level Account specific information.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 accountType            Account Type                   SMALLINT UNSIGNED                    
   3 notifyEmail            Notification EMail Address     VARCHAR(128)                         
   4 speedUnits             Speed Units                    TINYINT UNSIGNED                     
   5 distanceUnits          Distance Units                 TINYINT UNSIGNED                     
   6 volumeUnits            Volume Units                   TINYINT UNSIGNED                     
   7 pressureUnits          Pressure Units                 TINYINT UNSIGNED                     
   8 economyUnits           Economy Units                  TINYINT UNSIGNED                     
   9 temperatureUnits       Temperature Units              TINYINT UNSIGNED                     
  10 latLonFormat           Latitude/Longitude Format      TINYINT UNSIGNED                     
  11 geocoderMode           Geocoder Mode                  TINYINT UNSIGNED                     
  12 privateLabelName       PrivateLabel Name              VARCHAR(32)                          
  13 isBorderCrossing       Is BorderCrossing Enabled      TINYINT                              
  14 retainedEventAge       Retained Event Age (sec)       INT UNSIGNED                         
  15 maximumDevices         Maximum number of devices      INT                                  
  16 totalPingCount         Total 'Ping' Count             SMALLINT UNSIGNED                    
  17 maxPingCount           Maximum 'Ping' Count           SMALLINT UNSIGNED                    
  18 autoAddDevices         AutoAdd Devices                TINYINT                              
  19 dcsPropertiesID        DCS Properties ID              VARCHAR(32)                          
  20 smsEnabled             SMS Enabled                    TINYINT                              
  21 smsProperties          SMS Properties                 VARCHAR(200)                         
  22 emailProperties        EMail Properties               VARCHAR(250)                         
  23 expirationTime         Expiration Time                INT UNSIGNED                         
  24 defaultUser            Default User ID                VARCHAR(32)                          
  25 password               Password                       VARCHAR(32)                          
  26 contactName            Contact Name                   VARCHAR(64) [utf8]                   
  27 contactPhone           Contact Phone                  VARCHAR(32)                          
  28 contactEmail           Contact EMail Address          VARCHAR(128)                 email   
  29 timeZone               Time Zone                      VARCHAR(32)                          
  30 passwdChangeTime       Last Password Change Time      INT UNSIGNED                         
  31 passwdQueryTime        Last Password Query Time       INT UNSIGNED                         
  32 lastLoginTime          Last Login Time                INT UNSIGNED                         
  33 isActive               Is Active                      TINYINT                              
  34 displayName            Display Name                   VARCHAR(40) [utf8]                   
  35 description            Description                    VARCHAR(128) [utf8]                  
  36 notes                  Notes                          TEXT [utf8]                          
  37 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  38 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: AccountString [required]
Class: org.opengts.db.tables.AccountString

This table defines Account specific customized String key/values.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 stringID               String ID                      VARCHAR(32)                  PRIMARY 
   3 singularTitle          Singular Title                 VARCHAR(64)                          
   4 pluralTitle            Plural Title                   VARCHAR(64)                          
   5 description            Description                    VARCHAR(128) [utf8]                  
   6 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   7 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: User [required]
Class: org.opengts.db.tables.User

This table defines Account specific Users.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 userID                 User ID                        VARCHAR(32)                  PRIMARY 
   3 userType               User Type                      SMALLINT UNSIGNED                    
   4 roleID                 User Role                      VARCHAR(32)                  role    
   5 password               Password                       VARCHAR(32)                          
   6 gender                 Gender                         TINYINT UNSIGNED                     
   7 notifyEmail            Notification EMail Address     VARCHAR(128)                         
   8 contactName            Contact Name                   VARCHAR(64) [utf8]                   
   9 contactPhone           Contact Phone                  VARCHAR(32)                          
  10 contactEmail           Contact EMail Address          VARCHAR(64)                  email   
  11 timeZone               Time Zone                      VARCHAR(32)                          
  12 firstLoginPageID       First Login Page ID            VARCHAR(24)                          
  13 preferredDeviceID      Preferred Device ID            VARCHAR(32)                          
  14 maxAccessLevel         Maximum Access Level           SMALLINT UNSIGNED                    
  15 passwdChangeTime       Last Password Change Time      INT UNSIGNED                         
  16 passwdQueryTime        Last Password Query Time       INT UNSIGNED                         
  17 lastLoginTime          Last Login Time                INT UNSIGNED                         
  18 isActive               Is Active                      TINYINT                              
  19 displayName            Display Name                   VARCHAR(40) [utf8]                   
  20 description            Description                    VARCHAR(128) [utf8]                  
  21 notes                  Notes                          TEXT [utf8]                          
  22 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  23 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: UserAcl [required]
Class: org.opengts.db.tables.UserAcl

This table defines User specific Access Control permissions.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 userID                 User ID                        VARCHAR(32)                  PRIMARY 
   3 aclID                  ACL ID                         VARCHAR(64)                  PRIMARY 
   4 accessLevel            Access Level                   SMALLINT UNSIGNED                    
   5 description            Description                    VARCHAR(128) [utf8]                  
   6 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   7 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: GroupList [required]
Class: org.opengts.db.tables.GroupList

This table defines the authorized Groups that can be accessed by a given User.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 userID                 User ID                        VARCHAR(32)                  PRIMARY 
   3 groupID                Device Group ID                VARCHAR(32)                  PRIMARY 
   4 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: Device [required]
Class: org.opengts.db.tables.Device

This table defines Device/Vehicle specific information for an Account. A 'Device' record
typically represents something that is being 'tracked', such as a Vehicle.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 groupID                Group ID                       VARCHAR(32)                          
   4 equipmentType          Equipment Type                 VARCHAR(40)                          
   5 vehicleID              VIN                            VARCHAR(24)                          
   6 licensePlate           License Plate                  VARCHAR(24)                          
   7 driverID               Driver ID                      VARCHAR(32)                          
   8 fuelCapacity           Fuel Capacity                  DOUBLE                               
   9 fuelEconomy            Approx. Fuel Economy           DOUBLE                               
  10 speedLimitKPH          Max Speed km/h                 DOUBLE                               
  11 planDistanceKM         Planned Trip Distance          DOUBLE                               
  12 expirationTime         Expiration Time                INT UNSIGNED                         
  13 uniqueID               Unique ID                      VARCHAR(40)                  altIndex
  14 deviceCode             Server ID                      VARCHAR(24)                          
  15 deviceType             Device Type                    VARCHAR(24)                          
  16 pushpinID              Pushpin ID                     VARCHAR(32)                          
  17 displayColor           Display Color                  VARCHAR(16)                          
  18 serialNumber           Serial Number                  VARCHAR(24)                          
  19 simPhoneNumber         SIM Phone Number               VARCHAR(24)                          
  20 simID                  SIM ID                         VARCHAR(24)                          
  21 smsEmail               SMS EMail Address              VARCHAR(64)                          
  22 imeiNumber             IMEI Number                    VARCHAR(24)                          
  23 dataKey                Data Key                       TEXT                                 
  24 ignitionIndex          Ignition I/O Index             SMALLINT                             
  25 codeVersion            Code Version                   VARCHAR(32)                          
  26 featureSet             Feature Set                    VARCHAR(64)                          
  27 ipAddressValid         Valid IP Addresses             VARCHAR(128)                         
  28 lastTotalConnectTime   Last Total Connect Time        INT UNSIGNED                         
  29 lastDuplexConnectTime  Last Duplex Connect Time       INT UNSIGNED                         
  30 pendingPingCommand     Pending Ping Command           TEXT                                 
  31 lastPingTime           Last 'Ping' Time               INT UNSIGNED                         
  32 totalPingCount         Total 'Ping' Count             SMALLINT UNSIGNED                    
  33 maxPingCount           Maximum 'Ping' Count           SMALLINT UNSIGNED                    
  34 expectAck              Expecting an ACK               TINYINT                              
  35 expectAckCode          Expected ACK Status Code       INT UNSIGNED                         
  36 lastAckCommand         Last Command Expecting ACK     TEXT                                 
  37 lastAckTime            Last Received 'ACK' Time       INT UNSIGNED                         
  38 dcsPropertiesID        DCS Properties ID              VARCHAR(32)                          
  39 dcsCommandHost         DCS Command Host               VARCHAR(32)                          
  40 dcsConfigMask          DCS Configuration Mask         INT UNSIGNED                         
  41 supportsDMTP           Supports DMTP                  TINYINT                              
  42 supportedEncodings     Supported Encodings            TINYINT UNSIGNED                     
  43 unitLimitInterval      Accounting Time Interval Min   SMALLINT UNSIGNED                    
  44 maxAllowedEvents       Max Events per Interval        SMALLINT UNSIGNED                    
  45 totalProfileMask       Total Profile Mask             BLOB                                 
  46 totalMaxConn           Max Total Conn per Interval    SMALLINT UNSIGNED                    
  47 totalMaxConnPerMin     Max Total Conn per Minute      SMALLINT UNSIGNED                    
  48 duplexProfileMask      Duplex Profile Mask            BLOB                                 
  49 duplexMaxConn          Max Duplex Conn per Interval   SMALLINT UNSIGNED                    
  50 duplexMaxConnPerMin    Max Duplex Conn per Minute     SMALLINT UNSIGNED                    
  51 lastTcpSessionID       Last TCP Session ID            VARCHAR(32)                          
  52 ipAddressCurrent       Current IP Address             VARCHAR(32)                          
  53 remotePortCurrent      Current Remote Port            SMALLINT UNSIGNED                    
  54 listenPortCurrent      Current Listen Port            SMALLINT UNSIGNED                    
  55 lastInputState         Last Input State               INT UNSIGNED                         
  56 lastBatteryLevel       Last Battery Level             DOUBLE                               
  57 lastFuelLevel          Last Fuel Level                DOUBLE                               
  58 lastFuelTotal          Last Fuel Total Liters         DOUBLE                               
  59 lastOilLevel           Last Oil Level                 DOUBLE                               
  60 lastValidLatitude      Last Valid Latitude            DOUBLE                               
  61 lastValidLongitude     Last Valid Longitude           DOUBLE                               
  62 lastValidHeading       Last Valid Heading             DOUBLE                               
  63 lastGPSTimestamp       Last Valid GPS Timestamp       INT UNSIGNED                         
  64 lastEventTimestamp     Last Event Timestamp           INT UNSIGNED                         
  65 lastCellServingInfo    Last Serving Cell Info         VARCHAR(100)                         
  66 lastOdometerKM         Last Odometer km               DOUBLE                               
  67 odometerOffsetKM       Odometer Offset km             DOUBLE                               
  68 lastEngineHours        Last Engine Hours              DOUBLE                               
  69 engineHoursOffset      Engine Hours Offset            DOUBLE                               
  70 lastIgnitionOnTime     Last Ignition On Time          INT UNSIGNED                         
  71 lastIgnitionOffTime    Last Ignition Off Time         INT UNSIGNED                         
  72 lastIgnitionHours      Last Ignition Hours            DOUBLE                               
  73 lastStopTime           Last Stop  Time                INT UNSIGNED                         
  74 lastStartTime          Last Start Time                INT UNSIGNED                         
  75 lastMalfunctionLamp    Last MIL                       TINYINT                              
  76 lastFaultCode          Last Fault Code                VARCHAR(96)                          
  77 isActive               Is Active                      TINYINT                              
  78 displayName            Display Name                   VARCHAR(40) [utf8]                   
  79 description            Description                    VARCHAR(128) [utf8]                  
  80 notes                  Notes                          TEXT [utf8]                          
  81 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  82 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: Transport [required]
Class: org.opengts.db.tables.Transport

This table defines the data transport specific information for an Asset/Device.  A 'Transport'
represents the datapath used to send data to a server.  In some cases a single 'Device' can
have more than one such datapath to the server, such as a device that incorporates both GPRS
and satellite communications.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 transportID            Transport ID                   VARCHAR(32)                  PRIMARY 
   3 assocAccountID         Associated Account ID          VARCHAR(32)                  device  
   4 assocDeviceID          Associated Device ID           VARCHAR(32)                  device  
   5 uniqueID               Unique ID                      VARCHAR(40)                  altIndex
   6 deviceCode             Device Code                    VARCHAR(24)                          
   7 deviceType             Device Type                    VARCHAR(24)                          
   8 serialNumber           Serial Number                  VARCHAR(24)                          
   9 simPhoneNumber         SIM Phone Number               VARCHAR(24)                          
  10 smsEmail               SMS EMail Address              VARCHAR(64)                          
  11 imeiNumber             IMEI Number                    VARCHAR(24)                          
  12 lastInputState         Last Input State               INT UNSIGNED                         
  13 ignitionIndex          Ignition I/O Index             SMALLINT UNSIGNED                    
  14 codeVersion            Code Version                   VARCHAR(32)                          
  15 featureSet             Feature Set                    VARCHAR(64)                          
  16 ipAddressValid         Valid IP Addresses             VARCHAR(128)                         
  17 ipAddressCurrent       Current IP Address             VARCHAR(32)                          
  18 remotePortCurrent      Current Remote Port            SMALLINT UNSIGNED                    
  19 listenPortCurrent      Current Listen Port            SMALLINT UNSIGNED                    
  20 pendingPingCommand     Pending Ping Command           TEXT                                 
  21 lastPingTime           Last 'Ping' Time               INT UNSIGNED                         
  22 totalPingCount         Total 'Ping' Count             SMALLINT UNSIGNED                    
  23 maxPingCount           Maximum 'Ping' Count           SMALLINT UNSIGNED                    
  24 expectAck              Expecting an ACK               TINYINT                              
  25 lastAckCommand         Last Command Expecting an ACK  TEXT                                 
  26 lastAckTime            Last Received 'ACK' Time       INT UNSIGNED                         
  27 supportsDMTP           Supports DMTP                  TINYINT                              
  28 supportedEncodings     Supported Encodings            TINYINT UNSIGNED                     
  29 unitLimitInterval      Accounting Time Interval Min   SMALLINT UNSIGNED                    
  30 maxAllowedEvents       Max Events per Interval        SMALLINT UNSIGNED                    
  31 totalProfileMask       Total Profile Mask             BLOB                                 
  32 totalMaxConn           Max Total Conn per Interval    SMALLINT UNSIGNED                    
  33 totalMaxConnPerMin     Max Total Conn per Minute      SMALLINT UNSIGNED                    
  34 duplexProfileMask      Duplex Profile Mask            BLOB                                 
  35 duplexMaxConn          Max Duplex Conn per Interval   SMALLINT UNSIGNED                    
  36 duplexMaxConnPerMin    Max Duplex Conn per Minute     SMALLINT UNSIGNED                    
  37 lastTotalConnectTime   Last Total Connect Time        INT UNSIGNED                         
  38 lastDuplexConnectTime  Last Duplex Connect Time       INT UNSIGNED                         
  39 displayName            Display Name                   VARCHAR(40) [utf8]                   
  40 description            Description                    VARCHAR(128) [utf8]                  
  41 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  42 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: UniqueXID [required]
Class: org.opengts.db.tables.UniqueXID

This table defines system-wide mapping of Transport Unique-IDs to a specific Account/Transport.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 uniqueID               Unique ID                      VARCHAR(40)                  PRIMARY 
   2 accountID              Account ID                     VARCHAR(32)                          
   3 transportID            Transport ID                   VARCHAR(32)                          


================================================================================================
Table: DeviceGroup [required]
Class: org.opengts.db.tables.DeviceGroup

This table defines Account specific Device Groups.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 groupID                Device Group ID                VARCHAR(32)                  PRIMARY 
   3 displayName            Display Name                   VARCHAR(40) [utf8]                   
   4 description            Description                    VARCHAR(128) [utf8]                  
   5 notes                  Notes                          TEXT [utf8]                          
   6 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   7 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: DeviceList [required]
Class: org.opengts.db.tables.DeviceList

This table defines the membership of a given Device within a DeviceGroup. A Device may be
defined in more than one DeviceGroup.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 groupID                Device Group ID                VARCHAR(32)                  PRIMARY 
   3 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   4 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   5 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: Driver [required]
Class: org.opengts.db.tables.Driver

This table defines Account specific Vehicle Drivers.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 driverID               Driver ID                      VARCHAR(32)                  PRIMARY 
   3 contactPhone           Contact Phone                  VARCHAR(32)                          
   4 contactEmail           Contact EMail                  VARCHAR(128)                         
   5 licenseType            License Type                   VARCHAR(24)                          
   6 licenseNumber          License Number                 VARCHAR(32)                          
   7 licenseExpire          License Expiration Day         INT UNSIGNED                         
   8 badgeID                Badge ID                       VARCHAR(32)                          
   9 address                Full Address                   VARCHAR(90) [utf8]                   
  10 birthdate              Driver Birthdate               INT UNSIGNED                         
  11 deviceID               Device/Asset ID                VARCHAR(32)                          
  12 displayName            Display Name                   VARCHAR(40) [utf8]                   
  13 description            Description                    VARCHAR(128) [utf8]                  
  14 notes                  Notes                          TEXT [utf8]                          
  15 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  16 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: EventData [required]
Class: org.opengts.db.tables.EventData

This table contains events which have been generated by all client devices.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 timestamp              Timestamp                      INT UNSIGNED                 PRIMARY 
   4 statusCode             Status Code                    INT UNSIGNED                 PRIMARY 
   5 latitude               Latitude                       DOUBLE                               
   6 longitude              Longitude                      DOUBLE                               
   7 gpsAge                 GPS Fix Age                    INT UNSIGNED                         
   8 speedKPH               Speed                          DOUBLE                               
   9 heading                Heading                        DOUBLE                               
  10 altitude               Altitude                       DOUBLE                               
  11 transportID            Transport ID                   VARCHAR(32)                          
  12 inputMask              Input Mask                     INT UNSIGNED                         
  13 outputMask             Output Mask                    INT UNSIGNED                         
  14 address                Full Address                   VARCHAR(90) [utf8]                   
  15 dataSource             Data Source                    VARCHAR(32)                          
  16 rawData                Raw Data                       TEXT                                 
  17 distanceKM             Distance KM                    DOUBLE                               
  18 odometerKM             Odometer Offset KM             DOUBLE                               
  19 odometerOffsetKM       Odometer KM                    DOUBLE                               
  20 geozoneIndex           Geozone Index                  INT UNSIGNED                         
  21 geozoneID              Geozone ID                     VARCHAR(32)                          
  22 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: Geozone [required]
Class: org.opengts.db.tables.Geozone

This table defines Account specific geozones/geofences.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 geozoneID              Geozone ID                     VARCHAR(32)                  PRIMARY 
   3 sortID                 Sort ID                        INT UNSIGNED                 PRIMARY 
   4 minLatitude            Min Latitude                   DOUBLE                       bounds  
   5 maxLatitude            Max Latitude                   DOUBLE                       bounds  
   6 minLongitude           Min Longitude                  DOUBLE                       bounds  
   7 maxLongitude           Max Longitude                  DOUBLE                       bounds  
   8 zonePurposeID          Purpose ID                     VARCHAR(32)                          
   9 reverseGeocode         Reverse geocode                TINYINT                              
  10 arrivalZone            Arrival Zone                   TINYINT                              
  11 departureZone          Departure Zone                 TINYINT                              
  12 autoNotify             Auto Notify                    TINYINT                              
  13 zoomRegion             Zoom Region                    TINYINT                              
  14 shapeColor             Shape Color                    VARCHAR(12)                          
  15 zoneType               Zone Type                      TINYINT UNSIGNED                     
  16 radius                 Radius Meters                  INT UNSIGNED                         
  17 latitude1              Latitude 1                     DOUBLE                               
  18 longitude1             Longitude 1                    DOUBLE                               
  19 latitude2              Latitude 2                     DOUBLE                               
  20 longitude2             Longitude 2                    DOUBLE                               
  21 latitude3              Latitude 3                     DOUBLE                               
  22 longitude3             Longitude 3                    DOUBLE                               
  23 latitude4              Latitude 4                     DOUBLE                               
  24 longitude4             Longitude 4                    DOUBLE                               
  25 latitude5              Latitude 5                     DOUBLE                               
  26 longitude5             Longitude 5                    DOUBLE                               
  27 latitude6              Latitude 6                     DOUBLE                               
  28 longitude6             Longitude 6                    DOUBLE                               
  29 latitude7              Latitude 7                     DOUBLE                               
  30 longitude7             Longitude 7                    DOUBLE                               
  31 latitude8              Latitude 8                     DOUBLE                               
  32 longitude8             Longitude 8                    DOUBLE                               
  33 latitude9              Latitude 9                     DOUBLE                               
  34 longitude9             Longitude 9                    DOUBLE                               
  35 latitude10             Latitude 10                    DOUBLE                               
  36 longitude10            Longitude 10                   DOUBLE                               
  37 clientUpload           Client Upload                  TINYINT                              
  38 clientID               Client ID                      INT UNSIGNED                 altIndex
  39 groupID                DeviceGroup                    VARCHAR(32)                          
  40 streetAddress          Street Address                 VARCHAR(90) [utf8]                   
  41 city                   City                           VARCHAR(40) [utf8]                   
  42 stateProvince          State/Province                 VARCHAR(40) [utf8]                   
  43 postalCode             Postal Code                    VARCHAR(16) [utf8]                   
  44 country                Country                        VARCHAR(40) [utf8]                   
  45 subdivision            Subdivision                    VARCHAR(32) [utf8]                   
  46 displayName            Display Name                   VARCHAR(40) [utf8]                   
  47 description            Description                    VARCHAR(128) [utf8]                  
  48 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  49 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: Resource [required]
Class: org.opengts.db.tables.Resource

This table defines Account specific text resources.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 resourceID             Resource ID                    VARCHAR(80)                  PRIMARY 
   3 type                   Type                           VARCHAR(16)                          
   4 title                  Title                          VARCHAR(70) [utf8]                   
   5 properties             Properties                     TEXT                                 
   6 value                  Value                          BLOB                                 
   7 displayName            Display Name                   VARCHAR(40) [utf8]                   
   8 description            Description                    VARCHAR(128) [utf8]                  
   9 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  10 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: Role [required]
Class: org.opengts.db.tables.Role

This table defines Account specific Roles.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 roleID                 Role ID                        VARCHAR(32)                  PRIMARY 
   3 displayName            Display Name                   VARCHAR(40) [utf8]                   
   4 description            Description                    VARCHAR(128) [utf8]                  
   5 notes                  Notes                          TEXT [utf8]                          
   6 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   7 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: RoleAcl [required]
Class: org.opengts.db.tables.RoleAcl

This table defines Role specific Access Control permissions.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 roleID                 Role ID                        VARCHAR(32)                  PRIMARY 
   3 aclID                  ACL ID                         VARCHAR(64)                  PRIMARY 
   4 accessLevel            Access Level                   SMALLINT UNSIGNED                    
   5 description            Description                    VARCHAR(128) [utf8]                  
   6 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   7 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: StatusCode [required]
Class: org.opengts.db.tables.StatusCode

This table defines Device specific StatusCode descriptions.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 statusCode             Status Code                    INT UNSIGNED                 PRIMARY 
   4 statusName             Status Name                    VARCHAR(18)                          
   5 foregroundColor        Foreground Color               VARCHAR(10)                          
   6 backgroundColor        Background Color               VARCHAR(10)                          
   7 iconSelector           Icon Selector                  VARCHAR(128)                         
   8 iconName               Icon Name                      VARCHAR(24)                          
   9 description            Description                    VARCHAR(128) [utf8]                  
  10 lastUpdateTime         Last Update Time               INT UNSIGNED                         
  11 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: SystemProps [required]
Class: org.opengts.db.tables.SystemProps

This table defines system-wide installation property key/values.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 propertyID             Property ID                    VARCHAR(32)                  PRIMARY 
   2 value                  Value                          TEXT [utf8]                          
   3 description            Description                    VARCHAR(128) [utf8]                  
   4 lastUpdateTime         Last Update Time               INT UNSIGNED                         
   5 creationTime           Creation Time                  INT UNSIGNED                         


================================================================================================
Table: EventTemplate [optional]
Class: org.opengts.db.dmtp.EventTemplate

This table contains DMTP event packet 'template's (Custom Event Packet Negotiation parse
templates) which have been received from client devices.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 customType             Custom Type                    TINYINT UNSIGNED             PRIMARY 
   4 repeatLast             Repeat Last                    TINYINT                              
   5 template               Template                       TEXT                                 


================================================================================================
Table: PendingPacket [optional]
Class: org.opengts.db.dmtp.PendingPacket

This table contains configuration packets which are to be sent to the DMTP client device the
next time it 'checks-in' with the server.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 queueTime              Packet Queue Time              INT UNSIGNED                 PRIMARY 
   4 sequence               Sequence                       SMALLINT UNSIGNED            PRIMARY 
   5 packetBytes            Packet Bytes                   MEDIUMBLOB                           
   6 autoDelete             Delete after sending           TINYINT                              


================================================================================================
Table: Property [optional]
Class: org.opengts.db.dmtp.Property

This table contains Device specific property information collected from client devices.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 propKey                Property Key                   INT UNSIGNED                 PRIMARY 
   4 timestamp              Timestamp                      INT UNSIGNED                         
   5 binaryValue            Binary Value                   BLOB                                 


================================================================================================
Table: Diagnostic [optional]
Class: org.opengts.db.dmtp.Diagnostic

This table contains Device specific diagnostic information collected from client devices.

  ## Column                 Description                    SQL Type                     Key     
 --- ---------------------- ------------------------------ ---------------------------- --------
   1 accountID              Account ID                     VARCHAR(32)                  PRIMARY 
   2 deviceID               Device/Asset ID                VARCHAR(32)                  PRIMARY 
   3 isError                Is Error                       TINYINT                      PRIMARY 
   4 codeKey                Code Key                       INT UNSIGNED                 PRIMARY 
   5 timestamp              Timestamp                      INT UNSIGNED                 PRIMARY 
   6 binaryValue            Binary Value                   BLOB                                 


