分享一个小的系统功能结构设计图以及基础数据表

最新推荐文章于 2024-06-19 10:48:03 发布
无言&老胡
最新推荐文章于 2024-06-19 10:48:03 发布
阅读量714
点赞数
文章标签： windows
本文链接：https://blog.csdn.net/hulonghe123/article/details/132211210
版权
分享一个小的系统功能结构设计图以及基础数据表：
在这里插入图片描述
SQL数据：
-- ----------------------------
-- Table structure for bn_alert_msg_log_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_alert_msg_log_tbl`;
CREATE TABLE `bn_alert_msg_log_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `kind` int(11) NULL DEFAULT NULL COMMENT '1预警 3报警',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `push_count` int(11) NULL DEFAULT NULL COMMENT '发布个数',
  `safe_count` int(11) NULL DEFAULT 0 COMMENT '确认数量',
  `danger_count` int(11) NULL DEFAULT 0 COMMENT '不安全数量',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT -1 COMMENT '-1未完成 1已完成 3废弃',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '所属二部门',
  `alert_msg_id` int(11) NULL DEFAULT NULL COMMENT '主键',
  `dep1_id` int(11) NULL DEFAULT NULL COMMENT '所属一级部门',
  `file_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5387 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '预警信息部门分发' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_alert_msg_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_alert_msg_tbl`;
CREATE TABLE `bn_alert_msg_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '预警标题',
  `kind` int(11) NULL DEFAULT NULL COMMENT '1预警 3报警',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '预警内容',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `dep1_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '对应的一级部门',
  `dep_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '二级部门数组',
  `file_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '文件',
  `alert_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '预警编号',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '预警类型',
  `dep_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '发布部门',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系电话',
  `is_send` int(11) NULL DEFAULT NULL COMMENT '1发送 2不发送',
  `dep_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '发布部门',
  `reviewer` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核人姓名',
  `dep_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
  `sms_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '短信发送内容',
  `edit_person` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编辑人',
  `is_examine` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '是否进行审核y审核 n不审核',
  `is_check` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核状态d待审核 y审核通过 n未审核',
  `depidstr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '部门JSON数据前端回显',
  `examine_id` int(11) NULL DEFAULT NULL COMMENT '审核人id',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 483 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '预警信息主体表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_disaster_report_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_disaster_report_tbl`;
CREATE TABLE `bn_disaster_report_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `report_time` datetime(0) NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
  `lat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
  `lng` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
  `area_id` int(11) NULL DEFAULT NULL COMMENT '区域（系统自动解析地址进行读取）',
  `level` int(11) NULL DEFAULT NULL COMMENT '灾害等级',
  `is_person_injured` int(11) NULL DEFAULT NULL COMMENT '人员是否受伤',
  `is_house_damage` int(11) NULL DEFAULT NULL COMMENT '是否房屋受损',
  `is_Infrastructure_damage` int(11) NULL DEFAULT NULL COMMENT '基础设施受损',
  `is_emergency_hedging` int(11) NULL DEFAULT NULL COMMENT '是否需要群众紧急避险',
  `is_rescue` int(11) NULL DEFAULT NULL COMMENT '是否需要救援',
  `kind` int(11) NULL DEFAULT NULL COMMENT '灾害类型(同situation.kind)',
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '描述',
  `accessories` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '文件类型 json list',
  `creator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '上报人名字',
  `creator_phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '上报人电话',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `creator` int(11) NULL DEFAULT NULL COMMENT '创建者',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `secondary_kind` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '次要灾害类型',
  `dep_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '部门名称',
  `dangerous_people_number` int(11) NULL DEFAULT NULL COMMENT '受灾总人数',
  `dangerous_death_number` int(11) NULL DEFAULT NULL COMMENT '死亡人数',
  `dangerous_sick_number` int(11) NULL DEFAULT NULL COMMENT '应灾伤病',
  `report_kind` int(11) NULL DEFAULT NULL COMMENT '1:灾情上报 3:险情上报',
  `number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编号',
  `state` int(11) NULL DEFAULT NULL COMMENT '1待处理 3已安排处理',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '乡村',
  `is_escalation` int(11) NULL DEFAULT NULL COMMENT '是否上报1 未上报 3 转入镇街',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 149 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '一键报警表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_emergency_place_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_emergency_place_tbl`;
