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)
)
;