CREATE TABLE IF NOT EXISTS POSITION_STATISTIC
(
   MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
   DAY BIGINT NOT NULL COMMENT '当天0点秒值',
   ADDRESS VARCHAR(64) NOT NULL COMMENT '城市地址',
   ADDR_COUNT INTEGER NULL COMMENT '车辆在城市停留的次数',
   LONGTITUDE_NORTH VARCHAR(50) NULL COMMENT '经度-最北',
   LATITUDE_NORTH VARCHAR(50) NULL COMMENT '纬度-最北',
   LONGTITUDE_SOUTH VARCHAR(50) NULL COMMENT '经度-最南',
   LATITUDE_SOUTH VARCHAR(50) NULL COMMENT '纬度-最南',
   LONGTITUDE_EAST VARCHAR(50) NULL COMMENT '经度-最东',
   LATITUDE_EAST VARCHAR(50) NULL COMMENT '纬度-最东',
   LONGTITUDE_WEST VARCHAR(50) NULL COMMENT '经度-最西',
   LATITUDE_WEST VARCHAR(50) NULL COMMENT '纬度-最西',
   CONSTRAINT PK PRIMARY KEY(MONITOR_ID,DAY,ADDRESS)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '城市轨迹信息月分布图统计表'