CREATE TABLE `bn_emergency_place_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
  `lat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
  `lng` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '应急场所名称',
  `cover` int(11) NULL DEFAULT NULL COMMENT '封面',
  `r_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '负责人名字',
  `r_phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '负责人电话',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `creator` int(11) NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 1 COMMENT '1已激活 3废除',
  `person_count_info` int(11) NULL DEFAULT NULL COMMENT '人员容量',
  `house_count_info` int(11) NULL DEFAULT NULL COMMENT '户数容量',
  `kind` int(11) NULL DEFAULT NULL COMMENT '1.应急避难场所 3灾民集中安置点',
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '介绍',
  `used_capacity` int(11) NULL DEFAULT NULL COMMENT '已容量',
  `additional_capacity` int(11) NULL DEFAULT NULL COMMENT '还可容量',
  `areas` int(11) NULL DEFAULT NULL COMMENT '场所面积',
  `tent_count_info` int(11) NULL DEFAULT NULL COMMENT '帐篷容量',
  `tent_capacity` int(11) NULL DEFAULT NULL COMMENT '帐篷已容量',
  `tent_additional_capacity` int(11) NULL DEFAULT NULL COMMENT '帐篷还可容量',
  `accessories_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '图片、视频字符串拼接',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '部门外键',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急仓库表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_emergency_task_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_emergency_task_tbl`;
CREATE TABLE `bn_emergency_task_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  `notification_object` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'dep_jsonList',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '任务名称',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `contacts_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系人姓名',
  `contacts_phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系人电话',
  `type` int(11) NULL DEFAULT NULL COMMENT '1事发 3事中 5事后',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 274 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急预案任务（后台提前录入到对应部门启动时一键派发）' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_goods_account_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_goods_account_tbl`;
CREATE TABLE `bn_goods_account_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户姓名',
  `good_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `good_number` int(11) NULL DEFAULT NULL COMMENT '商品数量',
  `store_id` int(11) NULL DEFAULT NULL COMMENT '物资库id',
  `state` int(11) NULL DEFAULT NULL COMMENT '1入库 3出库',
  `good_unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '单位',
  `kind` int(11) NULL DEFAULT NULL COMMENT '出入库类型1：表示扫码 3：表示手动',
  `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '物资溯源',
  `original_inventory` int(11) NULL DEFAULT 0 COMMENT '原有数量',
  `hand_inventory` int(11) NULL DEFAULT 0 COMMENT '上次数量',
  `all_inventory` int(11) NULL DEFAULT 0 COMMENT '现存数量',
  `temp_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2588 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急物资台账统计' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_goods_code_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_goods_code_tbl`;
CREATE TABLE `bn_goods_code_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT -1 COMMENT '-1未入库 1入库完毕 3出库',
  `goods_temp_id` int(11) NULL DEFAULT NULL COMMENT '模板id',
  `store_id` int(11) NULL DEFAULT NULL COMMENT '仓库名称',
  `number` int(11) NULL DEFAULT NULL,
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户外键',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2828 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急仓库对应物资数量统计' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_goods_temp_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_goods_temp_tbl`;
CREATE TABLE `bn_goods_temp_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `kind` int(11) NULL DEFAULT NULL COMMENT '物资类别 1常备 3临时',
  `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '计量单位（米、把、个）',
  `goods_kind1` int(11) NULL DEFAULT NULL COMMENT '分类一级 1.抢险救援 3.生活救助',
  `goods_kind2` int(11) NULL DEFAULT NULL COMMENT '111防汛抗旱、112地震地灾、113森林防火、114其他  311帐篷、312床、313棉被、314棉衣、315食物、316其他',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 353 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急物资模板' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_monitor_center_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_monitor_center_tbl`;
CREATE TABLE `bn_monitor_center_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '监测中心表',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '监测描述',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '所属部门',
  `file_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '数据附件',
  `contact_phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系电话',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '监测名称',
  `contact_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系人姓名',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3251 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '检测中心' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_plan_basics_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_plan_basics_tbl`;
CREATE TABLE `bn_plan_basics_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `kind` int(11) NULL DEFAULT NULL COMMENT '1总体预案 3专项预案 5部门预案 9零时预案',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '预案内容',
  `accessory_id` int(11) NULL DEFAULT NULL COMMENT '附件',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `when_created` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急预案表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_plan_level_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_plan_level_tbl`;
