CREATE TABLE IF NOT EXISTS STOPPED_REPORT
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
MONITOR_NAME VARCHAR(64) NULL COMMENT '监控对象名称',
ASSIGNMENT_NAME VARCHAR(1000) NULL COMMENT '分组名称',
EMPLOYEE VARCHAR(64) NULL COMMENT '从业人员名称',
PHONE BIGINT NULL COMMENT '电话',
STOP_TIME BIGINT NULL COMMENT '停止时长',
STOP_NUM INTEGER NULL COMMENT '停止次数',
STOP_LOCATION VARCHAR(64) NULL COMMENT '停止位置',
STOP_MILE DOUBLE NULL COMMENT '停止里程',

SENSOR_FLAG INTEGER NULL COMMENT '是否绑定传感器标识 0：终端 1：里程传感器',
DEVICE_STOP_MILE DOUBLE NULL COMMENT '终端停止里程',
DEVICE_STOP_TIME BIGINT NULL COMMENT '终端停止时长',
DEVICE_STOP_NUM INTEGER NULL COMMENT '终端停止次数',
DEVICE_STOP_LOCATION VARCHAR(64) NULL COMMENT '终端停止位置',
SENSOR_STOP_MILE DOUBLE NULL COMMENT '传感器停止里程',
SENSOR_STOP_TIME BIGINT NULL COMMENT '传感器停止时长',
SENSOR_STOP_NUM INTEGER NULL COMMENT '传感器停止次数',
SENSOR_STOP_LOCATION VARCHAR(64) NULL COMMENT '传感器停止位置',

CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '停止报表'
