c-zhouhf1/zhgh_neu_java
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
zhgh_neu_java/docker/sql/gh-teachermeet.sql
T
c-zhouhf1 c7e76e98ab first commit
2026-09-08 20:09:15 +08:00

656 lines
66 KiB
SQL
Raw Permalink Blame History

/*
Navicat Premium Data Transfer
Source Server : 203
Source Server Type : MySQL
Source Server Version : 80021
Source Host : 192.168.21.203:3306
Source Schema : ry-jdh
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 21/03/2023 15:39:50
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for audit_state
-- ----------------------------
DROP TABLE IF EXISTS `audit_state`;
CREATE TABLE `audit_state` (
`stateId` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
`stateName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态名',
`stateColor` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '强调色',
`module` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '隶属(***模块)',
`afterStateId` int NULL DEFAULT NULL COMMENT '下个审核节点代码',
`afterPassStateId` int NULL DEFAULT NULL COMMENT '通过下个审核节点代码',
`afterRejectStateId` int NULL DEFAULT NULL COMMENT '拒绝后下个节点代码',
`meetingTypeId` int NULL DEFAULT NULL COMMENT '会议类型id 属于那个会议类型的流程',
`stateAuditType` int NULL DEFAULT NULL COMMENT '会议审核类型',
`matchCnd` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核人员匹配条件',
PRIMARY KEY (`stateId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2631 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of audit_state
-- ----------------------------
INSERT INTO `audit_state` VALUES (10, '待院级工会审核', '#1890ff', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (15, '院级工会审核不通过', '#F56C6C', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (20, '待校工会审核', '#1890ff', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (25, '校工会审核不通过', '#F56C6C', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (30, '正式会员', '#67C23A', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (50, '待院级工会审核', '#1890ff', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (55, '院级工会审核不通过', '#F56C6C', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (60, '待校工会审核', '#1890ff', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (65, '校工会审核不通过', '#F56C6C', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (70, '变更成功', '#67C23A', 'member', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (100, '待院级工会审核', '#1890ff', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (150, '院级工会不通过', '#F56C6C', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (200, '待校工会审核', '#1890ff', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (250, '校工会不通过', '#F56C6C', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (300, '待校工会副主席审核', '#1890ff', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (350, '校工会副主席不通过', '#F56C6C', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (400, '校工会常务副主席审核', '#1890ff', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (450, '校工会常务副主席不通过', '#F56C6C', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (500, '通过', '#67C23A', 'difficult', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1000, '待校工会审核', '#1890ff', 'welfareMember', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1050, '校工会审核不通过', '#F56C6C', 'welfareMember', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1100, '正式会员', '#67C23A', 'welfareMember', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1200, '待校工会审核', '#1890ff', 'unioncadre', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1250, '校工会审核不通过', '#F56C6C', 'unioncadre', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1300, '审核通过', '#67C23A', 'unioncadre', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1500, '待单位审核', '#1890ff', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1550, '单位审核不通过', '#F56C6C', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1600, '待院级工会审核', '#1890ff', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1650, '院级工会不通过', '#F56C6C', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1700, '待院级党组织审核', '#1890ff', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1750, '院级党组织不通过', '#F56C6C', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1800, '待校工会审核', '#1890ff', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1850, '校工会审核不通过', '#F56C6C', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (1900, '申请成功', '#67C23A', 'honor', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2000, '未预约', '#67C23A', 'psychology', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2100, '预约中', '#67C23A', 'psychology', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2200, '预约失败', '#67C23A', 'psychology', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2300, '预约成功', '#67C23A', 'psychology', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2500, '待提交', '#67C23A', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2510, '待分工会审核', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2515, '分工会审核不通过', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2520, '分工会退回修改', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2550, '待校工会审核', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2555, '校工会审核不通过', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2560, '校工会退回修改', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2570, '通过', '#1890ff', 'Manuscript', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `audit_state` VALUES (2580, '待院级工会女工委员审核', NULL, 'infantRoom', NULL, 2600, 2590, 1, 0, 'null');
INSERT INTO `audit_state` VALUES (2590, '待院级工会女工委员审核拒绝', NULL, 'infantRoom', NULL, NULL, NULL, 1, 1, 'null');
INSERT INTO `audit_state` VALUES (2600, '待校工会审核', NULL, 'infantRoom', NULL, 2610, 2620, 1, 0, 'null');
INSERT INTO `audit_state` VALUES (2610, '待校工会审核通过', '#1890ff', 'infantRoom', NULL, NULL, NULL, 1, 3, 'null');
INSERT INTO `audit_state` VALUES (2620, '待校工会审核拒绝', NULL, 'infantRoom', NULL, NULL, NULL, 1, 1, 'null');
INSERT INTO `audit_state` VALUES (2630, '123', NULL, '123', NULL, NULL, NULL, 3, NULL, '\"{\\\"method\\\":\\\"AND\\\",\\\"conditions\\\":[{\\\"fieldObj\\\":{\\\"label\\\":\\\"角色\\\",\\\"value\\\":\\\"roleId\\\",\\\"type\\\":\\\"select\\\",\\\"options\\\":[{\\\"label\\\":\\\"三育人评委\\\",\\\"value\\\":\\\"001078f4a0564b19bef04fb02fd2bea7\\\"},{\\\"label\\\":\\\"经费审查委员会主任\\\",\\\"value\\\":\\\"09a14a13f0e4490e8fea95d20fdc4066\\\"},{\\\"label\\\":\\\"代表团操作员\\\",\\\"value\\\":\\\"0af36fa65ee742deb46a1fb1ded268ff\\\"},{\\\"label\\\":\\\"校长\\\",\\\"value\\\":\\\"0d8665494fb64a38b4f18fc810ff1751\\\"},{\\\"label\\\":\\\"校工会女工管理员\\\",\\\"value\\\":\\\"0ef8e873617b435599ecc6e35bb14d63\\\"},{\\\"label\\\":\\\"女教职工委员会副主任\\\",\\\"value\\\":\\\"100c6e52c8ff4ba397b9bfd0a9310f18\\\"},{\\\"label\\\":\\\"正式代表\\\",\\\"value\\\":\\\"1427083503b74aa0885d104419b33170\\\"},{\\\"label\\\":\\\"提案分管校领导\\\",\\\"value\\\":\\\"153cba3fb88b4c88b7c1002f0eb63749\\\"},{\\\"label\\\":\\\"工代会特邀代表\\\",\\\"value\\\":\\\"15b2c2beb9e34c96bd30730ad383cde3\\\"},{\\\"label\\\":\\\"校工会出纳\\\",\\\"value\\\":\\\"20270bcf02fd4acfbfa3ab06217e8301\\\"},{\\\"label\\\":\\\"资格审查小组人员 \\\",\\\"value\\\":\\\"262e11bfe387404e8d46831f7a22d13d\\\"},{\\\"label\\\":\\\"工会委员会主席\\\",\\\"value\\\":\\\"26fa82e6f7dd4641aa1655d9fa5c875a\\\"},{\\\"label\\\":\\\"承办单位负责人\\\",\\\"value\\\":\\\"2b17b5d68c754914b4637dddb66ea4ed\\\"},{\\\"label\\\":\\\"提案委员会委员\\\",\\\"value\\\":\\\"2b7194f5b17c4cc8b049ad945e6c6d04\\\"},{\\\"label\\\":\\\"执行委员会委员\\\",\\\"value\\\":\\\"33b76a43a6ca4c48be7f3ab0656b3a98\\\"},{\\\"label\\\":\\\"工会委员会副主席\\\",\\\"value\\\":\\\"3a87d9e925174f59bbbe86fcf2be3a91\\\"},{\\\"label\\\":\\\"困难帮扶审批员\\\",\\\"value\\\":\\\"3ad2f192213e4482831512acf49ca8d5\\\"},{\\\"label\\\":\\\"入学登记审批员\\\",\\\"value\\\":\\\"3c3514a0e86942cbaa7a65d15898ee68\\\"},{\\\"label\\\":\\\"工会委员会常务副主席\\\",\\\"value\\\":\\\"3dad064faf134a6fb6ec3437ff2e09e2\\\"},{\\\"label\\\":\\\"医疗互管会\\\",\\\"value\\\":\\\"3e2b280dd7ec42a1b5120bb5b1d9bc4b\\\"},{\\\"label\\\":\\\"二级单位党委书记\\\",\\\"value\\\":\\\"428969eb99ff4b76883d83f847ee96a5\\\"},{\\\"label\\\":\\\"校活动管理员\\\",\\\"value\\\":\\\"45034013fef74de3b6b7d855dabf3420\\\"},{\\\"label\\\":\\\"校荣誉管理员\\\",\\\"value\\\":\\\"47624f9635d34115aaf67c10609fa4bf\\\"},{\\\"label\\\":\\\"校工会会计\\\",\\\"value\\\":\\\"4f72d9259837486a8092c19897fa9dd6\\\"},{\\\"label\\\":\\\"主席团成员\\\",\\\"value\\\":\\\"517161a4ccba4898a1d627a7ea93ff59\\\"},{\\\"label\\\":\\\"争议调解委员会成员\\\",\\\"value\\\":\\\"53dcf219e5084bc99d5773aa097f8475\\\"},{\\\"label\\\":\\\"分工会管理员\\\",\\\"value\\\":\\\"5d342e614e9a48288d50154bcdcc75d3\\\"},{\\\"label\\\":\\\"代表团副团长\\\",\\\"value\\\":\\\"6445f21685c5489aa212a986cfbeecce\\\"},{\\\"label\\\":\\\"分工会副主席\\\",\\\"value\\\":\\\"672b47cfc79c4a77878c0f2cfd5734be\\\"},{\\\"label\\\":\\\"分工会组织委员\\\",\\\"value\\\":\\\"6a3dced2b3b941d0aa6dab78b4e6b3f6\\\"},{\\\"label\\\":\\\"分工会生活委员\\\",\\\"value\\\":\\\"6b5b4803ce2a4d35ab6a26237b9a3252\\\"},{\\\"label\\\":\\\"校工会分管主席\\\",\\\"value\\\":\\\"7449096aef204965bf6071b30605997d\\\"},{\\\"label\\\":\\\"校会员管理员\\\",\\\"value\\\":\\\"791e2410bd0c44aa84bfad120a7b57c7\\\"},{\\\"label\\\":\\\"提案委员会主任\\\",\\\"value\\\":\\\"827d20a5f2cb400ab1dff4335539ee9f\\\"},{\\\"label\\\":\\\"女教职工委员会成员\\\",\\\"value\\\":\\\"8525916274ce4c54b94b28d87e701f79\\\"},{\\\"label\\\":\\\"工代会列席代表\\\",\\\"value\\\":\\\"8bf27c18e3034219876214d09c8fff31\\\"},{\\\"label\\\":\\\"院级党委(未用)\\\",\\\"value\\\":\\\"8c7c7dacf8c540dcb7c01a1d4e81e0a6\\\"},{\\\"label\\\":\\\"经费审查委员会成员\\\",\\\"value\\\":\\\"8c92538a928c4d4bb827a18f84fe6f98\\\"},{\\\"label\\\":\\\"校提案管理员\\\",\\\"value\\\":\\\"91623fdad36e45ffbf3e5eab42fb5599\\\"},{\\\"label\\\":\\\"执行委员会主任\\\",\\\"value\\\":\\\"9198553383294ba7ba3f27be184d15fc\\\"},{\\\"label\\\":\\\"校工会管理员\\\",\\\"value\\\":\\\"9b01918f873645048f8a85a4fc06d135\\\"},{\\\"label\\\":\\\"主席团秘书长\\\",\\\"value\\\":\\\"9b54205ef5f34d1a843709a5cf23ee44\\\"},{\\\"label\\\":\\\"分工会主席\\\",\\\"value\\\":\\\"9c1f19e385914fef82bc35da7c9ded36\\\"},{\\\"label\\\":\\\"秘书处\\\",\\\"value\\\":\\\"9ed88263b2274924ab58937ef57e914b\\\"},{\\\"label\\\":\\\"工会委员会成员\\\",\\\"value\\\":\\\"a48e3049aca5414b9cbc42174bb29567\\\"},{\\\"label\\\":\\\"二级单位院长（处长）\\\",\\\"value\\\":\\\"aab84fae4e5a48fb91939475096f3604\\\"},{\\\"label\\\":\\\"校工会活动委员\\\",\\\"value\\\":\\\"b16fc41325484fec9fb9eea303e2d582\\\"},{\\\"label\\\":\\\"职工慰问审批员\\\",\\\"value\\\":\\\"b1b2adbc6e854193a4fd98265a7b951e\\\"},{\\\"label\\\":\\\"分工会体育委员\\\",\\\"value\\\":\\\"b6bfcd71e11e41f9b6821b25dde3adc2\\\"},{\\\"label\\\":\\\"执行委员会副主任\\\",\\\"value\\\":\\\"b9e9bf91c7c24101902e786d0a33e47d\\\"},{\\\"label\\\":\\\"女教职工委员会主任\\\",\\\"value\\\":\\\"ba09a540ec2f46d18dac2f2f8b33908a\\\"},{\\\"label\\\":\\\"分工会青工委员\\\",\\\"value\\\":\\\"ba25b3f1d3024af88741561a6893e23a\\\"},{\\\"label\\\":\\\"会员用户\\\",\\\"value\\\":\\\"bf904e661ced4e909dea0fdccdc02b2d\\\"},{\\\"label\\\":\\\"福利单位管理员\\\",\\\"value\\\":\\\"bfd195fe366e4f308230259bbe3ca9b8\\\"},{\\\"label\\\":\\\"代表团团长\\\",\\\"value\\\":\\\"c1765c03459840c2b621d140f575c869\\\"},{\\\"label\\\":\\\"协会负责人\\\",\\\"value\\\":\\\"c17d7a777dd24d36b4b268037b959faf\\\"},{\\\"label\\\":\\\"分工会宣传委员\\\",\\\"value\\\":\\\"c2afa36fac1f4033b2d6b6be0c29f332\\\"},{\\\"label\\\":\\\"提案委员会副主任\\\",\\\"value\\\":\\\"c3e67e4f4060499a8ce6dbe0a9bb591e\\\"},{\\\"label\\\":\\\"争议调解委员会主任\\\",\\\"value\\\":\\\"c59002613df5490c9650999605eccc23\\\"},{\\\"label\\\":\\\"争议调解委员会副主任\\\",\\\"value\\\":\\\"cb0648154cb34089b4e050b21e5b29aa\\\"},{\\\"label\\\":\\\"综合门诊部\\\",\\\"value\\\":\\\"cc3d640e582747bc9cf543a80312cafa\\\"},{\\\"label\\\":\\\"分工会财务委员\\\",\\\"value\\\":\\\"cdbaa3ca73a147af995e9f1fb636b1ae\\\"},{\\\"label\\\":\\\"系统管理员\\\",\\\"value\\\":\\\"d71a8876c7dc4403a182deacb3d8f8a9\\\"},{\\\"label\\\":\\\"校工会场地管理员\\\",\\\"value\\\":\\\"da3979fef3bb4cba8395d9e4c24e60cc\\\"},{\\\"label\\\":\\\"党委书记\\\",\\\"value\\\":\\\"dc6703af06fa456a9d95c1104e8d7c77\\\"},{\\\"label\\\":\\\"公共角色\\\",\\\"value\\\":\\\"dc72d1f4197146d5b7658682bc718bb6\\\"},{\\\"label\\\":\\\"二级单位负责人\\\",\\\"value\\\":\\\"dd35baa967f84bcca823ec7e72be2ec8\\\"},{\\\"label\\\":\\\"筹备领导小组人员\\\",\\\"value\\\":\\\"df80289878bd4a84bacb44567d145bfc\\\"},{\\\"label\\\":\\\"分工会女工委员\\\",\\\"value\\\":\\\"e38e65d34b5c42bbac264b2bb5bdc3f8\\\"},{\\\"label\\\":\\\"校职工服务管理员\\\",\\\"value\\\":\\\"e8c48998fe8944c6b7992aa84f60d892\\\"},{\\\"label\\\":\\\"主席团副秘书长\\\",\\\"value\\\":\\\"f2317602ec0d49b9ba3b090a9065eaaf\\\"},{\\\"label\\\":\\\"特邀代表\\\",\\\"value\\\":\\\"f3ca7ab46f764753b13e4a755ef13265\\\"},{\\\"label\\\":\\\"列席代表\\\",\\\"value\\\":\\\"f411b5965d364876830aa6d597491038\\\"},{\\\"label\\\":\\\"经费审查委员会副主任\\\",\\\"value\\\":\\\"f431140e20b2484489158de03f91c83a\\\"},{\\\"label\\\":\\\"校福利委员\\\",\\\"value\\\":\\\"f78e1cdf74654ef1a047c4950180c213\\\"},{\\\"label\\\":\\\"分工会文艺委员\\\",\\\"value\\\":\\\"f8f8235992ea431f8133c26da79f894b\\\"},{\\\"label\\\":\\\"离退休干部处\\\",\\\"value\\\":\\\"fafdc68717d64175afaadd03b9f9876a\\\"},{\\\"label\\\":\\\"大病互助审批员\\\",\\\"value\\\":\\\"fdbd04a9fbc449a1965a564051559420\\\"}]},\\\"field\\\":\\\"roleId\\\",\\\"value\\\":\\\"001078f4a0564b19bef04fb02fd2bea7\\\",\\\"operational\\\":\\\"EQ\\\",\\\"options\\\":[]}]}\"');
-- ----------------------------
-- Table structure for jdh2_gzzl
-- ----------------------------
DROP TABLE IF EXISTS `jdh2_gzzl`;
CREATE TABLE `jdh2_gzzl` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`userid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`zlname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`zllx` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`ispass` tinyint NULL DEFAULT NULL,
`files` json NULL COMMENT '附件',
`fromid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源id（因为这个记录可能是通过会议请示或者会议批复同步过来的）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh2_gzzl
-- ----------------------------
INSERT INTO `jdh2_gzzl` VALUES ('4i1phtc73kga5qfnf14ij1all5', '1', 'admin', '2022-12-30', '一届一次', '456', '4vccmutlrgheho34k3qhs9t64k', 1, NULL, NULL);
INSERT INTO `jdh2_gzzl` VALUES ('o6h3d5c41ciapoujjffhuaepes', '2656', '郑亮', '2022-12-30', '一届一次', '456', '4vccmutlrgheho34k3qhs9t64k', 1, '[]', NULL);
-- ----------------------------
-- Table structure for jdh2_gzzllx
-- ----------------------------
DROP TABLE IF EXISTS `jdh2_gzzllx`;
CREATE TABLE `jdh2_gzzllx` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`code` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型编码',
`lxname` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作资料类型名称',
`xh` tinyint NULL DEFAULT NULL COMMENT '序号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh2_gzzllx
-- ----------------------------
INSERT INTO `jdh2_gzzllx` VALUES ('118qacft5ehtlp25fgtra6vonr', '02', '会议批复', 2);
INSERT INTO `jdh2_gzzllx` VALUES ('4vccmutlrgheho34k3qhs9t64k', '01', '会议请示', 1);
-- ----------------------------
-- Table structure for jdh_cbwj
-- ----------------------------
DROP TABLE IF EXISTS `jdh_cbwj`;
CREATE TABLE `jdh_cbwj` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`userid` int NULL DEFAULT NULL,
`username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`zlname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`zllx` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`ispass` tinyint NULL DEFAULT NULL,
`files` json NULL COMMENT '附件',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_cbwj
-- ----------------------------
-- ----------------------------
-- Table structure for jdh_db
-- ----------------------------
DROP TABLE IF EXISTS `jdh_db`;
CREATE TABLE `jdh_db` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`dbid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表用户ID',
`dbunitid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表单位ID',
`dbunitname` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表单位名称',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会ID',
`roleid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属角色ID',
`opBy` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
`opAt` bigint NULL DEFAULT NULL COMMENT '操作时间',
`delFlag` tinyint(1) NULL DEFAULT NULL COMMENT '删除标记',
`dbzt` int NULL DEFAULT NULL COMMENT '代表状态1待填写资料2待校工会核实3待资格小组审查4正式代表5驳回6审查不合格',
`dbfghscyj` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校工会审核意见',
`dbzgscyj` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资格小组审核意见',
`gxid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属高校',
`sfbzzb` int NULL DEFAULT 1 COMMENT '是否占指标 1:占指标 2：不占指标',
`dbfghid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属分工会ID',
`dbfghname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属分工会名称',
`dbfghscsj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校工会审核时间',
`dbzgscsj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资格审查小组审核时间',
`dbfghscr` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校工会审核人',
`dbzgscr` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资格小组审核人',
`dbtid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属代表团 当用户为校领导是该字段不为空',
`rewards` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '近几年奖惩情况',
`sfyx` tinyint(1) NULL DEFAULT NULL COMMENT '是否是通过预选代表选上来的',
`files` json NULL COMMENT '附件',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of jdh_db
-- ----------------------------
INSERT INTO `jdh_db` VALUES ('12ba0snb66g07oa9e98k0alspq', '16665', '100725', '文法学院', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '1717cb0a017f429e8d816a656aef40ea', '文法学院工会', NULL, NULL, NULL, NULL, '34eb9338825047dfa1f6167343efb5f9', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('2bhice4m1ihhjqbhlvgctd2f99', '16442', '100768', '资产与实验室管理处[国有资产管理委员会办公室][经营性资产管理委员会办公室]', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '3d551550514b48f6ac598f41afe2f397', '机关工会', NULL, NULL, NULL, NULL, '1e70675d82c44a778cc57d4cb1661607', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('2t6pidji44ivvrc1ornoak6bfp', '17813', '100734', '马克思主义学院', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 'aff47bdc230a4442ae7fdfb2e15804d8', '马克思主义学院工会', NULL, NULL, NULL, NULL, '445aa5890894474fa6aa27163b1791dd', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('32bmut2r6qhvspabo0c4n70hap', '17347', '100725', '文法学院', '0qqlq9vh70h65qve75boq4qflf', '107', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '1717cb0a017f429e8d816a656aef40ea', '文法学院工会', NULL, NULL, NULL, NULL, '34eb9338825047dfa1f6167343efb5f9', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('4bq7h0a8megqfp0c2rq4164gec', '16476', '100715', '教务处[教学质量监控与评估中心]', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '3d551550514b48f6ac598f41afe2f397', '机关工会', NULL, NULL, NULL, NULL, '1e70675d82c44a778cc57d4cb1661607', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('4gjlhisnt6gcdprtev3h6lln50', '17366', '100725', '文法学院', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '1717cb0a017f429e8d816a656aef40ea', '文法学院工会', NULL, NULL, NULL, NULL, '34eb9338825047dfa1f6167343efb5f9', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('5ieqnoncpejhgq94dgjhstvuek', '17621', '100725', '文法学院', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '1717cb0a017f429e8d816a656aef40ea', '文法学院工会', NULL, NULL, NULL, NULL, '34eb9338825047dfa1f6167343efb5f9', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('67hf4sa6i8hbjotjbva6sotqcj', '16445', '100734', '马克思主义学院', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 'aff47bdc230a4442ae7fdfb2e15804d8', '马克思主义学院工会', NULL, NULL, NULL, NULL, '445aa5890894474fa6aa27163b1791dd', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('7j8nvges62hibq7ndn36sgb60h', '19451', '100712', '东北大学工会委员会', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '3d551550514b48f6ac598f41afe2f397', '机关工会', NULL, NULL, NULL, NULL, '34eb9338825047dfa1f6167343efb5f9', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('a4420db1680840e08e1cef2a4d90061a', '17243', '100714', '研究生院（党委研究生工作部）', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '3d551550514b48f6ac598f41afe2f397', '机关工会', NULL, NULL, NULL, NULL, '1e70675d82c44a778cc57d4cb1661607', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('v2chahd4oijf8paotdni2m2h0k', '16510', '100722', '离退休工作处[离退休党委]', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, '3d551550514b48f6ac598f41afe2f397', '机关工会', NULL, NULL, NULL, NULL, '1e70675d82c44a778cc57d4cb1661607', NULL, 0, NULL);
INSERT INTO `jdh_db` VALUES ('vok8uut6jkjo0ovsmtp76b5d6v', '17734', '100734', '马克思主义学院', '0qqlq9vh70h65qve75boq4qflf', '104', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 'aff47bdc230a4442ae7fdfb2e15804d8', '马克思主义学院工会', NULL, NULL, NULL, NULL, '445aa5890894474fa6aa27163b1791dd', NULL, 0, NULL);
-- ----------------------------
-- Table structure for jdh_dbt
-- ----------------------------
DROP TABLE IF EXISTS `jdh_dbt`;
CREATE TABLE `jdh_dbt` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`dbtname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表团名称',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会id',
`cjsj` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
`code` varchar(50) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_dbt
-- ----------------------------
INSERT INTO `jdh_dbt` VALUES ('1e70675d82c44a778cc57d4cb1661607', '机关代表团', '0qqlq9vh70h65qve75boq4qflf', '2023-03-03', '2103');
INSERT INTO `jdh_dbt` VALUES ('34eb9338825047dfa1f6167343efb5f9', '文法学院代表团', '0qqlq9vh70h65qve75boq4qflf', '2023-03-03', '2101');
INSERT INTO `jdh_dbt` VALUES ('445aa5890894474fa6aa27163b1791dd', '马克思主义学院代表团', '0qqlq9vh70h65qve75boq4qflf', '2023-03-03', '2102');
-- ----------------------------
-- Table structure for jdh_dbt_zcfgh
-- ----------------------------
DROP TABLE IF EXISTS `jdh_dbt_zcfgh`;
CREATE TABLE `jdh_dbt_zcfgh` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`dbtid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表团id',
`fghid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '基层工会id',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_dbt_zcfgh
-- ----------------------------
INSERT INTO `jdh_dbt_zcfgh` VALUES ('2c7e3fbdaf6440b4bdeb953e7efe1791', '1e70675d82c44a778cc57d4cb1661607', '3d551550514b48f6ac598f41afe2f397', '0qqlq9vh70h65qve75boq4qflf');
INSERT INTO `jdh_dbt_zcfgh` VALUES ('2e90b7e2c8ef42489251fea7e9f1680a', '34eb9338825047dfa1f6167343efb5f9', '1717cb0a017f429e8d816a656aef40ea', '0qqlq9vh70h65qve75boq4qflf');
INSERT INTO `jdh_dbt_zcfgh` VALUES ('6494d40c380b4a8cbf9b00025e715ac2', '445aa5890894474fa6aa27163b1791dd', 'aff47bdc230a4442ae7fdfb2e15804d8', '0qqlq9vh70h65qve75boq4qflf');
-- ----------------------------
-- Table structure for jdh_gzzllx
-- ----------------------------
DROP TABLE IF EXISTS `jdh_gzzllx`;
CREATE TABLE `jdh_gzzllx` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`code` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型编码',
`lxname` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作资料类型名称',
`xh` tinyint NULL DEFAULT NULL COMMENT '序号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_gzzllx
-- ----------------------------
INSERT INTO `jdh_gzzllx` VALUES ('70rvm20qlijpuo8leeod2a88nb', '003', '会议记录', 3);
INSERT INTO `jdh_gzzllx` VALUES ('7pvrrbr09oif2rosg1oed0lj32', '007', '其他资料', 7);
INSERT INTO `jdh_gzzllx` VALUES ('pis1g5tnbgin8qtivdpopqb2st', '002', '大会议程', 2);
INSERT INTO `jdh_gzzllx` VALUES ('ploknkho5cj6uqr6b1c3cuu2er', '006', '会议总结', 6);
INSERT INTO `jdh_gzzllx` VALUES ('qcmob03fuagqupjkga90au1o6h', '001', '大会决议', 1);
INSERT INTO `jdh_gzzllx` VALUES ('qfh5uqsp56h5gppuljs52i04gm', '005', '大会日程', 5);
INSERT INTO `jdh_gzzllx` VALUES ('res2cs1v2ohevorivna38l95pa', '004', '大会报告', 4);
-- ----------------------------
-- Table structure for jdh_hyhd
-- ----------------------------
DROP TABLE IF EXISTS `jdh_hyhd`;
CREATE TABLE `jdh_hyhd` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`userid` bigint NULL DEFAULT NULL COMMENT '发布人id',
`lx` tinyint NULL DEFAULT NULL COMMENT '类型（1:会议/2:活动）',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`jfys` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '经费预算',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会id',
`kssj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始时间',
`jssj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束时间',
`cd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场地',
`nr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
`jy` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纪要',
`files` json NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_hyhd
-- ----------------------------
-- ----------------------------
-- Table structure for jdh_hyhd_cy
-- ----------------------------
DROP TABLE IF EXISTS `jdh_hyhd_cy`;
CREATE TABLE `jdh_hyhd_cy` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`userid` bigint NULL DEFAULT NULL COMMENT 'userid',
`hyhdid` varchar(32) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_hyhd_cy
-- ----------------------------
-- ----------------------------
-- Table structure for jdh_jdhxx
-- ----------------------------
DROP TABLE IF EXISTS `jdh_jdhxx`;
CREATE TABLE `jdh_jdhxx` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`jdhnf` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会年份',
`jdhjs` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会届数',
`jdhcs` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会次数',
`jdhallname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会全称',
`jdhkqsj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会开启时间',
`jdhms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会描述',
`jdhkqzt` tinyint NULL DEFAULT NULL COMMENT '教代会开启状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_jdhxx
-- ----------------------------
INSERT INTO `jdh_jdhxx` VALUES ('0qqlq9vh70h65qve75boq4qflf', '2023', '一', '四', '一届四次', '2023-02-07 10:49:27', '一届四次教代会', 1);
-- ----------------------------
-- Table structure for jdh_jgcy
-- ----------------------------
DROP TABLE IF EXISTS `jdh_jgcy`;
CREATE TABLE `jdh_jgcy` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`userId` bigint NULL DEFAULT NULL COMMENT '组员对应的用户id',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组员对应的教代会id',
`jgid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组员对应的机构id',
`sf` tinyint NULL DEFAULT NULL COMMENT '组员身份(1:组员,2:副组长,3:组长)',
`roleId` bigint NULL DEFAULT NULL COMMENT '角色id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_jgcy
-- ----------------------------
INSERT INTO `jdh_jgcy` VALUES ('02b636c6aed34c2786fcfa6a5dc342b6', 16489, '0qqlq9vh70h65qve75boq4qflf', 'oljk9ojm5qh6jqm1spo3os5ge5', 1, 136);
INSERT INTO `jdh_jgcy` VALUES ('274d896f21864e3b9ae3699bdc3e8cb0', 16457, '0qqlq9vh70h65qve75boq4qflf', 'd9e2ea079038467893ea040a9772fc9b', 3, 133);
INSERT INTO `jdh_jgcy` VALUES ('287oa7sf1ujn9pl3i56d5f86cc', 1794, '0qqlq9vh70h65qve75boq4qflf', '7c3be7fd3d7e4eb2b7fb7b0cb565c02c', 3, 101);
INSERT INTO `jdh_jgcy` VALUES ('cbb87f4817fa484ea50e8e1fc3c117f7', 16441, '0qqlq9vh70h65qve75boq4qflf', 'oljk9ojm5qh6jqm1spo3os5ge5', 3, 134);
INSERT INTO `jdh_jgcy` VALUES ('oe78iregt8gbrqoq5cdf0b9so9', 1794, '0qqlq9vh70h65qve75boq4qflf', '579ea46651c2496b98d3f46a7da36b47', 3, 101);
-- ----------------------------
-- Table structure for jdh_jgsz
-- ----------------------------
DROP TABLE IF EXISTS `jdh_jgsz`;
CREATE TABLE `jdh_jgsz` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`parentId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级ID',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构名称',
`mechanismcode` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构编码',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会',
`hasChildren` tinyint(1) NULL DEFAULT NULL COMMENT '有子节点',
`roles` json NULL COMMENT '角色',
`bz` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`location` int NULL DEFAULT NULL COMMENT '排序字段',
`mcid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_jgsz
-- ----------------------------
INSERT INTO `jdh_jgsz` VALUES ('035d4a68152a4a4299c792094c5c0d03', '84519c3978404af89147c42f19e9c5d8', '劳动争议调解工作委员会', '07', NULL, 0, NULL, '123', 15, NULL);
INSERT INTO `jdh_jgsz` VALUES ('39b5a3d2ff3343198aa194ff094f68c8', '84519c3978404af89147c42f19e9c5d8', '民主评议干部工作委员会', '04', NULL, 0, NULL, '123', 11, NULL);
INSERT INTO `jdh_jgsz` VALUES ('579ea46651c2496b98d3f46a7da36b47', '5972c34ff68e4b0cbc6d0834fe88982b', '资格领导小组', '002', NULL, 0, NULL, '123', 4, NULL);
INSERT INTO `jdh_jgsz` VALUES ('5972c34ff68e4b0cbc6d0834fe88982b', '0', '机构设置', 'jgsz', NULL, 1, NULL, '123', 2, NULL);
INSERT INTO `jdh_jgsz` VALUES ('61d0177e63c14f41953532ad757bea29', '5972c34ff68e4b0cbc6d0834fe88982b', '主席团管理', '003', NULL, 0, '[{\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 106, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdhdbt02\", \"createBy\": null, \"roleName\": \"代表团副团长\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2022-12-22 14:11:16\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}, {\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 105, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdhdbt01\", \"createBy\": null, \"roleName\": \"代表团团长\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2022-12-22 14:11:06\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}]', '123', 5, NULL);
INSERT INTO `jdh_jgsz` VALUES ('6861de797f5c4d329191efa8fa546545', '84519c3978404af89147c42f19e9c5d8', '财经工作委员会', '02', NULL, 0, '[{\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 131, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"gh12\", \"createBy\": null, \"roleName\": \"分工会财务委员\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2022-12-30 15:12:59\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}, {\"flag\": false, \"params\": {}, \"remark\": \"普通角色\", \"roleId\": 2, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"common\", \"createBy\": null, \"roleName\": \"普通角色\", \"roleSort\": 2, \"updateBy\": null, \"dataScope\": \"2\", \"createTime\": \"2022-12-14 10:14:57\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}]', '123', 13, NULL);
INSERT INTO `jdh_jgsz` VALUES ('7c3be7fd3d7e4eb2b7fb7b0cb565c02c', '5972c34ff68e4b0cbc6d0834fe88982b', '筹备领导小组', '001', NULL, 0, NULL, '123', 3, NULL);
INSERT INTO `jdh_jgsz` VALUES ('84519c3978404af89147c42f19e9c5d8', '5972c34ff68e4b0cbc6d0834fe88982b', '专门委员会', '005', NULL, 1, NULL, '123', 7, NULL);
INSERT INTO `jdh_jgsz` VALUES ('8df1eea733aa4c52afba90509a8c07be', '84519c3978404af89147c42f19e9c5d8', '教学科研工作委员会', '05', NULL, 0, '[{\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 137, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdhzxwyh02\", \"createBy\": null, \"roleName\": \"执行委员会副主任\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:32:29\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}]', '123', 12, NULL);
INSERT INTO `jdh_jgsz` VALUES ('b29d73321c1447f49cf7e3a01dc0e30a', '84519c3978404af89147c42f19e9c5d8', '人事福利分配工作委员会', '06', NULL, 0, NULL, '123', 14, NULL);
INSERT INTO `jdh_jgsz` VALUES ('d9e2ea079038467893ea040a9772fc9b', '5972c34ff68e4b0cbc6d0834fe88982b', '执行委员会', '004', NULL, 0, '[{\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 133, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdhzxwyh01\", \"createBy\": null, \"roleName\": \"执行委员会主任\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:10:28\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}, {\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 137, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdhzxwyh02\", \"createBy\": null, \"roleName\": \"执行委员会副主任\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:32:29\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}, {\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 138, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdhzxwyh03\", \"createBy\": null, \"roleName\": \"执行委员会委员\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:32:48\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}]', '123', 6, NULL);
INSERT INTO `jdh_jgsz` VALUES ('f8e857c2340f4764af6bcd384aff9843', '84519c3978404af89147c42f19e9c5d8', '房屋工作委员会', '03', NULL, 0, NULL, '123', 16, NULL);
INSERT INTO `jdh_jgsz` VALUES ('oljk9ojm5qh6jqm1spo3os5ge5', '84519c3978404af89147c42f19e9c5d8', '提案工作委员会', '01', NULL, 0, '[{\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 136, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdh12\", \"createBy\": null, \"roleName\": \"提案委员会委员\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:21:26\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}, {\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 135, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdh11\", \"createBy\": null, \"roleName\": \"提案委员会副主任\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:21:06\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}, {\"flag\": false, \"params\": {}, \"remark\": null, \"roleId\": 134, \"status\": \"0\", \"delFlag\": \"0\", \"deptIds\": null, \"menuIds\": null, \"roleKey\": \"jdh10\", \"createBy\": null, \"roleName\": \"提案委员会主任\", \"roleSort\": 0, \"updateBy\": null, \"dataScope\": \"1\", \"createTime\": \"2023-01-03 15:20:45\", \"updateTime\": null, \"permissions\": null, \"searchValue\": null, \"deptCheckStrictly\": true, \"menuCheckStrictly\": true}]', '审核提案', 8, NULL);
-- ----------------------------
-- Table structure for jdh_level2
-- ----------------------------
DROP TABLE IF EXISTS `jdh_level2`;
CREATE TABLE `jdh_level2` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`meeting_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会议名称',
`unit_id` bigint NULL DEFAULT NULL COMMENT '所属单位',
`union_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属工会',
`create_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
`founder` bigint NULL DEFAULT NULL COMMENT '创建人ID',
`session_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '届次',
`meeting_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会议时间',
`before_meeting_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上一次会议时间',
`official_delegate` mediumint NULL DEFAULT NULL COMMENT '正式代表人数',
`teacher_delegate` mediumint NULL DEFAULT NULL COMMENT '教师代表人数',
`attend_delegate` mediumint NULL DEFAULT NULL COMMENT '列席代表人数',
`special_delegate` mediumint NULL DEFAULT NULL COMMENT '特邀代表人数',
`meeting_topic` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '会议议题',
`have_elect` tinyint(1) NULL DEFAULT NULL COMMENT '有无选举事项',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`files` json NULL COMMENT '文件',
`audit_state` mediumint NULL DEFAULT NULL COMMENT '审核状态',
`party_committee_id` bigint NULL DEFAULT NULL COMMENT '院级党委审核人',
`party_committee_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '院级党委审核时间',
`party_committee_opinion` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '院级党委审核意见',
`school_union_id` bigint NULL DEFAULT NULL COMMENT '校工会审核人',
`school_union_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校工会审核时间',
`school_union_opinion` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校工会审核意见',
`school_files` json NULL COMMENT '校工会审核附件',
`jdhjs` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会届数',
`jdhcs` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会次数',
`jdhallname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会全称',
`type` varchar(20) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_level2
-- ----------------------------
INSERT INTO `jdh_level2` VALUES ('b809acf55c0a41359deb4f723f0e2a91', '关于召开地球科学学院第一届教职工代表大会、工会会员代表大会的请示', 101, '876f553113c148d0ae008cace3035e04', '2022-12-29', 1, NULL, '2022-12-29 16:40', '', NULL, NULL, NULL, NULL, '123', 0, '123', '[]', 500, NULL, NULL, NULL, 1, '2023-01-04', '同意', '[]', '一', '一', '一届一次', '届中会');
-- ----------------------------
-- Table structure for jdh_level2_state
-- ----------------------------
DROP TABLE IF EXISTS `jdh_level2_state`;
CREATE TABLE `jdh_level2_state` (
`id` int NOT NULL,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`color` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '节点类型（0.审核节点 1.拒绝节点 2.通过节点）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of jdh_level2_state
-- ----------------------------
INSERT INTO `jdh_level2_state` VALUES (100, '待院级党委批复', '#1D8CE0', '0');
INSERT INTO `jdh_level2_state` VALUES (200, '院级党委退回', '#FF4949', '1');
INSERT INTO `jdh_level2_state` VALUES (300, '待校工会批复', '#1D8CE0', '0');
INSERT INTO `jdh_level2_state` VALUES (400, '校工会退回', '#FF4949', '1');
INSERT INTO `jdh_level2_state` VALUES (500, '已完结', '#13CE66', '2');
-- ----------------------------
-- Table structure for jdh_lxty_db
-- ----------------------------
DROP TABLE IF EXISTS `jdh_lxty_db`;
CREATE TABLE `jdh_lxty_db` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`dbid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表用户ID',
`jdhid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会ID',
`dbunitid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表单位ID',
`dbunitname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表单位名称',
`dbfghid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表基层工会id',
`dbfghname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表基层工会名称',
`roleid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属角色ID',
`dbtid` varchar(32) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jdh_lxty_db
-- ----------------------------
-- ----------------------------
-- Table structure for teacher_meet_delegate
-- ----------------------------
DROP TABLE IF EXISTS `teacher_meet_delegate`;
CREATE TABLE `teacher_meet_delegate` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`userId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表用户ID',
`teacherMeetId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会ID',
`delegationId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属代表团 当用户为校领导是该字段不为空',
`userName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`loginName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号',
`sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`nation` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
`politicalOutlook` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '政治面貌',
`education` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历',
`technicalTitle` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '技术职称===>jobTitle',
`administrativeTitle` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行政职称===>position',
`age` int NULL DEFAULT NULL COMMENT '年龄',
`twoWork` tinyint(1) NULL DEFAULT NULL COMMENT '是否双肩挑',
`stateCode` int NULL DEFAULT NULL COMMENT '流程审核状态',
`roleId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教代会代表类型',
`isJdh` tinyint(1) NULL DEFAULT NULL COMMENT '教代会',
`isGdh` tinyint(1) NULL DEFAULT NULL COMMENT '工代会',
`bz` varchar(20) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of teacher_meet_delegate
-- ----------------------------
INSERT INTO `teacher_meet_delegate` VALUES ('0036e1a747fd4f27aa4b95a345e925c9', '17243', '0qqlq9vh70h65qve75boq4qflf', NULL, '修佳夫', '00009464', '0', '01', '团员', '1', '2', '1', 1, NULL, 300, NULL, 1, 0, NULL);
-- ----------------------------
-- Table structure for union_cadre
-- ----------------------------
DROP TABLE IF EXISTS `union_cadre`;
CREATE TABLE `union_cadre` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`session` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '届次',
`userId` bigint NULL DEFAULT NULL COMMENT '用户Id',
`roleId` bigint NULL DEFAULT NULL COMMENT '角色Id',
`unionId` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工会id',
`joining` tinyint(1) NULL DEFAULT NULL COMMENT '加入/退出',
`auditStateId` int NULL DEFAULT NULL COMMENT '审核状态id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of union_cadre
-- ----------------------------
INSERT INTO `union_cadre` VALUES ('b42374a8ae69487cbda5d52f1a0b6fa3', '一', 2408, 124, '876f553113c148d0ae008cace3035e04', 1, 1200);
-- ----------------------------
-- Table structure for workers_congress_delegation
-- ----------------------------
DROP TABLE IF EXISTS `workers_congress_delegation`;
CREATE TABLE `workers_congress_delegation` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`dbt_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表团名称',
`gdh_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属工代会id',
`found_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
`code` varchar(50) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of workers_congress_delegation
-- ----------------------------
INSERT INTO `workers_congress_delegation` VALUES ('2a2024926ef94927b1e6813d6ff0feca', '材料与化学学院代表团', '4050d84ed27a458fa183658dc782d73b', '2022-12-27', '2103');
INSERT INTO `workers_congress_delegation` VALUES ('7252fc6f67144d9b98a69b50b92b5b05', '材料与化学学院代表团', '091139d7ef264d6ab6c5b03c3f058039', '2023-01-04', '2103');
INSERT INTO `workers_congress_delegation` VALUES ('a66e9346ec3b4cd2a6e2ee814c5b2d2d', '资源学院代表团', '091139d7ef264d6ab6c5b03c3f058039', '2023-01-04', '2102');
INSERT INTO `workers_congress_delegation` VALUES ('d09ae41ff1cb476cb4bf1b3919a2530d', '地球科学学院代表团', '091139d7ef264d6ab6c5b03c3f058039', '2023-01-04', '2101');
INSERT INTO `workers_congress_delegation` VALUES ('da6be97412b4435cb6bb8812d8e0fd7c', '环境学院代表团', '4050d84ed27a458fa183658dc782d73b', '2022-12-27', '2104');
INSERT INTO `workers_congress_delegation` VALUES ('f83aaa9daf044505b8ae16170edc2961', '环境学院代表团', '091139d7ef264d6ab6c5b03c3f058039', '2023-01-04', '2104');
-- ----------------------------
-- Table structure for workers_congress_delegation_make_up_union
-- ----------------------------
DROP TABLE IF EXISTS `workers_congress_delegation_make_up_union`;
CREATE TABLE `workers_congress_delegation_make_up_union` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`dbt_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代表团id',
`union_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '基层工会id',
`gdh_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属工代会id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of workers_congress_delegation_make_up_union
-- ----------------------------
INSERT INTO `workers_congress_delegation_make_up_union` VALUES ('24716114ffc44f98983ec98f9e4add71', 'f83aaa9daf044505b8ae16170edc2961', 'e846ff528fef4e45a312f743022fd4a2', '091139d7ef264d6ab6c5b03c3f058039');
INSERT INTO `workers_congress_delegation_make_up_union` VALUES ('26491e8fe595415c9760e4b99ec52263', '2a2024926ef94927b1e6813d6ff0feca', '876f553113c148d0ae008cace3035e04', '4050d84ed27a458fa183658dc782d73b');
INSERT INTO `workers_congress_delegation_make_up_union` VALUES ('6bb83c3d0df54171ab32bfcaac33c4f4', '2a2024926ef94927b1e6813d6ff0feca', '2fa772091a8d486f94f3e430e0bfa306', '4050d84ed27a458fa183658dc782d73b');
INSERT INTO `workers_congress_delegation_make_up_union` VALUES ('aa963709095f45aa95c2935dc9689a23', 'a66e9346ec3b4cd2a6e2ee814c5b2d2d', 'c1a0249b29e14b3dab2a087a76e2251e', '091139d7ef264d6ab6c5b03c3f058039');
INSERT INTO `workers_congress_delegation_make_up_union` VALUES ('dc8854c8da564c67861ae2240891bbbe', '7252fc6f67144d9b98a69b50b92b5b05', 'cb47aed88570491db54a42046271080d', '091139d7ef264d6ab6c5b03c3f058039');
INSERT INTO `workers_congress_delegation_make_up_union` VALUES ('ea788c78f85149ff8cbb956e7e44b3eb', 'd09ae41ff1cb476cb4bf1b3919a2530d', '876f553113c148d0ae008cace3035e04', '091139d7ef264d6ab6c5b03c3f058039');
-- ----------------------------
-- Table structure for workers_congress_organization_user
-- ----------------------------
DROP TABLE IF EXISTS `workers_congress_organization_user`;
CREATE TABLE `workers_congress_organization_user` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
`status` int NULL DEFAULT NULL COMMENT '用户身份1。组员2.副主任3，主任',
`gdh_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属工代会',
`role_id` bigint NULL DEFAULT NULL COMMENT '角色id',
`organization_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构id',
`organization_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构名称',
`organization_code` varchar(50) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of workers_congress_organization_user
-- ----------------------------
INSERT INTO `workers_congress_organization_user` VALUES ('054c41137f084df78f2614bcba8e5d83', 1749, 3, '4050d84ed27a458fa183658dc782d73b', 117, '217', '工会委员会', 'gdhwyh1');
INSERT INTO `workers_congress_organization_user` VALUES ('1a2a0bdd4f024462858915a3476f97ec', 1771, 2, '091139d7ef264d6ab6c5b03c3f058039', NULL, '218', '女教职工委员会', 'gdhwyh2');
INSERT INTO `workers_congress_organization_user` VALUES ('241fc0c7285742c8a86dfc5625ca4803', 1771, 1, '189b0a047b814d4f8690c0ca491abea2', 119, '217', '工会委员会', 'gdhwyh1');
INSERT INTO `workers_congress_organization_user` VALUES ('57eca19c23864b6d90a8e3399c3c1bf9', 1821, 3, '091139d7ef264d6ab6c5b03c3f058039', NULL, '218', '女教职工委员会', 'gdhwyh2');
INSERT INTO `workers_congress_organization_user` VALUES ('74cd046fe52243f3b25b80690f3c60de', 1749, 3, '091139d7ef264d6ab6c5b03c3f058039', NULL, '217', '工会委员会', 'gdhwyh1');
INSERT INTO `workers_congress_organization_user` VALUES ('fe2752ffc1eb462b9c6877316fda4d1b', 1821, 3, '4050d84ed27a458fa183658dc782d73b', NULL, '218', '女教职工委员会', 'gdhwyh2');
-- ----------------------------
-- Table structure for workers_congress_representative
-- ----------------------------
DROP TABLE IF EXISTS `workers_congress_representative`;
CREATE TABLE `workers_congress_representative` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`userId` bigint NULL DEFAULT NULL COMMENT '代表用户ID',
`gdh_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属教代会ID',
`roleId` bigint NULL DEFAULT NULL COMMENT '所属角色ID',
`dbt_id` varchar(32) 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 ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of workers_congress_representative
-- ----------------------------
INSERT INTO `workers_congress_representative` VALUES ('1', 1749, '4050d84ed27a458fa183658dc782d73b', 109, '2a2024926ef94927b1e6813d6ff0feca');
INSERT INTO `workers_congress_representative` VALUES ('138978ddd67440de824bd5f32683fe2d', 1751, '4050d84ed27a458fa183658dc782d73b', 109, '2a2024926ef94927b1e6813d6ff0feca');
INSERT INTO `workers_congress_representative` VALUES ('4e3e45572fa14536bc975f305cf568ea', 1754, '091139d7ef264d6ab6c5b03c3f058039', 109, 'd09ae41ff1cb476cb4bf1b3919a2530d');
INSERT INTO `workers_congress_representative` VALUES ('6e92a5a39e874f49866b5340fc2a8902', 1971, '091139d7ef264d6ab6c5b03c3f058039', 111, 'd09ae41ff1cb476cb4bf1b3919a2530d');
INSERT INTO `workers_congress_representative` VALUES ('c494ad3e88f044869d979e8aefd0eaa6', 1883, '091139d7ef264d6ab6c5b03c3f058039', 109, 'd09ae41ff1cb476cb4bf1b3919a2530d');
INSERT INTO `workers_congress_representative` VALUES ('ca276aaa6e2b413685058fee50f2d631', 1752, '4050d84ed27a458fa183658dc782d73b', 109, '2a2024926ef94927b1e6813d6ff0feca');
-- ----------------------------
-- Table structure for workers_congress_session
-- ----------------------------
DROP TABLE IF EXISTS `workers_congress_session`;
CREATE TABLE `workers_congress_session` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',
`year` int NULL DEFAULT NULL COMMENT '年度',
`gdhJs` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '届',
`gdhCs` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '次',
`gdhAllName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
`startTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开启时间',
`startState` tinyint(1) NULL DEFAULT NULL COMMENT '开启状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of workers_congress_session
-- ----------------------------
INSERT INTO `workers_congress_session` VALUES ('091139d7ef264d6ab6c5b03c3f058039', 2023, '一', '四', '第一届第四次', '2023-01-04', 1);
INSERT INTO `workers_congress_session` VALUES ('189b0a047b814d4f8690c0ca491abea2', 2023, '六', '六', '六届六次', '2023-01-15', 1);
INSERT INTO `workers_congress_session` VALUES ('4050d84ed27a458fa183658dc782d73b', 2022, '一', '三', '第一届第三次', '2022-12-27', 1);
-- ----------------------------
-- View structure for dept
-- ----------------------------
DROP VIEW IF EXISTS `dept`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `dept` AS select `ry-cloud`.`sys_dept`.`dept_id` AS `dept_id`,`ry-cloud`.`sys_dept`.`parent_id` AS `parent_id`,`ry-cloud`.`sys_dept`.`ancestors` AS `ancestors`,`ry-cloud`.`sys_dept`.`dept_name` AS `dept_name`,`ry-cloud`.`sys_dept`.`order_num` AS `order_num`,`ry-cloud`.`sys_dept`.`dept_code` AS `dept_code`,`ry-cloud`.`sys_dept`.`leader` AS `leader`,`ry-cloud`.`sys_dept`.`phone` AS `phone`,`ry-cloud`.`sys_dept`.`email` AS `email`,`ry-cloud`.`sys_dept`.`status` AS `status`,`ry-cloud`.`sys_dept`.`del_flag` AS `del_flag`,`ry-cloud`.`sys_dept`.`create_by` AS `create_by`,`ry-cloud`.`sys_dept`.`create_time` AS `create_time`,`ry-cloud`.`sys_dept`.`union_id` AS `union_id`,`ry-cloud`.`sys_dept`.`union_group_id` AS `union_group_id`,`ry-cloud`.`sys_dept`.`unit_level` AS `unit_level`,`ry-cloud`.`sys_dept`.`update_by` AS `update_by`,`ry-cloud`.`sys_dept`.`update_time` AS `update_time`,`ry-cloud`.`sys_dept`.`remark` AS `remark` from `ry-cloud`.`sys_dept`;
-- ----------------------------
-- View structure for union
-- ----------------------------
DROP VIEW IF EXISTS `union`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `union` AS select `ry-cloud`.`sys_union`.`id` AS `id`,`ry-cloud`.`sys_union`.`unionName` AS `unionName`,`ry-cloud`.`sys_union`.`unionCode` AS `unionCode`,`ry-cloud`.`sys_union`.`unionAddress` AS `unionAddress`,`ry-cloud`.`sys_union`.`unionTime` AS `unionTime`,`ry-cloud`.`sys_union`.`telephone` AS `telephone`,`ry-cloud`.`sys_union`.`campus` AS `campus` from `ry-cloud`.`sys_union`;
-- ----------------------------
-- View structure for user
-- ----------------------------
DROP VIEW IF EXISTS `user`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `user` AS select `u`.`user_id` AS `userId`,`u`.`dept_id` AS `deptId`,`u`.`user_name` AS `loginName`,`u`.`nick_name` AS `userName`,`u`.`user_type` AS `userType`,`u`.`email` AS `email`,`u`.`phonenumber` AS `phonenumber`,`u`.`sex` AS `sex`,`u`.`avatar` AS `avatar`,`u`.`status` AS `status`,`u`.`del_flag` AS `delFlag`,`u`.`login_ip` AS `login_ip`,`u`.`login_date` AS `login_date`,`u`.`remark` AS `remark`,`u`.`birthday` AS `birthday`,`u`.`personType` AS `personType`,`u`.`userState` AS `userState`,`u`.`birthPlace` AS `birthPlace`,`u`.`position` AS `position`,`u`.`jobTitle` AS `jobTitle`,`u`.`hometown` AS `hometown`,`u`.`nation` AS `nation`,`u`.`mobile` AS `mobile`,`u`.`education` AS `education`,`u`.`political` AS `political`,`u`.`schoolTime` AS `schoolTime`,`u`.`idcard` AS `idcard`,`u`.`member` AS `member`,`u`.`memberJoinTime` AS `memberJoinTime`,`u`.`welfareMember` AS `welfareMember`,`u`.`welfareMemberJoinTime` AS `welfareMemberJoinTime`,`u`.`memberOrigin` AS `memberOrigin`,`u`.`memberStatus` AS `memberStatus`,`u`.`hobby` AS `hobby`,`u`.`marriage` AS `marriage`,`u`.`preparedBy` AS `preparedBy`,`u`.`idType` AS `idType`,`u`.`beginningDate` AS `beginningDate`,`u`.`endDate` AS `endDate`,`u`.`householdType` AS `householdType`,`u`.`weChat` AS `weChat`,`u`.`nationality` AS `nationality`,`u`.`academicDegree` AS `academicDegree`,`u`.`personalStatus` AS `personalStatus`,`u`.`vita` AS `vita`,`dw`.`dept_name` AS `deptName`,`dw`.`dept_code` AS `deptCode`,`gh`.`id` AS `unionId`,`gh`.`unionName` AS `unionName`,`gh`.`unionCode` AS `unionCode` from ((`ry-cloud`.`sys_user` `u` left join `ry-cloud`.`sys_dept` `dw` on((`dw`.`dept_id` = `u`.`dept_id`))) left join `ry-cloud`.`sys_union` `gh` on((`gh`.`id` = `dw`.`union_id`)));
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink