CREATE TABLE ALARM_HANDLE ( ID varchar null, PLATE_NUMBER varchar null, ASSIGNMENT_NAME varchar null, PROFESSIONALS_NAME varchar null, ALARM_TYPE integer not null, ALARM_START_TIME BIGINT not null, ALARM_END_TIME BIGINT, ALARM_START_LOCATION varchar null, ALARM_END_LOCATION varchar null, ALARM_SOURCE integer null, SPEED varchar null, ANGLE varchar null, POSITIONAL_ID varchar null, PERSON_ID varchar null, PERSON_NAME varchar null, HANDLE_TIME BIGINT, STATUS integer, HANDLE_TYPE varchar null, DESCRIPTION varchar null, HEIGHT varchar null, RECORDER_SPEED varchar null, FENCE_TYPE varchar null, FENCE_NAME varchar null, MONITOR_TYPE integer null, PROTOCOL_TYPE integer null, SWIFT_NUMBER VARCHAR NULL, VEHICLE_ID binary(16) not NULL, PUSH_TYPE integer null, CAL_STANDARD INTEGER NULL, SPEED_TYPE INTEGER NULL CONSTRAINT PK PRIMARY KEY (ALARM_TYPE,ALARM_START_TIME,VEHICLE_ID) ) SALT_BUCKETS = 48 ; CREATE TABLE BUSINESS_AREAS ( ID varchar not null, POSITION_INFO_ID varchar null, BUSINESS_ID varchar null, NAME varchar null, LOCATION varchar null, CONSTRAINT PK PRIMARY KEY (ID)); CREATE TABLE INTEGRATED_STATISTICS ( ID varchar null, VEHICLE_ID varchar not null, PLATE_NUMBER varchar null, GPS_MILE DOUBLE, TRAVEL_TIME BIGINT, DOWN_TIME BIGINT, OVER_SPEED_TIMES BIGINT, TRAVEL_TIMES BIGINT, ALARM_TIMES BIGINT, NIGHT_TRAVEL_MILE DOUBLE, DAY_TIME BIGINT not null, CONSTRAINT PK PRIMARY KEY (VEHICLE_ID,DAY_TIME) ) ; CREATE TABLE POSITIONAL ( ID varchar null, VEHICLE_ID binary(16) not null, DEVICE_NUMBER varchar, SIM_CARD varchar null, ASSIGNMENT_NAME varchar null, VTIME BIGINT not null, ALARM varchar null, STATUS varchar null, LONGTITUDE varchar null, LATITUDE varchar null, ADDRESS varchar null, HEIGHT varchar null, RECORDER_SPEED varchar null, SPEED varchar null, ANGLE varchar null, TEMPERTURE varchar null, RESERVE varchar null, GPS_MILE varchar null, DEVICE_ID_ONE varchar null, DEVICE_ID_TWO varchar null, MESSAGE_LENGTH_ONE varchar null, MESSAGE_LENGTH_TWO varchar null, TOTAL_OILWEAR_ONE varchar null, TOTAL_OILWEAR_TWO varchar null, OILTANK_TEMPERATURE_ONE varchar null, OILTANK_TEMPERATURE_TWO varchar null, TRANSIENT_OILWEAR_ONE varchar null, TRANSIENT_OILWEAR_TWO varchar null, TOTAL_TIME_ONE varchar null, TOTAL_TIME_TWO varchar null, PLATE_NUMBER varchar null, VEHICLE_TYPE varchar null, FUEL_TYPE varchar null, AIR_CONDITION_STATUS varchar null, SATELLITE_NUMBER varchar null, OIL_TANK_ID_ONE varchar null, OIL_TANK_ID_TWO varchar null, OIL_TANK_MSG_LENGTH_ONE varchar null, OIL_TANK_MSG_LENGTH_TWO varchar null, FUEL_TEM_ONE varchar null, FUEL_TEM_TWO varchar null, ENVIRONMENT_TEM_ONE varchar null, ENVIRONMENT_TEM_TWO varchar null, FUEL_AMOUNT_ONE varchar null, FUEL_AMOUNT_TWO varchar null, FUEL_SPILL_ONE varchar null, FUEL_SPILL_TWO varchar null, OIL_TANK_ONE varchar null, OIL_TANK_TWO varchar null, AD_HEIGHT_ONE varchar null, OIL_HEIGHT_ONE varchar null, AD_HEIGHT_TWO varchar null, OIL_HEIGHT_TWO varchar null, MILEAGE_SPEED DOUBLE NULL, MILEAGE_TOTAL DOUBLE NULL, WINCH_STATUS INTEGER NULL, WINCH_ORIENTATION INTEGER NULL, WINCH_SPEED INTEGER NULL, WINCH_TIME INTEGER NULL, WINCH_COUNTER INTEGER NULL, WINCH_ROTATE_TIME INTEGER NULL, TEMP_VALUE_ONE INTEGER NULL, TEMP_TIME_ONE INTEGER NULL, TEMP_HIGH_LOW_ONE INTEGER NULL, TEMP_VALUE_TWO INTEGER NULL, TEMP_TIME_TWO INTEGER NULL, TEMP_HIGH_LOW_TWO INTEGER NULL, TEMP_VALUE_THREE INTEGER NULL, TEMP_TIME_THREE INTEGER NULL, TEMP_HIGH_LOW_THREE INTEGER NULL, TEMP_VALUE_FOUR INTEGER NULL, TEMP_TIME_FOUR INTEGER NULL, TEMP_HIGH_LOW_FOUR INTEGER NULL, TEMP_VALUE_FIVE INTEGER NULL, TEMP_TIME_FIVE INTEGER NULL, TEMP_HIGH_LOW_FIVE INTEGER NULL, WETNESS_VALUE_ONE INTEGER NULL, WETNESS_TIME_ONE INTEGER NULL, WETNESS_HIGH_LOW_ONE INTEGER NULL, WETNESS_VALUE_TWO INTEGER NULL, WETNESS_TIME_TWO INTEGER NULL, WETNESS_HIGH_LOW_TWO INTEGER NULL, WETNESS_VALUE_THREE INTEGER NULL, WETNESS_TIME_THREE INTEGER NULL, WETNESS_HIGH_LOW_THREE INTEGER NULL, WETNESS_VALUE_FOUR INTEGER NULL, WETNESS_TIME_FOUR INTEGER NULL, WETNESS_HIGH_LOW_FOUR INTEGER NULL, UPLOAD_TIME VARCHAR NULL, BATTERY_ELECTRICITY INTEGER NULL, BATTERY_VOLTAGE INTEGER NULL, SIGNAL_STRENGTH INTEGER NULL, TERMINAL_VERSION VARCHAR NULL, LOCATION_TYPE INTEGER NULL, ABNORMITY_STATUS INTEGER NULL, ABNORMITY_TYPE INTEGER NULL, ABNORMITY_LEVEL INTEGER NULL, ABNORMITY_FATIGUE_TIME INTEGER NULL, ABNORMITY_MEDIA_TOTAL INTEGER NULL, ABNORMITY_MEDIA_INFO VARCHAR NULL, DRIVER_STATUS INTEGER NULL, DRIVER_TYPE INTEGER NULL, DRIVER_LEVEL INTEGER NULL, DRIVER_MEDIA_TOTAL INTEGER NULL, DRIVER_RESERVE_VALUE INTEGER NULL, DRIVER_MEDIA_INFO VARCHAR NULL, AIR_COMP_STATUS INTEGER NULL, ORIGINAL_LONGTITUDE VARCHAR NULL, ORIGINAL_LATITUDE VARCHAR NULL, ROAD_MARKINGS_TYPE INTEGER NULL, ROAD_MARKINGS_DATA INTEGER NULL, LIMITING_VELOCITY INTEGER NULL, IO_ONE INTEGER NULL, IO_TWO INTEGER NULL, IO_THREE INTEGER NULL, IO_FOUR INTEGER NULL, SIGNAL_STATE BIGINT NULL CONSTRAINT PK PRIMARY KEY (VEHICLE_ID,VTIME) ) SALT_BUCKETS = 255,COMPRESSION='GZ' ; CREATE TABLE POSITION_INFO ( ID varchar null, LONGTITUDE varchar not null, LATITUDE varchar not null, ADCODE varchar null, BUILDING varchar null, BUILDING_TYPE varchar null, CITY varchar null, CITY_CODE varchar null, DISTRICT varchar null, NEIGHBORHOOD varchar null, NEIGHBORHOOD_TYPE varchar null, PROVINCE varchar null, STREET varchar null, STREET_NUMBER varchar null, TOWNSHIP varchar null, CROSSES varchar null, FORMATTED_ADDRESS varchar null, POIS varchar null, ROADS varchar null, CONSTRAINT PK PRIMARY KEY (LONGTITUDE,LATITUDE) ) ; CREATE TABLE POSITION_STATISTIC ( VEHICLE_ID varchar not null, ADDRESS varchar not null, ADDR_COUNT integer, LONGTITUDE_NORTH varchar null, LATITUDE_NORTH varchar null, LONGTITUDE_SOUTH varchar null, LATITUDE_SOUTH varchar null, LONGTITUDE_EAST varchar null, LATITUDE_EAST varchar null, LONGTITUDE_WEST varchar null, LATITUDE_WEST varchar null, CONSTRAINT PK PRIMARY KEY (VEHICLE_ID,ADDRESS) ) ; CREATE TABLE WORK_HOURS ( ID varchar null, BRAND varchar not null, VTIME BIGINT not null, VEHICLE_ID varchar null, ASSIGNMENT_ID varchar null, TEAM varchar null, LONGTITUDE varchar null, LATITUDE varchar null, RATE varchar null, DURATION varchar null, STATUS varchar null, POSITION varchar null, CONSTRAINT PK PRIMARY KEY (BRAND,VTIME) ) ; CREATE TABLE BDTD_POSITION ( ID varchar null, PEOPLE_ID varchar not null, ALTITUDE varchar null, BATTERY_VOLTAGE varchar null, SIGNAL_STRENGTH varchar null, BEARING varchar null, LATITUDE varchar null, LONGITUDE_HEMISPHERE varchar null, LOCATION_TYPE varchar null, PROTOCOL_TYPE varchar null, SATELLITES_NUMBER varchar null, USER_CODE varchar null, SPEED varchar null, VTIME BIGINT not null, LATITUDE_HEMISPHERE varchar null, LONGITUDE varchar null, MONITOR_OBJECT varchar null, GROUP_NAME varchar null, IMEI varchar null, SIM_CARD varchar null, ADDRESS varchar null CONSTRAINT PK PRIMARY KEY (PEOPLE_ID,VTIME) ) ;