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='路况事件_紧急事件对应权限表';