CREATE TABLE `bn_plan_level_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类型名称',
  `parent_id` int(11) NULL DEFAULT NULL COMMENT '所属上级',
  `order_` int(11) NULL DEFAULT 1 COMMENT '排序',
  `plan_inventory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '预警类型清单内容',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '预警信息类别（包含类型所对应的清单内容）' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_plan_log_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_plan_log_tbl`;
CREATE TABLE `bn_plan_log_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `kind` int(11) NULL DEFAULT NULL COMMENT '1总体预案 3专项预案 5部门预案 9零时预案',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '任务内容',
  `accessory_id` int(11) NULL DEFAULT NULL COMMENT '附件',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `level` int(11) NULL DEFAULT NULL COMMENT '应急等级',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `task_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '任务编号',
  `file_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '附件JSON格式',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 259 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '派发任务表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_plan_report_feedback_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_plan_report_feedback_tbl`;
CREATE TABLE `bn_plan_report_feedback_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  `accessory_id` int(11) NULL DEFAULT NULL COMMENT '音频文件',
  `accessories_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '图片字符串拼接',
  `audio_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '音频多文件',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `reply` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '官方回复',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `plan_command_report_id` int(11) NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT -1 COMMENT '-1未处理 1已回复 3忽略',
  `reply_time` datetime(0) NULL DEFAULT NULL COMMENT '回复事件',
  `replyor_id` int(11) NULL DEFAULT NULL COMMENT '回复人员',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '任务总结',
  `creator_id` int(11) NULL DEFAULT NULL,
  `plan_report_id` int(11) NULL DEFAULT NULL COMMENT '回复任务外键',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '任务反馈表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_plan_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_plan_tbl`;
CREATE TABLE `bn_plan_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `kind` int(11) NULL DEFAULT NULL COMMENT '1总体预案 3专项预案 5部门预案 9零时预案',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '预案内容',
  `accessory_id` int(11) NULL DEFAULT NULL COMMENT '附件',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `level` int(11) NULL DEFAULT NULL COMMENT '预案等级',
  `task_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '预案任务JSON数据',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 99 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急预案' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_stoer_goods_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_stoer_goods_tbl`;
CREATE TABLE `bn_stoer_goods_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间=入库时间',
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `kind` int(11) NULL DEFAULT NULL COMMENT '物资类别',
  `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '计量单位（米、把、个）',
  `store_id` int(11) NULL DEFAULT NULL COMMENT '应急仓库id',
  `temp_id` int(11) NULL DEFAULT NULL COMMENT '模板id（用户判断是否添加）',
  `count` int(11) NULL DEFAULT NULL COMMENT '数量',
  `note` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
  `change_time` datetime(0) NULL DEFAULT NULL COMMENT '改变时间',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 327 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '仓库物资统计表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_storehouse_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_storehouse_tbl`;
CREATE TABLE `bn_storehouse_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
  `lat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
  `lng` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
  `area_id` int(11) NULL DEFAULT NULL COMMENT '区域（系统自动解析地址进行读取）生成后不进行修改',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物资仓库名称',
  `r_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人名字',
  `r_phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人电话',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `creator` int(11) NULL DEFAULT NULL COMMENT '管理人（默认创建人为管理人员）',
  `state` int(11) NULL DEFAULT 1 COMMENT '1启用 3关闭（只有关闭、且库存清空的仓库才能删除）',
  `type` int(11) NULL DEFAULT NULL COMMENT '1常备 2库点 3临时',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '物资所属部门',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急仓库表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_team_attendance_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_team_attendance_tbl`;
CREATE TABLE `bn_team_attendance_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '队伍名称',
  `captain` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '队长姓名',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '带队人电话',
  `gps_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'gps编码',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态 1出勤 3归队',
  `person_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '出勤人数',
  `return_time` datetime(0) NULL DEFAULT NULL COMMENT '归队时间',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '出勤理由',
  `team_id` int(11) NULL DEFAULT NULL COMMENT '队伍id',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急队伍（出勤）表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_team_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_team_tbl`;
CREATE TABLE `bn_team_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `version` int(11) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `captain` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '队长',
  `type` int(11) NULL DEFAULT NULL COMMENT '1.常备 3.外来',
  `kind` int(11) NULL DEFAULT NULL COMMENT '1综合救援、3行业专业、5乡镇常备、7社会力量',
  `c_phone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `number_count` int(11) NULL DEFAULT NULL COMMENT '队员数量',
  `care_info` int(11) NULL DEFAULT NULL COMMENT '运输车辆数量',
  `care_info2` int(11) NULL DEFAULT NULL COMMENT '抢险设备数量',
  `number_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'jsonList {name,phone}',
  `support_kind` int(11) NULL DEFAULT NULL COMMENT '灾害类型(同situation.kind)',
  `area` int(11) NULL DEFAULT NULL COMMENT '区域',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
  `lat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
  `lng` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '维度',
  `creator` int(11) NULL DEFAULT NULL COMMENT '队伍申请人',
  `applay_type` int(11) NULL DEFAULT NULL COMMENT '申请状态 -1未处 1通过 3驳回  5离场申请中 7离场',
  `accessory_id` int(11) NULL DEFAULT NULL COMMENT '微信群二维码（零时队伍）',
  `adept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '擅长',
  `task_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支援事件',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '备注',
  `location_type` int(11) NULL DEFAULT 1 COMMENT '1手动定位 3自动定位',
  `captain_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '队长姓名',
  `captain_phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '队长电话',
  `stree_id` int(11) NULL DEFAULT NULL COMMENT '所属镇街',
  `state` int(11) NULL DEFAULT NULL COMMENT '1将到 3到达',
  `y_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '将到时间',
  `d_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '到达时间',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '部门id',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 140 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '应急队伍表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_user_alert_msg_log_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_user_alert_msg_log_tbl`;
