1. Basic Information Table
a) Company Information Sheet (jt808_company_info)
| Serial | Name | Type | Description |
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique |
| 2 | Name | varchar(64) | Company Name |
| 3 | Level | tinyint(2)| Company level, 1 for general company, 2 for fleet
| 4 | Code | varchar(64)| Company Code
| 5 | Abbreviation | varchar(40) | Company Short
| 6 | Legal | varchar(40) | Legal Entity
| 7 | Linkman | varchar(40)| Contact
| 8 | LinkPhone | varchar(40)| Tel
| 9 | IndustryType | tinyint(2)| Industry, 0 for other fields, 1 for logistics and transportation, 2 for vehicle leasing, 3 for public transport, 4 for taxis, 5 for concrete trucks, 6 for special vehicles, 7 for construction machinery
| 10 | ParentCompanyID | int(11)| parent company ID (column ID jt808_company the table). 0 indicates that a first- level company can only be created by an administrator account (it may be a fleet ID).
| 11 | BusinessLicenseNum | varchar(64)| Business License No.
| 12 | RegisteredCapital | varchar(40)| Company Registered Capital
| 13 | Address | varchar(128) | Company Address
| 14 | Introduction | varchar(256)| Company Profile
| 15 | Remark | varchar(512)| Remark
| 16 | CompanyID | int(11)| the ID of the parent company (must be the company ID, not the fleet ID)
| 17 | CustomerID | varchar(64)| Not used
| 18 | AccountID | int(11)| ID of the jt808_account corresponding to the primary account
| 19 | MoreInfoID | int(11)| Not used
| 20 | MarkerID | int(11)| Not used
| 21 | PlatformID | int(11)| Not used
|20|PRIMARY Key|ID|ID
b ) Company Association Table (jt808_company_relation)
| Serial | Name | Type | Description |
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | CompanyId | int(11) | Company ID (column ID jt808_company table)
| 3 | ChildId | int(11) | Subsidiary ID (column ID jt808_company table)
|4|UpdateTime|timestamp|
|5|PRIMARY Key|ID|ID
|INDEX|CompanyId_ChildId|'CompanyId', 'ChildId'|null
c) Vehicle Information Table (jt808_vehicle_info)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | VehiIDNO | varchar(40)| License plate number, unique identification
| 3 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 4 | DevType | tinyint(2) | Equipment type, 0 is other, 1 standard machine
| 5 | UseStatus | tinyint(2)| Usage Status, 0 for Normal, 1 for Maintenance, 2 for Discontinuation, 3 for Arrears
| 6 | PlateType | tinyint(2)| License plate type, 0 is other, 1 is yellow card, 2 is blue card, 3 is black card, 4 is white card
| 7 | VehiColor | varchar(16)| Vehicle color
| 8 | VehiBand | varchar(64)| Vehicle Brand
| 9 | VehiType | varchar(64)| Vehicle type
| 10 | VehiUse | varchar(64)| VEHICLE USE
| 11 | DriverId | int(11)| Driver ID, associated driver table
| 12 | DateProduct | datetime | Production date
| 13 | Icon | tinyint(2)| Icon type, distinguish between truck or passenger car
| 14 | ChnCount | tinyint(2)| Number of channels
| 15 | ChnName | varchar(512)| Channel Name
| 16 | IOInCount | tinyint(2)| Number of IO inputs
| 17 | IOInName | varchar(512)| IO input name
| 18 | IOOutCount | tinyint(2)| Number of IO outputs
| 19 | IOOutName | varchar(512)| IO output name
| 20 | TempCount | tinyint(2)| Number of temperature sensors
| 21 | TempName | varchar(512))| Temperature sensor name, separated
| 22 | Module | int(11)| Manufacturer Equipment Type (1- 808 2- Beidou 3- 1078)
| 23 | PayEnable | varchar(255)| Password
| 24 | PayBegin | tinyint(2)| Enabled 0 Enabled 1 Disabled
| 25 | PayPeriod | int(11)| Server port
| 26 | PayMonth | int(4)| Protocol type (0 unknown, 1 808GPS, 2 .808 video)
| 27 | PayDelayDay | int(11)| Number of pickups
| 28 | StoDay | int(11)| Number of cameras
| 29 | SafeEndDate | varchar(255)| Insurance Expiration Date
| 30 | DrivingNum | varchar(255)| License No.
| 31 | DrivingEndDate | varchar(255)| Driving license expiration time
| 32 | InstallationPlace | varchar(255)| Operating Certificate No.
| 33 | OperatingNum | varchar(255)| Expiration of operating certificate
| 34 | InstallTime | varchar(255)| Installation Date
| 35 | Abbreviation | varchar(255)| Vehicle abbreviation or alias
| 36 | Loading | varchar(255)| Load
| 37 | MoreInfoID | int(11)| Not used
| 38 | VehicleGrade | varchar(64)| Vehicle class
| 39 | ApprovedNumber | int(11)| authorized manned number
| 40 | ApprovedLoad | double | Approved load mass (tons)
| 41 | EngineNumber | varchar(256)| Engine No.
| 42 | FrameNumber | varchar(256)| Frame No.
| 43 | OwnerName | varchar(256)| Owner
| 44 | LineID | varchar(256)| OPERATING LINE
| 45 | LinkPeople | varchar(64)| Name
| 46 | LinkPhone | varchar(64)| Phone
| 47 | DatePurchase | datetime | Purchase date
| 48 | DateAnnualSurvey | datetime | Annual inspection date
| 49 | VehicleType | tinyint(2)| Vehicle type
| 50 | SpeedLimit | int(4)| Speed limit
| 51 | LinesOperation | varchar(64)| OPERATING LINE
| 52 | RepairEndDate | date | Repair expiration time
| 53 | PayEnd | datetime | Contract Expiration Date
| 54 | InstallTire | tinyint(1)| Install tire pressure, 0 means not installed, 1 means installed
| 55 | TireBrand | varchar(64)| Tire Pressure Brands
| 56 | TireModel | varchar(64)| Tire Pressure Model
| 57 | InstallAdas | tinyint(1)| ADAS installed, 0 means not installed, 1 means installed
| 58 | AdasBrand | varchar(64 | ADAS BRAND
| 59 | AdasModel | varchar(64 | ADAS Model
| 60 | InstallDsm | tinyint(1)| Install DSM,0 is not installed, 1 is installed
| 61 | DsmBrand | varchar(64)| DSM Brands
| 62 | DsmModel | varchar(64)| DSM Models
| 63 | InstallBlind | tinyint(1)| Install blind spot monitoring,,0 means not installed, 1 means installed
| 64 | BlindBrand | varchar(64)| Blind Spot Monitoring, Brand
| 65 | BlindModel | varchar(64)| Blind Spot Monitoring, Model
|66|PRIMARY Key|ID|ID
|67|UNIQUE Key|VehiIDNO|VehiIDNO
|68|Key|CompanyID|CompanyID
d) Equipment information table (jt808_device_info)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | DevIDNO | varchar(40)| Device number, unique identification
| 3 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 4 | SimCard | varchar(32) | SIM number
| 5 | SerialID | varchar(40)| Device Serial Number
| 6 | Brand | varchar(40)| Product Brands
| 7 | Model | varchar(40)| Device Model
| 8 | SoftwareVer | varchar(40)| Software Version
| 9 | HardwareVer | varchar(40)| Hardware Version
| 10 | Factory | varchar(40)| Product Merchants
| 11 | DevType | int(11)| equipment type, 0 is other, 1 standard machine, 2 Beidou terminals, 3 video terminals
| 12 | DevSubType | int(11)| Device subtype
| 13 | Protocol | int(11)| Communication protocol type
| 14 | DiskType | int(11)| Hard Drive Type, 1 SD,2 HDD, 3 SSD
| 15 | AudioCodec | int(11)| audio type for two- way intercom
| 16 | Remark | varchar(512)| Remark
| 17 | Install | tinyint(2)| Installation scenario 1: Installed 0: Not Installed
| 18 | InstallTime | datetime | Installation date
|19|nFlowLimitType|int(11)|
|20|NetAddrType|int(11)|
| 21 | FactoryType | int(11)| Vendor Type
| 22 | FactoryDevType | int(11)| Manufacturer Equipment Type (1- 808 2- Beidou 3- 1078)
| 23 | Password | varchar(255)| Password
| 24 | UseStatus | tinyint(2)| Enabled 0 Enabled 1 Disabled
| 25 | ServerPort | int(11)| Server port
| 26 | ProtocolType | int(4)| Protocol type (0 unknown, 1 808GPS, 2 .808 video)
| 27 | PickupNumber | int(11)| Number of pickups
| 28 | CameraNumber | int(11)| Number of cameras
| 29 | ServerAddress | varchar(255)| Server Address
| 30 | TransportEnterprise | varchar(255)| Transportation Enterprise
| 31 | AccessLineWay | varchar(255)| Access Line Mode
| 32 | InstallationPlace | varchar(255)| Installation Location
| 33 | StorageMediumType | varchar(255)| Video Storage Media Type
| 34 | StorageMediumModel | varchar(255)| Model
| 35 | StorageMediumSize | varchar(255)| Capacity
| 36 | SIMMolectronCode | varchar(255)| Integrated Circuit Card Identifier (ICCID) code of the SIM card used in the device
|37|IMEICode|varchar(512)|imei
| 38 | ExtendedProtocol | int(11)| Extended Protocol, 0: None, 1: Su Biao
|39|ProvinceId|int (11)| Provincial ID
| 40 | CityId | int(11)| City/County ID
| 41 | ManufacturerId | varchar(40)| Manufacturer ID
|42|PRIMARY Key|ID|ID
|43|UNIQUE Key|DevIDNO|DevIDNO
|44|Key|CompanyID|CompanyID
e) Equipment information table (jt808_vehicle_device_relation)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | VehiIDNO | varchar(64)| License plate number, unique label (VehiIDNO field in jt808_vehicle_info)
| 3 | DevIDNO | varchar(40)| Device number, unique identifier (DevIDNO field in jt808_device_info)
| 4 | MainDevFlag | tinyint(2)| Identifies the primary device, non- zero is the primary device (for multiple devices in 1 vehicle)
| 5 | ChnAttr | varchar(40)| Channel attribute, separated by, for example: 0,1 means channel 1, channel 2
| 6 | IOInAttr | varchar(40)| IO input attributes, separated
| 7 | IOOutAttr | varchar(40)| IO output attributes, separated
| 8 | TempAttr | varchar(40)| Temperature sensor properties, separated
| 9 | Module | int(11)| indicates the peripheral parameter attribute, expressed by bits, each bit indicates a peripheral, 0- video, 1- oil control, 2- circuit control, 3- tts voice, 4- intercom, 5- capture, 6- monitor ',
|10|PRIMARY Key|ID|ID
|11|UNIQUE Key|DevIDNO|DevIDNO
|12|UNIQUE KEY|VehiIDNO_DEVIDNO|('VehiIDNO', 'DevIDNO')
f) Device channel details table (jt808_devicechn_info)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | Device channel ID
| 2 | DeviceType | int(11) | Device types include (network camera, analog camera, pan/tilt, sensor device, etc.)
| 3 | CameraType | varchar(255)| Types of Cameras
| 4 | Model | varchar(255)| Model
| 5 | Manufacturer | varchar(255)| Manufacturer
| 6 | InstallationPlace | varchar(255)| Installation Location
| 7 | AccessLineWay | varchar(255)| Access Line Mode
| 8 | UseStatus | tinyint(2)| Use state 0 Use 1 disabled'
| 9 | PTZFunction | tinyint(2)| PTZ function 0 enabled 1 disabled
| | ChnName | varchar(255)| Channel Name
| | ChnIndex | tinyint(2)| Channel Index
|10|PRIMARY Key|ID|ID
|11|UNIQUE Key|DevIDNO|DevIDNO
|12|UNIQUE KEY|VehiIDNO_DEVIDNO|('VehiIDNO', 'DevIDNO')
|## g) Device Channel Association Table (jt808_devicechn_relation)
| - - - - | - - - - |
| Serial | Name | Type | Description
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | DeviceId | int(11)| The device ID, which corresponds to the ID field in the jt808_device_Info
| 3 | DeviceChnId | int(11)| The channel ID of the device, corresponding to the ID field in the jt808_devicechn_info
|4|PRIMARY Key|ID|ID
|
|
h) User Account Table (jt808_account)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | Account | varchar(40)| Account
| 3 | Name | varchar(40)| User name
| 4 | Password | varchar(64)| Password
| 5 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 6 | UserRoleID | int(11)| Role ID (ID of the corresponding jt808_user_role)
| 7 | UseStatus | tinyint(2)| Use status, 0 is disabled, 1 is applied, 2 is deleted
| 8 | CreateTime | datetime | Creation time
| 9 | Validity | datetime | Validity
| 10 | AccountType | int(2)| Account type (0: normal user, 1: enterprise administrator account)
| 11 | SingleLogin | tinyint(2)| Single sign- on 1 Single sign- on 0 Non single sign- on
| 12 | GeocoderMapType | tinyint(2)| Resolve Location Type 0 Default 1 Google 2 Baidu 3 Gaud 4 4D
| 13 | ModifyPassword | tinyint(2)| Run Change Password 0 Run 1 Not Allowed
| 14 | MainTitle | varchar(255)| Main Title
|15|Image|varchar(255)|
| 16 | Level | tinyint(2)| User levels, up to level 1 to level 5
| 17 | Dispatcher | tinyint(2)| Dispatcher account number | 0 Ordinary account number 1 Dispatcher account number
|18|PRIMARY Key|ID|ID
|19|UNIQUE Key|Account|Account
|20|KEY|CompanyID|CompanyID
I) User role information table (jt808_user_role)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | Name | varchar(40)| Role name
| 3 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 4 | Privilege | varchar(1024)| User Rights Information)
| 5 | Remark | varchar(512)| Remark
|6|PRIMARY Key|ID|ID
|7|UNIQUE Key|Account|Account
j) User Role Permission Association Table (jt808_user_role_relation)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | UserID | int(11)| User ID, corresponding to the ID field in the jt808_account
| 3 | RoleID | int(11)| Role ID, corresponding to the ID field in the jt808_user_role
|4|PRIMARY Key|ID|ID
k) Personal User Device License Form (jt808_user_vehicle_permit)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | AccountID | int(11)| User ID, corresponding to the ID field in the jt808_account
| 3 | VehiIDNO | int(11)| license plate number (corresponding to jt808_vehicle_info VehiIDNO)
|4|PRIMARY Key|ID|ID
User Information- Other Parameter Control Table (jt808_user_param)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | UserID | int(11) | Current user ID, corresponding to the ID field in the jt808_account
| 3 | ParentUserID | int(11) | Inherited from parent company,- 1 means not inherited, not inherited in this table
| 4 | Type | int(11) | parameter type, [1 close video; 2 close video without operation (no operation);3 close intercom and monitoring (automatic);4 close client (automatic);5 close client (no operation);6 close TCP chain]]
| 5 | Param0 | int(11) | Parameter 1 (Duration: storage unit in database, seconds)
| 6 | Param1 | int(11)| 0 | parameter 2 (processing method: 0 is automatically closed; 1 is prompted to close)
| 7 | Param2 | int(11)| 0 | Parameter 3 (closing prompt duration, storage unit in database, seconds)
| 8 | Param3 | int(11)| 0 | argument four (null)
| 9 | strParam | varchar(256)| Save more parameters (null)
l)IC card table (jt808_card_info)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | CardNum | varchar(32)| User ID, corresponding to the ID field in the jt808_account
| 3 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 4 | IsEnable | int(2)| 0- Not used 1- Used
|5|PRIMARY Key|ID|ID
m) Driver Information Table (jt808_driver_info)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11)| ID index, incrementing, unique
| 2 | JobNum | varchar(32)| Job No.
| 3 | Name | varchar(32)| Name
| 4 | Sex | smallint(4)| Sex, 1 Male 2 Female
| 5 | Contact | varchar(32)| Contact
| 6 | IDNumber | varchar(32)| ID No.
| 7 | DateOfBirth | datetime | Date of Birth
| 8 | DriverLicenseNum | varchar(32)| driver's license number
| 9 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 10 | RushDate | datetime | Driver's License Date
| 11 | Validity | datetime | Validity
| 12 | PostID | int(11)| Position ID 1 Driver 2 Attendant
| 13 | CardID | int(11)| IC card information table ID (column ID jt808_card_info the table)
| 14 | Remark | varchar(512)| Remark
| 15 | LicenseType | varchar(32)| Driver's License Type
| 16 | RemindDay | varchar(512)| Reminder Days
| 17 | DrivingLicenseSrc | varchar(256)| Driver's License Type
| 18 | QualificationCertificateSrc | varchar(256)| Driver's License Photo Address
| 19 | TransportStatus | tinyint(1)| Shipping status, 0 indicates not shipping status, 1 indicates shipping
| | PerfectStatus | tinyint(1)| Information perfect status, 0 is not perfect, 1 is perfect
| 20 | EscortQualificationCertificateSrc | varchar(256)| Photo Address of Escort Qualification Certificate
| 21 | QualificationCertificateNum | varchar(256)| Driver's Qualification Number
| 22 | EscortQualificationCertificateNum | varchar(256)| Escort Certificate No.
| 23 | ReminderDays | int(11)| Reminder days
| 24 | StartTime | datetime | Document validity date start time
|25|PRIMARY Key|ID|ID
|26|UNIQUE Key|JobNum|JobNum
n) Server information table (server_info)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | Name | varchar(256)| Server name
| 3 | IDNO | varchar(40)| Server number, unique
| 4 | Area | int(11)| Region, temporarily invalid
| 5 | Type | int(11)| Type, 1 login, 2 gateway, 3 streaming, 4 user
|6|LanIP | varchar(256)| LAN Address
| 7 | IPDevice | varchar(256)| Device access address 1
| 8 | PortDevice | int(11))| Device Access Port
| 9 | IPClient | varchar(256)| Client access address 1
| 10 | PortClient | int(11))| Customer Access Port
| 11 | PortClientOther | varchar(256)| Client Other Port
| 12 | IPDevice2 | varchar(256)| Device access address 2
| 13 | IPClient2 | varchar(256)| Client access address 2
| 14 | OfflineTimeout | int(11)| Offline duration
|15|AuthorizeCode|varchar(128)|
| 16 | IPClient3 | varchar(256)| Client Access Address 3
|17|PRIMARY Key|ID|ID
|18|UNIQUE Key|IDNO|IDNO
o) Media Association Table (jt808_media_relation)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | VehiID | int(11)| Vehicle ID (corresponds to the ID in the jt808_vehicle_info table)
| 3 | ServerID | int(11)| streaming server id (corresponds to the id in the server_info)
|4|PRIMARY Key|ID|ID
|5|UNIQUE Key|IDNO|IDNO
p) Map marker information table (map_marker)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | TypeId | int(11)| Map marker types
| 2 | Name | varchar(100)| Tag name
| 3 | Adress | varchar(256)| Address
| 4 | Longtude | mediumtext | Longitude
| 5 | Latitude | mediumtext | Latitude
| 6 | Color | varchar(10)| Display Color
|7|TabType|int(1)|
| 8 | Creator | int(11)| The user who created the map flag
| 9 | Remark | varchar(256)| Remark
| 10 | UserID | int(11)| Own company ID (ID in jt808_company_info)
| 11 | nExtinguisherNum | int(11)| Number of Fire Extinguishers
| 12 | MapType | int(11)| Map Type
| 13 | Share | int(11)| Share or not, 0- Don't share 1- Company share 2- Global share
|14|AreaId|int(11)|
|15|ParentID|int(11)|
|16|AreaName|varchar(64)|
| 17 | AreaType | int(11)| Administrative Region | 0 Custom, 1 Administrative Region
|18|Image|varchar(255)|
|19|StartPointName|varchar(255)|
|20|EndPointName|varchar(255)|
|21|StartPointGps|varchar(255)|
|22|EndPointGps|varchar(255)|
|23|Param|varchar(512)|
|24|PRIMARY KEY|ID|ID
q) Storage association table (jt808_storage_relation)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | DevIDNO | char(64)| Device number (corresponds to devIDNO in jt808_Device_info table)
| 3 | SvrIDNO | char(40)| Bank server IDNO (corresponds to IDNO in server_info)
|4|PRIMARY Key|ID|ID
|5|UNIQUE Key|IDNO|IDNO
r) Rule Maintenance Table (jt808_rule_maintain)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | Name | | Rule name
| 3 | CompanyID | int(11)| Company ID (column ID jt808_company the table)
| 4 | MarkID' | int(11)| Callout ID (corresponding ID map_marker the table)
| 5 | Type | tinyint(2)| Rule Type 1- Fatigue Rule 2- Forbidden Rule 3- Forbidden Rule 4- Regional Overspeed 5- Time Overspeed Rule 6- Long Parking Time Rule 7- Line Offset 8- Timing Photo Rule 9- Timing Video Rule 10- wifi Download Rule, etc,
| 6 | ArmType | int(11)| Alarm Types
| 7 | BeginTime | int(11)| Start time
| 8 | EndTime | int(11)| End time
| 9 | Text | varchar(1024)| Text information
| 10 | Param | varchar(1024)| Parameter combination, separated by, according to parameter type
| 11 | AreaType | int(2)| Region Type
|12|ParentID|int(11)|
|13|PRIMARY Key|ID|ID
|14|UNIQUE Key|Name|'Name', 'CompanyID'
s) Vehicle rule association table (jt808_vehicle_rule)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | VehiIDNO | varchar(64)| VehiIDNO (corresponds to vehiIDNO in jt808_vehicle_info table)
| 3 | RuleID | int(11)| Rule ID, in Table jt808_rule_maintain
|4|PRIMARY Key|ID|ID
|5|UNIQUE Key|VehiIDNO_Rule|'VehiIDNO', 'RuleID'
t) Equipment status table (dev_status)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | DevIDNO | int(11)| DevIDNO in jt808_device_info for device number
| 3 | GWSvrIDNO | varchar(40)| Gateway Server
| 4 | IP | varchar(40)| Device IP
| 5 | Port | varchar(32)| Device Port
| 6 | Online | int(11)| Online
| 7 | Network | int(11)| Network type, 0 means 3G,1 means WIFI
| 8 | NetName | varchar(64)| Network name
| 9 | Status1 | int(11)| state 1,ACC, GPS, etc.
| 10 | Status2 | int(11)| State 2
| 11 | Status3 | int(11)| State 3
| 12 | Status4 | int(11)| State 4
| 13 | Speed | int(11)| Speed
| 14 | JingDu | int(11)| Longitude
| 15 | WeiDu | int(11)| Latitude
| 16 | GaoDu | int(11)| Height
| 17 | Satellites | int(11)| Number of satellites
| 18 | HangXiang | int(11)| heading
| 19 | LiCheng | int(11)| Mileage
| 20 | YouLiang | int(11)| Oil Quantity
| 21 | ParkTime | int(11)| Parking duration
| 22 | TempSensor1 | int(11)| Temperature sensor 1
|23|TempSensor2|int(11)|
|24|TempSensor3|int(11)|
|25|TempSensor4|int(11)|
| 26 | GPSTime | datetime | GPS Time
| 27 | LoginTime | datetime | Device logon time
| 28 | MapType | int(11)| Map module type
| 29 | MapJingDu | int(11)| Map module type
| 30 | MapWeiDu | int(11)| Map module type
| 31 | FactoryType | int(11)| Vendor Type
| 32 | FactoryDevType | int(11)| Vendor Device Type
| 33 | Protocol | int(11)| Communication protocol type
| 34 | DiskType | int(11)| Hard drive type 1 SD,2 HDD, 3 SSD
| 35 | AudioCodec | int(11)| audio type for two- way intercom
| 36 | TachographSpeed | int(11)| tachograph acquisition speed
| 37 | ObdRpm | int(11)| OBD collects engine speed
| 38 | ObdSpeed | int(11)| OBD collects engine speed
| 39 | ObdVotage | int(11)| OBD collects battery voltage
| 40 | ObdJQTemp | int(11)| OBD collects fuel intake air temperature
| 41 | ObdStatus | int(11)| OBD collection status
| 42 | ObdJQMPos | int(11)| OBD captures throttle position
| 43 | PeopleUp | int(11)| Number of passengers
| 44 | PeopleDown | int(11)| Number of people getting off
| 45 | PeopleCur | int(11)| Number of people on board
|46|Imei|varchar(64)|
|47|Imsi|varchar(64)|
| 48 | HardVer | varchar(64)| Hardware version
| 49 | SoftVer | varchar(64)| Software Version
| 50 | LineID | int(11)| Line ID
| 51 | DriverID | int(11)| Driver ID
| 52 | LineDirection | int(2)| line uplink and downlink 0- uplink, 1- downlink
| 53 | StationFlag | int(2)| SIGN 0- SIGN 1- STATION Yard
| 54 | StationIndex | int(4)| Site Index
| 55 | StationStatus | int(2)| Site Status 0- This Site 1- Next
| 56 | ExtraFlag | int(11)| Additional Information Flag Bit 0- Bus OBD 1- Video Logo
| 57 | Sensor1 | int(11)| Sensor 1
| 58 | Sensor2 | int(11)| Sensor 2
| 59 | Sensor3 | int(11)| Sensor 3
| 60 | Sensor4 | int(11)| Sensor 4
| 61 | Sensor5 | int(11)| Sensor 5
| 62 | Sensor6 | int(11)| Sensor 6
| 63 | Sensor7 | int(11)| Sensor 7
| 64 | Sensor8 | int(11)| Sensor 8
| 65 | Sensor9 | int(11)| Sensor 9
| 66 | Sensor10 | int(11)| Sensor 10
| 67 | LoginType | tinyint(2)| 0 linux 1windows 2web 3 Android 4ios
|68|PRIMARY KEY |ID|ID
|69|UNIQUE KEY|DevIDNO|DevIDNO
2. Reports and Media Record Data
a)GPS data information table (jt808_vehicle_gps_N_YYYYYMM)
Note: Horizontal table is used (N:{1,2,3,4} YYYYYMM: year and month)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | VehiID | int(11)| License plate ID (corresponds to the ID in the jt808_vehicle_info table)
| 3 | DevIDNO | varchar(40)| Equipment number, DevIDNO in table jt808_device_info
| 4 | GPSDate | date | Time, in days
| 5 | GPSData | mediumblob | GPS data
|6|INDEX|Index_VehiIDAndDate|'VehiID', 'GPSDate'
|7|INDEX|Index_DevIDNOAndDate|'DevIDNO', 'GPSDate'
b) Alarm information table (jt808_vehicle_alarm_TYPE_YYYYYMM)
Note: Horizontal table (TYPE:{default,run,speed, video,adas} YYYYYMM: month/year)
| Serial | Name | Type | Description |
| - - - - | - - - - |
| 1 | Guid | varchar(40)| Alarm GUID, unique
| 2 | VehiID | int(11)| License plate ID (corresponds to the ID in the jt808_vehicle_info table)
| 3 | DevIDNO | varchar(40)| Equipment number, DevIDNO in table jt808_device_info
| 4 | ArmTimeStart | datetime | Alarm start time
| 5 | ArmTimeEnd | datetime | Alarm end time
| 6 | ArmType | int(11)| Alarm Types
| 7 | ArmInfo | int(11)| Alarm information
| 8 | Param1 | int(11)| Alarm parameter 1
| 9 | Param2 | int(11)| Alarm parameter 2
| 10 | Param3 | int(11)| Alarm parameter 3
| 11 | Param4 | int(11)| Alarm parameter 4
| 12 | ArmDesc | varchar(256)| Alarm description
| 13 | StatusStart | varchar(256)| Alarm start status information
| 14 | StatusEnd | varchar(256)| Alarm end status information
| 15 | ImageInfo | varchar(512)| Picture Information
| 16 | HandleStatus | tinyint(1)| Processing status 0 unprocessed, 1 processed
| 17 | HandleInfo | varchar(512)| Processing Information
|18|ArmTimeStartI|int(11)|
|19|ArmTimeEndI|int(11)|
| 20 | HandleUserID | int(11)| Process the ID in the jt808_account table corresponding to the user ID
| 21 | RecID | int(11)| The ID of the jt808_sto_dev_av_record.
| 22 | PicID | int(11)| The ID of the jt808_sto_dev_snapshot_record.
| 23 | StartPosition | varchar(512)| Start Geo
| 24 | EndPosition | varchar(512)| End Geo
|25|PRIMARY KEY|Guid|Guid
|26|INDEX|vehi_type|'VehiID', 'ArmType', 'ArmTimeStartI'
c) Running log table (jt808_run_log_YYYYYMM)
Note: Horizontal sub- table is used (YYYYYMM: year and month)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | Type | int(11) | 0 users, 1 vehicles
| 3 | UserID | int(11) | The ID in the jt808_accoun table corresponding to the user ID
| 4 | VehiID | int(11) | Vehicle ID
| 5 | DevIDNO | varchar(40)| Equipment No.
| 6 | MainType | int(11) | Large type
| 7 | SubType | int(11) | Subtype
| 8 | IPAddress | varchar(64)| IP Address
| 9 | TotalTime | int(11) | Total duration
| 10 | FlowUsed | float | Traffic in MB
| 11 | ParamStr1 | varchar(256)| Argument 1
| 12 | ParamStr2 | varchar(256)| Argument 21
| 13 | ParamStr3 | varchar(256)| Argument 3
| 14 | ParamStr4 | varchar(256)| Argument 4
| 15 | StartTime | datetime | Start time
| 16 | EndTime | datetime | End time
|17|StartTimeI|int(11)|
|18|EndTimeI|int(11)|
|19|PRIMARY KEY|ID|ID
|20|INDEX|Index_Type_UserID_StarTime_EndTime|'Type', 'UserID', 'StartTimeI', 'EndTimeI'
|21|INDEX|Index_Type_VehiID_StarTime_EndTime|'Type', 'VehiID', 'StartTimeI', 'EndTimeI'
d) Daily vehicle report (jt808_vehicle_daily)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | VehiID | int(11)| The license plate ID corresponds to the ID in the jt808_vehicle_info
| 2 | DevIDNO | varchar(40)| Equipment No.
| 3 | GPSDate | date | time, day
| 4 | STime | datetime | Start time
| 5 | SJingDu | int(11)| the beginning longitude position
| 6 | SWeiDu | int(11)| Starting latitude
| 7 | SGaoDu | int(11)| Start height position
| 8 | Etime | datetime | End time
| 9 | EJingDu | int(11)| Longitude of the end time
| 10 | EWeiDu | int(11)| Latitude of end time
| 11 | EGaoDu | int(11)| End height position
| 12 | SLiCheng | int(11)| Start Mileage
| 13 | ELiCheng | int(11)| End Mileage
| 14 | SYouLiang | int(11)| Starting oil quantity
| 15 | EYouLiang | int(11)| End of oil
| 16 | AYouLiang | int(11)| Come on
| 17 | RYouLiang | int(11)| stealing oil
| 18 | UWifiLiuLiang | int(11)| WIFI Upstream
| 19 | DWifiLiuLiang | int(11)| WIFI Downstream
| 20 | USimLiuLiang | int(11)| SIM Upstream
| 21 | DSimLiuLiang | int(11)| SIM Downstream
| 22 | YouHao | int(11)| Fuel consumption
| 23 | WorkTime | int(11)| Working hours
|24|GPSDateI|int(11)|
| 25 | AlarmSum | varchar(256)| Alarm statistics
| 26 | OnlineStatus | int(11)| Presence
| 27 | GPSUnlocatedNum | int(11)| Undetermined digit
| 28 | GPSLatLngErrNum | int(11)| Latitude and longitude errors
| 29 | GPSSpeedErrNum | int(11)| Number of speed errors
| 30 | GPSAltitudeErrNum | int(11)| Height errors
| 31 | GPSDirectionErrNum | int(11)| Number of direction errors
| 32 | GPSDriftNum | int(11)| drift number
| 33 | TrackDisconNum | int(11)| Trajectory discontinuities
| 34 | GPSTotal | int(11)| Total GPS
| 35 | GPSDriftLicheng | int(11)| GPS Drift Track Mileage
| 36 | TrackDisconLiCheng | int(11)| GPS track discontinuous mileage
| 37 | TrackGPSLiCheng | int(11)| Total mileage by GPS
| 38 | RealGPSLiCheng | int(11)| Total mileage after filtering abnormal data
|39|PRIMARY KEY||'VehiID', 'GPSDate'
|40|INDEX|Index_VehiIDAndDate|'VehiID', 'GPSDateI'
e) Daily Report of Su Biao Vehicle (sb_vehicle_daily)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | VehiID | int(11)| License plate ID
| 2 | GPSDate | date | Time, day
| 3 | Licheng | int(11)| Mileage
| 4 | WorkTime | int(11)| Working hours
| 5 | SB_L1_FCW_Count | int(11)| total number of level 1 forward collisions
| 5 | SB_L2_FCW_Count | int(11)| total number of level 2 forward collisions
| 6 | SB_L1_LDW_Count | int(11)| total number of level 1 lane departure from su
| 7 | SB_L2_LDW_Count | int(11)| total number of lane departure level 2
| 8 | SB_L1_NEAR_CAR_Count | int(11)| Total number of Su Biao cars passing nearly level 1
| 9 | SB_L2_NEAR_CAR_Count | int(11)| Total number of Su Biao cars over level 2
| 10 | SB_L1_HIT_PEDESTRIAN_Count | int(11)| total number of level 1 pedestrian impacts
| 11 | SB_L2_HIT_PEDESTRIAN_Count | int(11)| total number of level 2 pedestrian impacts
| 12 | SB_L1_FREQUENT_LANE_CHANGE_Count | int(11)| total number of grade 1 frequent lane changes in su standard
| 13 | SB_L2_FREQUENT_LANE_CHANGE_Count | int(11)| total number of grade 2 frequent lane changes in su standard
| 14 | SB_L1_ROAD_MARKING_OVER_LIMIT_Count | int(11)| total number of subao road signs exceeding grade 1
| 15 | SB_L2_ROAD_MARKING_OVER_LIMIT_Count | int(11)| total number of subao road signs exceeding grade 2
| 16 | SB_L1_OBSTACLE_Count | int(11)| total number of level 1 obstacles
| 17 | SB_L2_OBSTACLE_Count | int(11)| total number of level 2 obstacles
| 18 | SB_L1_FATIGUE_DRIVING_Count | int(11)| total number of level 1 fatigue driving alarms for su standard
| 19 | SB_L2_FATIGUE_DRIVING_Count | int(11)| total number of levels 2 of Su Biao fatigue driving alarm
| 20 | SB_L1_CALL_Count | int(11)| total number of level 1 calls received by Su standard
| 21 | SB_L2_CALL_Count | int(11)| total number of level 2 calls received by su standard
| 22 | SB_L1_SMOKING_Count | int(11)| total number of level 1 smoking alarms in su standard
| 23 | SB_L2_SMOKING_Count | int(11)| total number of level 2 smoking alarms in su standard
| 24 | SB_L1_DISTRACTED_DRIVING_Count | int(11)| total number of level 1 of Su Biao distracted driving
| 25 | SB_L2_DISTRACTED_DRIVING_Count | int(11)| Su Biao's total number of distracted driving levels 2
| 26 | SB_L1_DRIVER_ABNORMAL_Count | int(11)| Total number of Driver Exception Level 1
| 27 | SB_L2_DRIVER_ABNORMAL_Count | int(11)| Total number of Driver Exception Level 2
| 28 | SB_TPMS_Count | int(11)| Total tire pressure alarms
| 29 | SB_REAR_PROXIMITY_Count | int(11)| Total number of rear proximity alarms
| 30 | SB_REAR_LEFT_CLOSE_Count | int(11)| Total number of left rear proximity alarms
| 31 | SB_REAR_RIGHT_CLOSE_Count | int(11)| Total right rear proximity alarms
|34|PRIMARY KEY||'VehiID', 'GPSDate'
|35|INDEX||'VehiID', 'GPSDateI''
f) Daily Report of Su Biao Driver (sb_driver_daily)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | DriverID | int(11)| Driver ID
| 2 | GPSDate | date | Time, day
| 3 | Licheng | int(11)| Mileage
| 4 | WorkTime | int(11)| Working hours
| 5 | SB_L1_FCW_Count | int(11)| total number of level 1 forward collisions
| 5 | SB_L2_FCW_Count | int(11)| total number of level 2 forward collisions
| 6 | SB_L1_LDW_Count | int(11)| total number of level 1 lane departure from su
| 7 | SB_L2_LDW_Count | int(11)| total number of lane departure level 2
| 8 | SB_L1_NEAR_CAR_Count | int(11)| Total number of Su Biao cars passing nearly level 1
|9|SB_L2_NEAR_CAR_Count|int(11)| Total number of cars near grade 2
| 10 | SB_L1_HIT_PEDESTRIAN_Count | int(11)| total number of level 1 pedestrian impacts
| 11 | SB_L2_HIT_PEDESTRIAN_Count | int(11)| total number of level 2 pedestrian impacts
| 12 | SB_L1_FREQUENT_LANE_CHANGE_Count | int(11)| total number of grade 1 frequent lane changes in su standard
| 13 | SB_L2_FREQUENT_LANE_CHANGE_Count | int(11)| total number of grade 2 frequent lane changes in su standard
| 14 | SB_L1_ROAD_MARKING_OVER_LIMIT_Count | int(11)| total number of subao road signs exceeding grade 1
| 15 | SB_L2_ROAD_MARKING_OVER_LIMIT_Count | int(11)| total number of subao road signs exceeding grade 2
| 16 | SB_L1_OBSTACLE_Count | int(11)| total number of level 1 obstacles
| 17 | SB_L2_OBSTACLE_Count | int(11)| total number of level 2 obstacles
| 18 | SB_L1_FATIGUE_DRIVING_Count | int(11)| total number of level 1 fatigue driving alarms for su standard
| 19 | SB_L2_FATIGUE_DRIVING_Count | int(11)| total number of levels 2 of Su Biao fatigue driving alarm
| 20 | SB_L1_CALL_Count | int(11)| total number of level 1 calls received by Su standard
| 21 | SB_L2_CALL_Count | int(11)| total number of level 2 calls received by su standard
| 22 | SB_L1_SMOKING_Count | int(11)| total number of level 1 smoking alarms in su standard
| 23 | SB_L2_SMOKING_Count | int(11)| total number of level 2 smoking alarms in su standard
| 24 | SB_L1_DISTRACTED_DRIVING_Count | int(11)| total number of level 1 of Su Biao distracted driving
| 25 | SB_L2_DISTRACTED_DRIVING_Count | int(11)| Su Biao's total number of distracted driving levels 2
| 26 | SB_L1_DRIVER_ABNORMAL_Count | int(11)| Total number of Driver Exception Level 1
| 27 | SB_L2_DRIVER_ABNORMAL_Count | int(11)| Total number of Driver Exception Level 2
| 28 | SB_L1_FCW_Score | int(11)| su standard forward collision level 1 score
| 29 | SB_L2_FCW_Score | int(11)| su standard forward collision level 2 score
| 30 | SB_L1_LDW_Score | int(11)| Su Biao Lane Departure Level 2 Score
| 31 | SB_L2_LDW_Score | int(11)| su biao lane departure level 2 score
| 32 | SB_L1_NEAR_CAR_Score | int(11)| Su standard car distance is too close to level 1 score
| 33 | SB_L2_NEAR_CAR_Score | int(11)| Su standard car distance is too close to level 2 score
| 34 | SB_L1_HIT_PEDESTRIAN_Score | int(11)| su standard pedestrian collision level 1 score
| 35 | SB_L2_HIT_PEDESTRIAN_Score | int(11)| su standard pedestrian collision level 2 score
| 36 | SB_L1_FREQUENT_LANE_CHANGE_Score | int(11)| Su Biao Frequent Channel Change Level 1 Score
| 37 | SB_L2_FREQUENT_LANE_CHANGE_Score | int(11)| Su Biao Frequent Channel Change Level 2 Score
| 38 | SB_L1_ROAD_MARKING_OVER_LIMIT_Score | int(11)| Su Biao Road Sign Excedance Level 1 Score
| 39 | SB_L2_ROAD_MARKING_OVER_LIMIT_Score | int(11)| Su Biao Road Sign Excess Level 2 Score
| 40 | SB_L1_OBSTACLE_Score | int(11)| su standard obstacle level 1 score
| 41 | SB_L2_OBSTACLE_Score | int(11)| su standard obstacle level 2 score
| 42 | SB_L1_FATIGUE_DRIVING_Score | int(11)| Su Standard Fatigue Driving Alarm Level 1 Score
| 43 | SB_L2_FATIGUE_DRIVING_Score | int(11)| Su Biao Fatigue Driving Alarm Level 2 Score
| 44 | SB_L1_CALL_Score | int(11)| Su Biao Call and Call Level 1 Score
| 45 | SB_L2_CALL_Score | int(11)| Su Biao Call and Call Level 2 Score
| 46 | SB_L1_SMOKING_Score | int(11)| Su Biao Smoking Alarm Level 1 Score
| 47 | SB_L2_SMOKING_Score | int(11)| Su Biao Smoking Alarm Level 2 Score
| 48 | SB_L1_DISTRACTED_DRIVING_Score | int(11)| Su Biao distracted driving level 1 score
| 49 | SB_L2_DISTRACTED_DRIVING_Score | int(11)| Su Biao distracted driving level 2 score
| 50 | SB_L1_DRIVER_ABNORMAL_Score | int(11)| Driver Exception Level 1 Score
| 51 | SB_L2_DRIVER_ABNORMAL_Score | int(11)| Driver Anomaly Level 2 Score
| 52 | Total_Score | int(11)| Total score
|53|PRIMARY KEY||'DriverID', 'GPSDate'
|54|INDEX||'DriverID', 'GPSDateI''
g) Daily Statement of Su Biao Company (sb_company_daily)
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | CompanyID | int(11)| Company ID
| 2 | GPSDate | date | Time, day
| 3 | Licheng | int(11)| Mileage
| 4 | WorkTime | int(11)| Working hours
| 5 | SB_L1_FCW_Count | int(11)| total number of level 1 forward collisions
| 5 | SB_L2_FCW_Count | int(11)| total number of level 2 forward collisions
| 6 | SB_L1_LDW_Count | int(11)| total number of level 1 lane departure from su
| 7 | SB_L2_LDW_Count | int(11)| total number of lane departure level 2
| 8 | SB_L1_NEAR_CAR_Count | int(11)| Total number of Su Biao cars passing nearly level 1
| 9 | SB_L2_NEAR_CAR_Count | int(11)| Total number of Su Biao cars over level 2
| 10 | SB_L1_HIT_PEDESTRIAN_Count | int(11)| total number of level 1 pedestrian impacts
| 11 | SB_L2_HIT_PEDESTRIAN_Count | int(11)| total number of level 2 pedestrian impacts
| 12 | SB_L1_FREQUENT_LANE_CHANGE_Count | int(11)| total number of grade 1 frequent lane changes in su standard
| 13 | SB_L2_FREQUENT_LANE_CHANGE_Count | int(11)| total number of grade 2 frequent lane changes in su standard
| 14 | SB_L1_ROAD_MARKING_OVER_LIMIT_Count | int(11)| total number of subao road signs exceeding grade 1
| 15 | SB_L2_ROAD_MARKING_OVER_LIMIT_Count | int(11)| total number of subao road signs exceeding grade 2
| 16 | SB_L1_OBSTACLE_Count | int(11)| total number of level 1 obstacles
| 17 | SB_L2_OBSTACLE_Count | int(11)| total number of level 2 obstacles
| 18 | SB_L1_FATIGUE_DRIVING_Count | int(11)| total number of level 1 fatigue driving alarms for su standard
| 19 | SB_L2_FATIGUE_DRIVING_Count | int(11)| total number of levels 2 of Su Biao fatigue driving alarm
| 20 | SB_L1_CALL_Count | int(11)| total number of level 1 calls received by Su standard
| 21 | SB_L2_CALL_Count | int(11)| total number of level 2 calls received by su standard
| 22 | SB_L1_SMOKING_Count | int(11)| total number of level 1 smoking alarms in su standard
| 23 | SB_L2_SMOKING_Count | int(11)| total number of level 2 smoking alarms in su standard
| 24 | SB_L1_DISTRACTED_DRIVING_Count | int(11)| total number of level 1 of Su Biao distracted driving
| 25 | SB_L2_DISTRACTED_DRIVING_Count | int(11)| Su Biao's total number of distracted driving levels 2
| 26 | SB_L1_DRIVER_ABNORMAL_Count | int(11)| Total number of Driver Exception Level 1
| 27 | SB_L2_DRIVER_ABNORMAL_Count | int(11)| Total number of Driver Exception Level 2
| 28 | SB_TPMS_Count | int(11)| Total tire pressure alarms
| 29 | SB_REAR_PROXIMITY_Count | int(11)| Total number of rear proximity alarms
| 30 | SB_REAR_LEFT_CLOSE_Count | int(11)| Total number of left rear proximity alarms
| 31 | SB_REAR_RIGHT_CLOSE_Count | int(11)| Total right rear proximity alarms
|34|PRIMARY KEY||'CompanyID', 'GPSDate'
|35|INDEX||'CompanyID', 'GPSDateI''
h) Vehicle Media Record (jt808_vehicle_media_YYYYYMM)
Note: Horizontal sub- table is used (YYYYYMM: year and month)
Alternative jt808_dev_snapshot_record and jt808_sto_dev_av_record
| Serial | Name | Type | Description
| - - - - | - - - - |
| 1 | ID | int(11) | ID index, incrementing, unique
| 2 | VehiID | int(11)| ID in the license plate ID correspondence table jt808_vehicle_info
| 3 | DevIDNO | int(11)| DevIDNO in jt808_device_info for device number
| 4 | Channel | int(11)| channel number (single channel number)
| | ChnMask | int(11)| Channel mask, valid when a file has multiple channels of recordings
| 5 | MediaType | tinyint(2)| Media Type 0- Picture 1 Audio Video - 2- Audio 3- Video 4- Text 5- Other
| 6 | FileType | tinyint(2)| Type 0- Normal 1- Alarm Trigger
| 7 | FilePath | varchar(256)| File path
| 8 | FileOffset | int(11)| File offset
| 9 | FileSize | int(11)| File size
| 10 | FileSTime | datetime | File start time
| 11 | FileETime | datetime | End of file
| 12 | Status | tinyint(2)| Recording Status 0- Incomplete 1- Complete
| 13 | SvrID | int(11)| Server number
| 14 | FileLocation | int(11)| File storage location
| 15 | GPSStatus | varchar(512)| GPS status information
| 16 | AlarmType | int(11)| Alarm Type
| 17 | AlarmParam | int(11)| Alarm parameters
| 18 | ChnMask | int(11)| channel mask, valid when a file has multiple channels of recordings
| 19 | Source | int(11)| 1 indicates that
| 20 | SourceID | int(11)| valid when it is downloaded from the device, indicating the ID in the corresponding task table
| 21 | AlarmFlag1 | int(11)| Alarm flag bit 1
| 22 | AlarmFlag2 | int(11)| Alarm flag bit 2
| 23 | StreamType | int(11)| 0: main code stream, 1: sub code stream
| 24 | StoreType | int(11)| Where source files are stored on the device
| 25 | Label | varchar(256)| Label |
|26|FileSTimeI|int(11)|
|27|FileETimeI|int(11)|
| 28 | ReservInt1 | int(11)| Reserved fields
| 29 | ReservInt2 | int(11)| Reserved fields
| 30 | ReservInt3 | int(11)| Reserved fields
| 31 | ReservInt4 | int(11)| Reserved fields
| 32 | ReservChar1 | varchar(256)| Reserved fields
| 33 | ReservChar2 | varchar(256)| Reserved fields
|34|PRIMARYKEY||VehiID', 'MediaType', 'Channel', 'FileType', 'SvrID', 'FileSTimeI', 'SourceID', 'Label'(100)
|35|INDEX||'VehiID', 'FileSTimeI', 'Channel', 'FileType', 'AlarmType'
|36|INDEX||'FileSTimeI', 'Label'(255), 'MediaType'
|
|
3. Function and Event Description
a) Function
| Serial | Name | Description
| - - - - | - - - - |
| 1 | jt808_Proc_VehiDaily_Add | Update data in daily vehicle reports in real time
| jt808_Vehicle_Daily
| 2 | Proc_CreateAlarmMonthTable | Create vehicle alarm partition table by month
|(jt808_vehicle_alarm_TYPE_YYYYYMM)
| 3 | Proc_CreateAllAlarmMonthTable | Create all vehicle alarm partition tables
| 4 | Proc_CreateGpsMonthTable | Create vehicle GPS data partition table by month
| jt808_vehicle_gps_N_YYYYYMM
| 5 | Proc_CreateRunLogMonthTable | Create log table by month
| jt808_run_log_YYYYYMM
| 6 | Proc_CreateMediaMonthTable | Create a vehicle media log sheet on a monthly basis
| jt808_vehicle_media_YYYYYMM
| 7 | Proc_DropIndex | Delete index
| 8 | Proc_InsertColumn | Insert Field
| 9 | Proc_InsertIndex | Insert Index
| 10 | Proc_Set_DayPartition | Create table partitions by day (starting from day to day)
| 11 | Proc_Set_DayPartition_Pre | Create table partitions by day (back from day to day)
| 12 | Proc_Set_MonthPartition | Create table partitions by month (from month to month)
| 13 | Proc_Set_MonthPartition_Pre | Create table partitions by month (backward from month to month)
| 14 | Proc_Set_QuarterPartition | Create table partitions by quarter
b ) Event
| Serial | Name | Description
| - - - - | - - - - |
| 1 | Event_Create_AlarmMonthTable | Create alarm table
| 2 | Event_Create_GpsMonthTable | Create GPS table
| 3 | Event_Create_RunLogMonthTable | Create log table
| 4 | Event_Create_MediaMonthTable | Create media log table
