/*
Navicat Premium Data Transfer
Source Server : 本地连接
Source Server Type : MySQL
Source Server Version : 80013
Source Host : localhost:3306
Source Schema : mybatis_ssm
Target Server Type : MySQL
Target Server Version : 80013
File Encoding : 65001
Date: 17/07/2022 23:31:45
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_oa_meeting_audit
-- ----------------------------
DROP TABLE IF EXISTS `t_oa_meeting_audit`;
CREATE TABLE `t_oa_meeting_audit` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键,唯一标识',
`meetingId` bigint(11) NOT NULL COMMENT '外键,会议编号',
`auditor` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '审批人',
`sign` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审批签字',
`createdate` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '审批时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议审批信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_oa_meeting_audit
-- ----------------------------
INSERT INTO `t_oa_meeting_audit` VALUES (1, 1, '2', '/sign/3ad14be2bd9f41aeaf99dee462eb9996.jpg', '2022-02-28 12:00:56');
INSERT INTO `t_oa_meeting_audit` VALUES (2, 2, '2', '/sign/76c3c5706b464ea39dd1805e6f190e28.jpg', '2022-03-08 20:14:40');
INSERT INTO `t_oa_meeting_audit` VALUES (3, 5, '1', '/sign/a3f5a9c4d2bb4decab5a747e9bf5f81c.jpg', '2022-03-20 15:59:55');
INSERT INTO `t_oa_meeting_audit` VALUES (4, 7, '1', '/sign/8485957e1cf04c2da2afe2ddbe9007d7.jpg', '2022-03-20 18:53:42');
INSERT INTO `t_oa_meeting_audit` VALUES (5, 9, '1', '/sign/ea621277733944508c89aa0cfb64887d.jpg', '2022-03-21 00:23:59');
INSERT INTO `t_oa_meeting_audit` VALUES (6, 10, '1', '/sign/5c4c1c8d1a124489990eee7c4754fac3.jpg', '2022-03-21 14:33:39');
INSERT INTO `t_oa_meeting_audit` VALUES (7, 12, '2', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAiYAAACWCAYAAADqm0MaAAAHwklEQVR4Xu3WsW1DQQwFQalDJ+7SgFu0GnCifQEBjdIPEqe5C/b58CNAgAABAgQIHBF4HjmHYxAgQIAAAQIEHsLEIyBAgAABAgTOCAiTM1fhIAQIECBAgIAw8QYIECBAgACBMwLC5MxVOAgBAgQIECAgTLwBAgQIECBA4IyAMDlzFQ5CgAABAgQICBNvgAABAgQIEDgjIEzOXIWDECBAgAABAsLEGyBAgAABAgTOCAiTM1fhIAQIECBAgIAw8QYIECBAgACBMwLC5MxVOAgBAgQIECAgTLwBAgQIECBA4IyAMDlzFQ5CgAABAgQICBNvgAABAgQIEDgjIEzOXIWDECBAgAABAsLEGyBAgAABAgTOCAiTM1fhIAQIECBAgIAw8QYIECBAgACBMwLC5MxVOAgBAgQIECAgTLwBAgQIECBA4IyAMDlzFQ5CgAABAgQICBNvgAABAgQIEDgjIEzOXIWDECBAgAABAsLEGyBAgAABAgTOCAiTM1fhIAQIECBAgIAw8QYIECBAgACBMwLC5MxVOAgBAgQIECAgTLwBAgQIECBA4IyAMDlzFQ5CgAABAgQICBNvgAABAgQIEDgjIEzOXIWDECBAgAABAsLEGyBAgAABAgTOCAiTM1fhIAQIECBAgIAw8QYIECBAgACBMwLC5MxVOAgBAgQIECAgTLwBAgQIECBA4IyAMDlzFQ5CgAABAgQICBNvgAABAgQIEDgjIEzOXIWDECBAgAABAsLEGyBAgAABAgTOCAiTM1fhIAQIECBAgIAw8QYI/C/w+/r0FYF+XvPfcYdxAgQIfIyAMPmYq/ZH3xAQJm+gGSFAgEARECZFzywBAgQIECAwFRAmU07LCBAgQIAAgSIgTIqeWQIECBAgQGAqIEymnJYRIECAAAECRUCYFD2zBAgQIECAwFRAmEw5LSNAgAABAgSKgDApemYJECBAgACBqYAwmXJaRoAAAQIECBQBYVL0zBIgQIAAAQJTAWEy5bSMAAECBAgQKALCpOiZJUCAAAECBKYCwmTKaRkBAgQIECBQBIRJ0TNLgAABAgQITAWEyZTTMgIECBAgQKAICJOiZ5YAAQIECBCYCgiTKadlBAgQIECAQBEQJkXPLAECBAgQIDAVECZTTssIECBAgACBIiBMip5ZAgQIECBAYCogTKaclhEgQIAAAQJFQJgUPbMECBAgQIDAVECYTDktI0CAAAECBIqAMCl6ZgkQIECAAIGpgDCZclpGgAABAgQIFAFhUvTMEiBAgAABAlMBYTLltIwAAQIECBAoAsKk6JklQIAAAQIEpgLCZMppGQECBAgQIFAEhEnRM0uAAAECBAhMBYTJlNMyAgQIECBAoAgIk6JnlgABAgQIEJgKCJMpp2UECBAgQIBAERAmRc8sAQIECBAgMBUQJlNOywgQIECAAIEiIEyKnlkCBAgQIEBgKiBMppyWESBAgAABAkVAmBQ9swQIECBAgMBUQJhMOS0jQIAAAQIEioAwKXpmCRAgQIAAgamAMJlyWkaAAAECBAgUAWFS9MwSIECAAAECUwFhMuW0jAABAgQIECgCwqTomSVAgAABAgSmAsJkymkZAQIECBAgUASESdEzS4AAAQIECEwFhMmU0zICBAgQIECgCAiTomeWAAECBAgQmAoIkymnZQQIECBAgEARECZFzywBAgQIECAwFRAmU07LCBAgQIAAgSIgTIqeWQIECBAgQGAqIEymnJYRIECAAAECRUCYFD2zBAgQIECAwFRAmEw5LSNAgAABAgSKgDApemYJECBAgACBqYAwmXJaRoAAAQIECBQBYVL0zBIgQIAAAQJTAWEy5bSMAAECBAgQKALCpOiZJUCAAAECBKYCwmTKaRkBAgQIECBQBIRJ0TNLgAABAgQITAWEyZTTMgIECBAgQKAICJOiZ5YAAQIECBCYCgiTKadlBAgQIECAQBEQJkXPLAECBAgQIDAVECZTTssIECBAgACBIiBMip5ZAgQIECBAYCogTKaclhEgQIAAAQJFQJgUPbMECBAgQIDAVECYTDktI0CAAAECBIqAMCl6ZgkQIECAAIGpgDCZclpGgAABAgQIFAFhUvTMEiBAgAABAlMBYTLltIwAAQIECBAoAsKk6JklQIAAAQIEpgLCZMppGQECBAgQIFAEhEnRM0uAAAECBAhMBYTJlNMyAgQIECBAoAgIk6JnlgABAgQIEJgKCJMpp2UECBAgQIBAERAmRc8sAQIECBAgMBUQJlNOywgQIECAAIEiIEyKnlkCBAgQIEBgKiBMppyWESBAgAABAkVAmBQ9swQIECBAgMBUQJhMOS0jQIAAAQIEioAwKXpmCRAgQIAAgamAMJlyWkaAAAECBAgUAWFS9MwSIECAAAECUwFhMuW0jAABAgQIECgCwqTomSVAgAABAgSmAsJkymkZAQIECBAgUASESdEzS4AAAQIECEwFhMmU0zICBAgQIECgCAiTomeWAAECBAgQmAoIkymnZQQIECBAgEARECZFzywBAgQIECAwFRAmU07LCBAgQIAAgSIgTIqeWQIECBAgQGAqIEymnJYRIECAAAECRUCYFD2zBAgQIECAwFRAmEw5LSNAgAABAgSKgDApemYJECBAgACBqYAwmXJaRoAAAQIECBSBP3TaBJd1AhMBAAAAAElFTkSuQmCC', NULL);
INSERT INTO `t_oa_meeting_audit` VALUES (8, 13, '1', '/test_layui/upload/sign/f84f9f214e86478ba4022b17457f5999.jpg', NULL);
INSERT INTO `t_oa_meeting_audit` VALUES (9, 13, '1', '/test_layui/upload/sign/79528da56ebc40509dd327145526b5b0.jpg', '2022-07-16 19:33:23');
-- ----------------------------
-- Table structure for t_oa_meeting_feedback
-- ----------------------------
DROP TABLE IF EXISTS `t_oa_meeting_feedback`;
CREATE TABLE `t_oa_meeting_feedback` (
`id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键,唯一标识',
`meetingId` bigint(11) NOT NULL COMMENT '外键,会议编号',
`personType` int(2) NOT NULL COMMENT '人员类别:1参会2列席',
`personId` bigint(11) NOT NULL COMMENT '人员ID',
`result` int(2) NOT NULL COMMENT '反馈结果:1参加0不参加',
`reason` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不参与会议的原因',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会议通知反馈表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_oa_meeting_feedback
-- ----------------------------
INSERT INTO `t_oa_meeting_feedback` VALUES ('0462ee5cc0aa4c06b4169e768d058227', 1, 1, 2, 1, '11111');
INSERT INTO `t_oa_meeting_feedback` VALUES ('1377914d74254d489598cf400604640d', 2, 2, 2, 1, '规划局');
INSERT INTO `t_oa_meeting_feedback` VALUES ('27c0cee6aee4483dafa015d8f7e8fefd', 10, 1, 1, 1, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('6660ab06c3c148a3ba0cb7f6479d9160', 7, 1, 1, 1, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('69ddadab8997492eb5a4e2bcd4874bcb', 5, 2, 1, 2, 'shengbin');
INSERT INTO `t_oa_meeting_feedback` VALUES ('74d54c231def4525a0fe517cc679b421', 5, 2, 3, 2, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('8a6e312baebb411f94011961fbf37d11', 10, 2, 2, 1, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('9e17f56448da41559f7a9129014dbe8b', 5, 1, 1, 1, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('a5035340b9fd4521b2c3917e7c65b9ec', 9, 1, 1, 1, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('dbd15a664dc541fb96d02e5ee030ec3a', 5, 2, 4, 1, '');
INSERT INTO `t_oa_meeting_feedback` VALUES ('ddd78b0148204f08b80914d9f652e2b7', 10, 1, 3, 2, '家里有事');
INSERT INTO `t_oa_meeting_feedback` VALUES ('f65d94e5ec2e4bd6ba4c1ab0f4f5a1b4', 5, 2, 2, 1, '');
-- ----------------------------
-- Table structure for t_oa_meeting_info
-- ----------------------------
DROP TABLE IF EXISTS `t_oa_meeting_info`;
CREATE TABLE `t_oa_meeting_info` (
`id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键,唯一标识',
`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '会议标题',
`content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '会议内容',
`canyuze` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '参与人员',
`liexize` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列席人员',
`zh