CREATE TABLE `bn_user_alert_msg_log_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `alert_msg_log_id` int(11) NULL DEFAULT NULL COMMENT '发放任务id',
  `state` int(11) NULL DEFAULT -1 COMMENT '-1未开始 1平安 3异常 ',
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '异常详情',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '所属的二级部门（废弃没用）',
  `kind` int(11) NULL DEFAULT NULL COMMENT '1预警 3报警',
  `dep1_id` int(11) NULL DEFAULT NULL COMMENT '一级部门',
  `file_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  `alert_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编号',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '预警类型',
  `sep_id` int(11) NULL DEFAULT NULL COMMENT '发布部门',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系电话',
  `is_send` int(11) NULL DEFAULT NULL COMMENT '1发送 2不发送',
  `wechat_forward` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '转发多少次数',
  `dep_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '预警类型',
  `reviewer` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核人',
  `belong_id` int(11) NULL DEFAULT NULL COMMENT '所属部门',
  `all_countryside` int(11) NULL DEFAULT NULL,
  `forword_countryside` int(11) NULL DEFAULT NULL,
  `zj_enterprises_institutions` int(11) NULL DEFAULT NULL,
  `all_group` int(11) NULL DEFAULT NULL,
  `all_person` int(11) NULL DEFAULT NULL,
  `forword_group` int(11) NULL DEFAULT NULL,
  `forword_person` int(11) NULL DEFAULT NULL,
  `dep_enterprises_institutions` int(11) NULL DEFAULT NULL,
  `dep_all_person` int(11) NULL DEFAULT NULL,
  `edit_person` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编辑人',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `role_kind` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '部门角色',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 84734 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '预警信息个人分发' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_user_apply_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_user_apply_tbl`;
CREATE TABLE `bn_user_apply_tbl`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '申请人姓名',
  `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请人电话号码',
  `kind` int(11) NULL DEFAULT NULL COMMENT '权限角色',
  `dep_id` int(11) NULL DEFAULT NULL COMMENT '申请人部门',
  `postion` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位',
  `stree_id` int(11) NULL DEFAULT 0 COMMENT '申请街道',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `state` int(11) NULL DEFAULT NULL COMMENT '1待审批 3审批未通过 4镇街审批通过 5审批通过',
  `version` int(11) NULL DEFAULT NULL COMMENT '版本号',
  `when_created` timestamp(0) NULL DEFAULT NULL COMMENT '时间戳',
  `belong_id` int(11) NULL DEFAULT NULL COMMENT '所属审批Id',
  `belong_up_id` int(11) NULL DEFAULT NULL COMMENT '所属上级审批',
  `deleted` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'n',
  `number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 962 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户申请角色权限表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for bn_work_order_tbl
-- ----------------------------
DROP TABLE IF EXISTS `bn_work_order_tbl`;
CREATE TABLE `bn_work_order_tbl`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '互动标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '互动内容',
  `accessories_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '附件JSON格式',
  `deleted` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'n',
  `version` int(11) NULL DEFAULT NULL,
  `reply` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '官方回复',
  `when_created` timestamp(0) NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT -1 COMMENT '-1未处理 1已处理 3待办',
  `reply_time` datetime(0) NULL DEFAULT NULL COMMENT '回复事件',
  `replyor_id` int(11) NULL DEFAULT NULL COMMENT '回复人员',
  `creator_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '互动中心表（包含反馈）' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;