DROP TABLE IF EXISTS `roadcondition_unit`;
CREATE TABLE `roadcondition_unit`
(
    `unit_id`   varchar(20) NOT NULL COMMENT '单位ID',
    `unit_name` varchar(20) DEFAULT NULL COMMENT '单位名称',
    PRIMARY KEY (`unit_id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='路况管养单位表';

DROP TABLE IF EXISTS `roadcondition_emergencyevent`;
CREATE TABLE `roadcondition_emergencyevent`
(
    `dept_id` int(20) NOT NULL COMMENT '部门ID',
    `unit_id` varchar(20) DEFAULT NULL COMMENT '单位ID'
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='路况事件_紧急事件对应权限表';

DROP TABLE IF EXISTS `roadcondition_emergency`;
CREATE TABLE `roadcondition_emergency` (
                                           `event_id` varchar(30) NOT NULL,
                                           `emergency_event_id` varchar(30) NOT NULL,
                                           PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='路况事件_应急事件对应事件表';