CREATE TABLE IF NOT EXISTS VIOLATIONS_ALARM (
  MONITOR_ID VARCHAR(40) NOT NULL,
  ALARM_START_TIME BIGINT NOT NULL,
  ALARM_TYPE INTEGER NOT NULL,
  DRIVER_ID VARCHAR(40) NULL,
  MONITOR_NAME VARCHAR(32) NULL,
  DRIVER_NAME VARCHAR(32) NULL,
  DRIVER_NUMBER VARCHAR(20) NULL,
  DRIVER_ORG_ID VARCHAR(40) NULL,
  VEHICLE_TYPE VARCHAR(20) NULL,
  MONITOR_ORG_NAME VARCHAR(32) NULL,
  ALARM_NAME VARCHAR(32) NULL,
  ALARM_END_TIME BIGINT NULL,
  MILEAGE DOUBLE NULL,
  CONSTRAINT PK PRIMARY KEY (MONITOR_ID, ALARM_START_TIME, ALARM_TYPE)
)
ENGINE = INNODB
CHARACTER SET = UTF8
COLLATE = UTF8_GENERAL_CI
ROW_FORMAT = DYNAMIC
COMMENT '违规行为识别及报警表'