workflow_data.sql
1.16 KB
/*
Navicat Premium Data Transfer
Source Server : rrr
Source Server Type : MySQL
Source Server Version : 100508 (10.5.8-MariaDB)
Source Host : localhost:3306
Source Schema : trash
Target Server Type : MySQL
Target Server Version : 100508 (10.5.8-MariaDB)
File Encoding : 65001
Date: 18/07/2023 20:14:19
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for workflow_data
-- ----------------------------
DROP TABLE IF EXISTS `workflow_data`;
CREATE TABLE `workflow_data` (
`id` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主键ID',
`type` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假类型',
`result` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`state` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
`time` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '请假' ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;