1 Star 16 Fork 4

imlzw / jweb-adai

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
jweb-adai.sql 149.82 KB
Copy Edit Web IDE Raw Blame History
imlzw authored 2021-04-27 19:32 . 更新基础数据库sql:jweb-adai.sql
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570
/*
Navicat MySQL Data Transfer
Source Server : 本地Mysql数据库
Source Server Version : 50718
Source Host : localhost:3306
Source Database : jweb-adai
Target Server Type : MYSQL
Target Server Version : 50718
File Encoding : 65001
Date: 2021-04-27 19:23:05
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cms_article`
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
`article_id` varchar(32) NOT NULL COMMENT '文章编号',
`catalog_id` varchar(32) NOT NULL COMMENT '所在栏目',
`article_type` varchar(24) NOT NULL COMMENT '文章类型',
`article_title` varchar(128) NOT NULL COMMENT '标题',
`article_subtitle` varchar(512) DEFAULT NULL COMMENT '副标题',
`article_content` text COMMENT '文章内容',
`source` varchar(128) DEFAULT NULL COMMENT '来源',
`author` varchar(32) NOT NULL COMMENT '作者',
`create_datetime` datetime NOT NULL COMMENT '创建时间',
`publish_datetime` datetime DEFAULT NULL COMMENT '发布时间',
`modify_datetime` datetime DEFAULT NULL COMMENT '修改时间',
`status` tinyint(2) DEFAULT NULL COMMENT '状态(0:未发布,1:已发布)',
`thumbnail` varchar(128) DEFAULT NULL COMMENT '缩略图',
`view_count` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数',
PRIMARY KEY (`article_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章';
-- ----------------------------
-- Records of cms_article
-- ----------------------------
INSERT INTO `cms_article` VALUES ('71776734965534720', '71773655805333504', 'blog', '花木成畦手自栽花木成畦手自栽', 'layui-icon-tread', '<p>2760079880f94311b15c02c89545db6c,44f88b4683224b47aa4054b91ac53ea3,875df98ce6ba4b2c95bc94de7562e8e1,723a0b50cef14e8dbd2f131d0eda9ff0,76544f24a59b41d3902332ed5fdd3859,7757432df60c40bb8868228c34488ed5,a5afaa770a144c70ad62de2d5698b76e,b752a75922c443a295bae2d9fd5dc0fc,ba072d7175094cc0880d2e23c87ba904,c6f40745b7904e7abce8bfd46bf7b28c,e7ccad08cd7b430ebcb31213594692e7</p>', 'fa-address-card', '2132', '2020-10-17 00:00:00', '2020-10-17 00:00:00', '2020-10-30 16:02:19', '1', 'b441908d5bcc4f6f951c204272e9406a', '88');
INSERT INTO `cms_article` VALUES ('74251163469484032', '71772683121070080', 'activity', '00:00:00', '2020-10', '<p>55c237cb968c4ffb9b9856c3d67dfccb</p>', 'layui-icon-login-wechat', '4a9c8b3269dd4b2fa5f0168d386057df', '2020-10-22 14:12:06', '2020-10-06 00:00:00', '2020-10-30 16:02:04', '0', '42f1cf747d414d4685f019bddfbee5e6', '0');
INSERT INTO `cms_article` VALUES ('74614924915118080', '71772683121070080', 'blog', '这是标题', '2020-12', '<p>0e8<strong>a7cf92bd7432ba945a5ed7c99b595,41986bf517b346d68669bdc0aff01728,4b7b7e128b9344439da411a5295af5d4,748ccdc6b04f44348255e32d1ca44709,768f14fb6bcd455bba4c5</strong>5ba7deff8e9,ae217a3346e348c2b9e98b1294c4a239</p>', 'fa-bathtub', '73801032fb4c43c6bc6f3f6080d36676', '2020-10-23 14:17:33', '1970-01-01 09:03:02', '2021-04-26 16:02:45', '0', '015d2a2f36cb4de3b308af0a5993f5d8', '0');
INSERT INTO `cms_article` VALUES ('wqwqwqwq', '71773655805333504', 'activity', '00:00:00', '2020-10', '<p style=\"text-align: center;\">2ac187bc58c247998a4ccc6ff517f2b9,5e555155658f49acb7fe48764656474e,818b6ead7eaf4279af522d7f4382cceb,aa1cd1bbe1234ea8ab6d056f554efb2f,d006a37f35144cefbd1e5dc703fbbf66,d9362a625fb2467e956ba833124d6bcb,e0a28b4831314532b183e66c72c8afd9,fec836262b0546179b310930c418a38c,bb0bacabf8b44347923549da61c1a6a0</p>', 'layui-icon-login-weibo', '789e2e115b1947318235bafe39b4225e', '2020-10-17 16:10:37', '2020-10-17 16:10:24', '2020-10-30 16:02:12', '1', '27d321e2812f4869b4db17611392bed6', '0');
-- ----------------------------
-- Table structure for `cms_catalog`
-- ----------------------------
DROP TABLE IF EXISTS `cms_catalog`;
CREATE TABLE `cms_catalog` (
`catalog_id` varchar(32) NOT NULL COMMENT '栏目编号',
`catalog_name` varchar(128) NOT NULL DEFAULT '' COMMENT '栏目名称',
`catalog_key` varchar(128) DEFAULT NULL COMMENT '关键字',
`catalog_type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '栏目类型(0:站点,1:栏目)',
`create_datetime` datetime NOT NULL COMMENT '创建时间',
`catalog_pid` varchar(32) NOT NULL DEFAULT '0' COMMENT '上级栏目',
`order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
PRIMARY KEY (`catalog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='栏目';
-- ----------------------------
-- Records of cms_catalog
-- ----------------------------
INSERT INTO `cms_catalog` VALUES ('71772683121070080', '个人站点', 'imlzw', '0', '2020-10-15 18:03:30', '0', '1');
INSERT INTO `cms_catalog` VALUES ('71773655805333504', '主页', 'index', '1', '2020-10-15 18:07:22', '71772683121070080', '1');
INSERT INTO `cms_catalog` VALUES ('71773926287609856', '资讯', 'info', '1', '2020-10-15 18:08:26', '71772683121070080', '2');
INSERT INTO `cms_catalog` VALUES ('71773990565318656', '博客', 'blog', '1', '2020-10-15 18:08:42', '71772683121070080', '3');
INSERT INTO `cms_catalog` VALUES ('71774118944575488', '个人简介', 'about', '1', '2020-10-15 18:09:12', '71772683121070080', '4');
-- ----------------------------
-- Table structure for `sys_dic`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dic`;
CREATE TABLE `sys_dic` (
`dic_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典编号',
`dic_pid` int(11) NOT NULL DEFAULT '0' COMMENT '字典上级编号',
`dic_code` varchar(64) NOT NULL COMMENT '字典代码',
`dic_name` varchar(128) NOT NULL COMMENT '字典代码名称',
`dic_value` varchar(128) DEFAULT NULL COMMENT '字典值',
`create_datetime` datetime DEFAULT NULL COMMENT '创建时间',
`is_enable` tinyint(1) NOT NULL COMMENT '是否启用',
`order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
PRIMARY KEY (`dic_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COMMENT='数据字典';
-- ----------------------------
-- Records of sys_dic
-- ----------------------------
INSERT INTO `sys_dic` VALUES ('10', '0', 'teachItem', '教学科目', 'teachItem', '2020-07-22 17:55:55', '1', '0');
INSERT INTO `sys_dic` VALUES ('15', '0', 'sex', '性别', 'sex', '2020-07-22 17:56:20', '1', '0');
INSERT INTO `sys_dic` VALUES ('16', '10', 'math', '数学', 'math', '2020-07-22 17:56:24', '1', '1');
INSERT INTO `sys_dic` VALUES ('17', '0', 'article_type', '文章类型', 'schooltype', '2020-09-15 14:30:17', '1', '0');
INSERT INTO `sys_dic` VALUES ('19', '17', 'topic', '话题', '2', '2020-09-15 14:30:35', '1', '3');
INSERT INTO `sys_dic` VALUES ('21', '17', 'blog', '博客', '3', '2020-09-15 14:30:50', '1', '2');
INSERT INTO `sys_dic` VALUES ('22', '17', 'log', '日志', '4', '2020-09-15 14:30:55', '1', '1');
INSERT INTO `sys_dic` VALUES ('23', '17', 'news', '新闻', null, '2020-09-15 14:30:59', '1', '0');
INSERT INTO `sys_dic` VALUES ('25', '15', 'man', '男', '1', '2020-09-15 17:01:47', '1', '0');
INSERT INTO `sys_dic` VALUES ('26', '15', 'woman', '女', '0', '2020-09-15 17:02:15', '1', '0');
INSERT INTO `sys_dic` VALUES ('27', '10', 'yuwei', '语文', 'yuwei', '2020-09-16 18:37:10', '1', '0');
INSERT INTO `sys_dic` VALUES ('28', '10', 'english', '英语', null, '2020-09-16 18:43:31', '1', '0');
INSERT INTO `sys_dic` VALUES ('30', '10', 'wuli', '物理', null, '2020-09-16 18:59:25', '1', '0');
INSERT INTO `sys_dic` VALUES ('31', '10', 'huaxie', '化学', null, '2020-09-16 18:59:39', '1', '0');
INSERT INTO `sys_dic` VALUES ('32', '10', 'shengwu', '生物', null, '2020-09-16 19:00:01', '1', '0');
INSERT INTO `sys_dic` VALUES ('34', '15', 'secret', '保密', '2', '2020-10-14 11:14:06', '1', '0');
INSERT INTO `sys_dic` VALUES ('35', '17', 'activity', '活动', null, '2020-10-15 14:18:03', '1', '4');
-- ----------------------------
-- Table structure for `sys_field_model`
-- ----------------------------
DROP TABLE IF EXISTS `sys_field_model`;
CREATE TABLE `sys_field_model` (
`field_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '字段编号',
`field_key` varchar(128) NOT NULL COMMENT '字段名',
`field_name` varchar(128) NOT NULL COMMENT '显示名称',
`field_type` varchar(64) NOT NULL COMMENT '字段类型',
`field_length` int(11) DEFAULT NULL COMMENT '字段长度',
`decimal_point` int(11) DEFAULT NULL COMMENT '小数点位数',
`is_nullable` tinyint(1) DEFAULT NULL COMMENT '是否可空',
`is_primary` tinyint(1) DEFAULT NULL COMMENT '是否是主键',
`create_datetime` datetime NOT NULL COMMENT '创建时间',
`field_order` int(11) DEFAULT '0' COMMENT '字段排度号',
`field_default` varchar(128) DEFAULT 'NULL' COMMENT '默认值',
`field_config` text COMMENT '字段配置',
`table_id` int(11) NOT NULL COMMENT '关联表编号',
`order_no` int(11) NOT NULL DEFAULT '1' COMMENT '排序号',
PRIMARY KEY (`field_id`)
) ENGINE=InnoDB AUTO_INCREMENT=411 DEFAULT CHARSET=utf8mb4 COMMENT='字段模型';
-- ----------------------------
-- Records of sys_field_model
-- ----------------------------
INSERT INTO `sys_field_model` VALUES ('245', 'is_enable', '是否启用', 'tinyint', '1', null, '0', '0', '2020-07-27 14:20:08', '1', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"none\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '17', '7');
INSERT INTO `sys_field_model` VALUES ('246', 'create_datetime', '创建时间', 'datetime', null, null, '1', '0', '2020-07-27 14:20:08', '2', 'NULL', '{}', '17', '6');
INSERT INTO `sys_field_model` VALUES ('247', 'dic_value', '字典值', 'varchar', '128', null, '0', '0', '2020-07-27 14:20:08', '3', 'NULL', '{}', '17', '5');
INSERT INTO `sys_field_model` VALUES ('248', 'dic_name', '字典名称', 'varchar', '128', null, '0', '0', '2020-07-27 14:20:08', '4', 'NULL', '{}', '17', '4');
INSERT INTO `sys_field_model` VALUES ('249', 'dic_code', '字典代码', 'varchar', '64', null, '0', '0', '2020-07-27 14:20:08', '5', 'NULL', '{}', '17', '3');
INSERT INTO `sys_field_model` VALUES ('250', 'dic_pid', '上级编号', 'int', '11', null, '0', '0', '2020-07-27 14:20:08', '6', '0', '{\"isAutoIncrease\":false,\"releaseType\":\"sql\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\",\"configValue\":\"select * from sys_dic where dic_pid = 0\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\",\"configValue\":\"dic_id\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\",\"configValue\":\"dic_name\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\",\"configValue\":\"\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '17', '2');
INSERT INTO `sys_field_model` VALUES ('251', 'dic_id', '字典编号', 'int', '11', null, '0', '1', '2020-07-27 14:20:08', '7', 'NULL', '{\"isAutoIncrease\":true}', '17', '1');
INSERT INTO `sys_field_model` VALUES ('267', 'log_status', '日志状态', 'tinyint', '2', null, '1', '0', '2020-08-04 15:54:37', '8', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"field_key\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"失败\\\",\\\"value\\\":\\\"0\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"成功\\\",\\\"value\\\":\\\"1\\\",\\\"no\\\":\\\"2\\\"}]\"}}}}', '20', '6');
INSERT INTO `sys_field_model` VALUES ('268', 'log_ip', '日志IP', 'varchar', '32', null, '1', '0', '2020-08-04 15:54:37', '7', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"none\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"field_key\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '20', '6');
INSERT INTO `sys_field_model` VALUES ('269', 'log_url', '日志URL', 'varchar', '255', null, '1', '0', '2020-08-04 15:54:37', '6', 'NULL', '{}', '20', '6');
INSERT INTO `sys_field_model` VALUES ('270', 'log_content', '日志内容', 'varchar', '1024', null, '1', '0', '2020-08-04 15:54:37', '5', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"dic\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\",\"configValue\":\"15\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\",\"configValue\":\"code\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '20', '5');
INSERT INTO `sys_field_model` VALUES ('271', 'log_category', '日志分类', 'varchar', '32', null, '1', '0', '2020-08-04 15:54:37', '4', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"none\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '20', '4');
INSERT INTO `sys_field_model` VALUES ('272', 'log_datetime', '日志时间', 'datetime', null, null, '1', '0', '2020-08-04 15:54:37', '3', 'NULL', '{}', '20', '3');
INSERT INTO `sys_field_model` VALUES ('273', 'user_id', '日志用户', 'int', '11', null, '1', '0', '2020-08-04 15:54:37', '2', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"sql\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\",\"configValue\":\"select \\nuser_id, user_name \\nfrom sys_user\\nwhere 1=1\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\",\"configValue\":\"user_id\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\",\"configValue\":\"user_name\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\",\"configValue\":\"\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '20', '2');
INSERT INTO `sys_field_model` VALUES ('274', 'log_id', '日志编号', 'bigint', '20', null, '0', '1', '2020-08-04 15:54:37', '1', 'NULL', '{\"isAutoIncrease\":true}', '20', '1');
INSERT INTO `sys_field_model` VALUES ('294', 'user_last_login_datetime', '最近登录', 'datetime', null, null, '1', '0', '2020-09-16 19:41:36', '11', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"none\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '25', '11');
INSERT INTO `sys_field_model` VALUES ('295', 'create_datetime', '创建时间', 'datetime', null, null, '1', '0', '2020-09-16 19:41:36', '10', 'NULL', '{}', '25', '10');
INSERT INTO `sys_field_model` VALUES ('296', 'user_status', '用户状态', 'tinyint', '2', null, '1', '0', '2020-09-16 19:41:36', '9', '1', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"启用\\\",\\\"value\\\":\\\"1\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"禁用\\\",\\\"value\\\":\\\"2\\\",\\\"no\\\":\\\"2\\\"}]\"}}}}', '25', '9');
INSERT INTO `sys_field_model` VALUES ('297', 'user_email', '电子邮箱', 'varchar', '128', null, '1', '0', '2020-09-16 19:41:36', '8', 'NULL', '{}', '25', '8');
INSERT INTO `sys_field_model` VALUES ('298', 'user_phone', '手机号', 'varchar', '32', null, '1', '0', '2020-09-16 19:41:36', '7', 'NULL', '{}', '25', '7');
INSERT INTO `sys_field_model` VALUES ('299', 'user_password', '登录密码', 'varchar', '128', null, '1', '0', '2020-09-16 19:41:36', '6', 'NULL', '{}', '25', '6');
INSERT INTO `sys_field_model` VALUES ('300', 'user_account', '登录账号', 'varchar', '32', null, '1', '0', '2020-09-16 19:41:36', '5', 'NULL', '{}', '25', '5');
INSERT INTO `sys_field_model` VALUES ('301', 'user_name', '用户姓名', 'varchar', '32', null, '1', '0', '2020-09-16 19:41:36', '3', 'NULL', '{}', '25', '3');
INSERT INTO `sys_field_model` VALUES ('302', 'org_id', '所属机构', 'int', '11', null, '1', '0', '2020-09-16 19:41:36', '2', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"sql\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\",\"configValue\":\"select * from sys_org order by order_no asc\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\",\"configValue\":\"org_id\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\",\"configValue\":\"org_name\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\",\"configValue\":\"org_pid\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '25', '2');
INSERT INTO `sys_field_model` VALUES ('303', 'user_id', '用户编号', 'int', '11', null, '0', '1', '2020-09-16 19:41:36', '1', 'NULL', '{\"isAutoIncrease\":true}', '25', '1');
INSERT INTO `sys_field_model` VALUES ('304', 'user_sex', '性别', 'tinyint', '2', null, '0', '0', '2020-09-16 20:11:15', '4', '1', '{\"isAutoIncrease\":false,\"releaseType\":\"dic\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\",\"configValue\":\"15\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\",\"configValue\":\"value\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '25', '4');
INSERT INTO `sys_field_model` VALUES ('324', 'order_no', '排序号', 'int', '11', null, '0', '0', '2020-09-27 14:28:53', '10', '100', '{}', '28', '10');
INSERT INTO `sys_field_model` VALUES ('325', 'create_datetime', '创建时间', 'datetime', null, null, '0', '0', '2020-09-27 14:28:53', '11', 'NULL', '{}', '28', '12');
INSERT INTO `sys_field_model` VALUES ('326', 'status', '状态', 'tinyint', '1', null, '0', '0', '2020-09-27 14:28:53', '8', '0', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"启用\\\",\\\"value\\\":\\\"1\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"禁用\\\",\\\"value\\\":\\\"0\\\",\\\"no\\\":\\\"2\\\"}]\"}}}}', '28', '8');
INSERT INTO `sys_field_model` VALUES ('327', 'oper_path', '操作路径', 'varchar', '128', null, '1', '0', '2020-09-27 14:28:53', '6', 'NULL', '{}', '28', '6');
INSERT INTO `sys_field_model` VALUES ('328', 'permission_key', '权限标识', 'varchar', '128', null, '0', '0', '2020-09-27 14:28:53', '7', 'NULL', '{}', '28', '7');
INSERT INTO `sys_field_model` VALUES ('329', 'oper_icon', '图标', 'varchar', '32', null, '1', '0', '2020-09-27 14:28:53', '9', 'NULL', '{}', '28', '9');
INSERT INTO `sys_field_model` VALUES ('330', 'oper_name', '操作名称', 'varchar', '32', null, '0', '0', '2020-09-27 14:28:53', '2', 'NULL', '{}', '28', '2');
INSERT INTO `sys_field_model` VALUES ('331', 'oper_type', '操作类型', 'int', '11', null, '0', '0', '2020-09-27 14:28:53', '5', '0', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"菜单\\\",\\\"value\\\":\\\"0\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"权限\\\",\\\"value\\\":\\\"1\\\",\\\"no\\\":\\\"2\\\"}]\"}}}}', '28', '5');
INSERT INTO `sys_field_model` VALUES ('332', 'oper_pid', '上级操作', 'int', '11', null, '0', '0', '2020-09-27 14:28:53', '4', '0', '{\"isAutoIncrease\":false,\"releaseType\":\"sql\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\",\"configValue\":\"select * from sys_oper order by order_no asc\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\",\"configValue\":\"oper_id\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\",\"configValue\":\"oper_name\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\",\"configValue\":\"oper_pid\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '28', '4');
INSERT INTO `sys_field_model` VALUES ('333', 'oper_id', '操作编号', 'int', '11', null, '0', '1', '2020-09-27 14:28:53', '1', 'NULL', '{\"isAutoIncrease\":true}', '28', '1');
INSERT INTO `sys_field_model` VALUES ('334', 'order_no', '排序号', 'int', '11', null, '0', '0', '2020-09-27 17:31:53', '6', 'NULL', '{}', '29', '6');
INSERT INTO `sys_field_model` VALUES ('335', 'create_datetime', '创建时间', 'datetime', null, null, '0', '0', '2020-09-27 17:31:53', '5', 'NULL', '{}', '29', '5');
INSERT INTO `sys_field_model` VALUES ('336', 'org_name', '机构名称', 'varchar', '128', null, '0', '0', '2020-09-27 17:31:53', '4', 'NULL', '{}', '29', '4');
INSERT INTO `sys_field_model` VALUES ('337', 'org_code', '机构代码', 'varchar', '32', null, '0', '0', '2020-09-27 17:31:53', '3', 'NULL', '{}', '29', '3');
INSERT INTO `sys_field_model` VALUES ('338', 'org_pid', '上级机构', 'int', '11', null, '0', '0', '2020-09-27 17:31:53', '2', '0', '{\"isAutoIncrease\":false,\"releaseType\":\"sql\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\",\"configValue\":\"select * from sys_org order by order_no asc\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\",\"configValue\":\"org_id\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\",\"configValue\":\"org_name\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\",\"configValue\":\"org_pid\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '29', '2');
INSERT INTO `sys_field_model` VALUES ('339', 'org_id', '机构编号', 'int', '11', null, '0', '1', '2020-09-27 17:31:53', '1', 'NULL', '{\"isAutoIncrease\":true}', '29', '1');
INSERT INTO `sys_field_model` VALUES ('340', 'role_pid', '上级角色', 'int', '11', null, '0', '0', '2020-09-30 11:24:42', '4', 'NULL', '{}', '30', '4');
INSERT INTO `sys_field_model` VALUES ('341', 'create_datetime', '创建时间', 'datetime', null, null, '0', '0', '2020-09-30 11:24:42', '3', 'NULL', '{}', '30', '3');
INSERT INTO `sys_field_model` VALUES ('342', 'role_name', '角色名称', 'varchar', '32', null, '0', '0', '2020-09-30 11:24:42', '2', 'NULL', '{}', '30', '2');
INSERT INTO `sys_field_model` VALUES ('343', 'role_id', '角色编号', 'int', '11', null, '0', '1', '2020-09-30 11:24:42', '1', 'NULL', '{\"isAutoIncrease\":true}', '30', '1');
INSERT INTO `sys_field_model` VALUES ('344', 'user_id', '人员编号', 'int', '11', null, '0', '0', '2020-09-30 11:26:10', '3', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"table\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\",\"configValue\":\"sys_user\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\",\"configValue\":\"user_id\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\",\"configValue\":\"user_name\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\",\"configValue\":\"\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '31', '3');
INSERT INTO `sys_field_model` VALUES ('345', 'role_id', '角色编号', 'int', '11', null, '0', '0', '2020-09-30 11:26:10', '1', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"table\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\",\"configValue\":\"sys_role\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\",\"configValue\":\"role_id\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\",\"configValue\":\"role_name\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\",\"configValue\":\"\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '31', '2');
INSERT INTO `sys_field_model` VALUES ('346', 'oper_id', '操作编号', 'int', '11', null, '0', '0', '2020-09-30 11:27:33', '3', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"sql\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\",\"configValue\":\"select * from sys_oper order by order_no asc\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\",\"configValue\":\"oper_id\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\",\"configValue\":\"oper_name\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\",\"configValue\":\"oper_pid\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '32', '3');
INSERT INTO `sys_field_model` VALUES ('347', 'role_id', '角色编号', 'int', '11', null, '0', '0', '2020-09-30 11:27:33', '1', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"table\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\",\"configValue\":\"sys_role\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\",\"configValue\":\"role_id\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\",\"configValue\":\"role_name\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\",\"configValue\":\"\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '32', '2');
INSERT INTO `sys_field_model` VALUES ('348', 'ro_id', '角色权限编号', 'int', '11', null, '0', '1', '2020-09-30 11:36:26', '2', 'NULL', '{\"isAutoIncrease\":true,\"releaseType\":\"none\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '32', '1');
INSERT INTO `sys_field_model` VALUES ('349', 'ru_id', '角色人员编号', 'int', '11', null, '0', '1', '2020-09-30 11:37:07', '2', 'NULL', '{\"isAutoIncrease\":true,\"releaseType\":\"none\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '31', '1');
INSERT INTO `sys_field_model` VALUES ('350', 'order_no', '排序号', 'int', '11', null, '0', '0', '2020-10-14 11:31:10', '8', '0', null, '17', '8');
INSERT INTO `sys_field_model` VALUES ('351', 'create_datetime', '上传时间', 'datetime', null, null, '0', '0', '2020-10-14 17:35:14', '7', 'NULL', '{}', '33', '7');
INSERT INTO `sys_field_model` VALUES ('352', 'file_size', '文件大小', 'bigint', '20', null, '0', '0', '2020-10-14 17:35:14', '6', 'NULL', '{}', '33', '6');
INSERT INTO `sys_field_model` VALUES ('353', 'file_path', '文件路径', 'varchar', '128', null, '0', '0', '2020-10-14 17:35:14', '5', 'NULL', '{}', '33', '5');
INSERT INTO `sys_field_model` VALUES ('354', 'file_suffix', '后缀名', 'varchar', '32', null, '1', '0', '2020-10-14 17:35:14', '3', 'NULL', '{}', '33', '4');
INSERT INTO `sys_field_model` VALUES ('355', 'file_name', '文件名', 'varchar', '128', null, '0', '0', '2020-10-14 17:35:14', '2', 'NULL', '{}', '33', '3');
INSERT INTO `sys_field_model` VALUES ('356', 'file_id', '文件编号', 'varchar', '32', null, '0', '1', '2020-10-14 17:35:14', '1', 'NULL', '{}', '33', '1');
INSERT INTO `sys_field_model` VALUES ('357', 'oper_key', '关键字', 'varchar', '32', null, '0', '0', '2020-10-15 10:29:18', '3', 'NULL', null, '28', '3');
INSERT INTO `sys_field_model` VALUES ('358', 'order_no', '排序号', 'int', '11', null, '0', '0', '2020-10-15 14:04:32', '7', '0', '{}', '34', '7');
INSERT INTO `sys_field_model` VALUES ('359', 'catalog_pid', '上级栏目', 'varchar', '32', null, '0', '0', '2020-10-15 14:04:32', '6', '0', '{\"isAutoIncrease\":false,\"releaseType\":\"table\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\",\"configValue\":\"cms_catalog\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\",\"configValue\":\"catalog_id\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\",\"configValue\":\"catalog_name\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\",\"configValue\":\"catalog_pid\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '34', '6');
INSERT INTO `sys_field_model` VALUES ('360', 'create_datetime', '创建时间', 'datetime', null, null, '0', '0', '2020-10-15 14:04:32', '5', 'NULL', '{}', '34', '5');
INSERT INTO `sys_field_model` VALUES ('361', 'catalog_type', '栏目类型', 'tinyint', '2', null, '0', '0', '2020-10-15 14:04:32', '4', '1', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"站点\\\",\\\"value\\\":\\\"0\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"栏目\\\",\\\"value\\\":\\\"1\\\",\\\"no\\\":\\\"2\\\"}]\"}}}}', '34', '4');
INSERT INTO `sys_field_model` VALUES ('362', 'catalog_key', '关键字', 'varchar', '128', null, '1', '0', '2020-10-15 14:04:32', '3', 'NULL', '{}', '34', '3');
INSERT INTO `sys_field_model` VALUES ('363', 'catalog_name', '栏目名称', 'varchar', '128', null, '0', '0', '2020-10-15 14:04:32', '2', 'EMPTY_STRING', '{}', '34', '2');
INSERT INTO `sys_field_model` VALUES ('364', 'catalog_id', '栏目编号', 'varchar', '32', null, '0', '1', '2020-10-15 14:04:32', '1', 'NULL', '{}', '34', '1');
INSERT INTO `sys_field_model` VALUES ('389', 'publish_datetime', '发布时间', 'datetime', null, null, '1', '0', '2020-10-15 16:40:25', '10', 'NULL', '{}', '37', '10');
INSERT INTO `sys_field_model` VALUES ('390', 'status', '状态', 'tinyint', '2', null, '1', '0', '2020-10-15 16:40:25', '12', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"未发布\\\",\\\"value\\\":\\\"0\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"已发布\\\",\\\"value\\\":\\\"1\\\",\\\"no\\\":\\\"2\\\"}]\"}}}}', '37', '12');
INSERT INTO `sys_field_model` VALUES ('391', 'modify_datetime', '修改时间', 'datetime', null, null, '1', '0', '2020-10-15 16:40:25', '11', 'NULL', '{}', '37', '11');
INSERT INTO `sys_field_model` VALUES ('392', 'view_count', '访问次数', 'int', '11', null, '0', '0', '2020-10-15 16:40:25', '14', 'NULL', '{}', '37', '14');
INSERT INTO `sys_field_model` VALUES ('393', 'thumbnail', '缩略图', 'varchar', '128', null, '1', '0', '2020-10-15 16:40:25', '13', 'NULL', '{}', '37', '13');
INSERT INTO `sys_field_model` VALUES ('394', 'create_datetime', '创建时间', 'datetime', null, null, '0', '0', '2020-10-15 16:40:25', '9', 'NULL', '{}', '37', '9');
INSERT INTO `sys_field_model` VALUES ('395', 'author', '作者', 'varchar', '32', null, '0', '0', '2020-10-15 16:40:25', '8', 'NULL', '{}', '37', '8');
INSERT INTO `sys_field_model` VALUES ('396', 'source', '来源', 'varchar', '128', null, '1', '0', '2020-10-15 16:40:25', '7', 'NULL', '{}', '37', '7');
INSERT INTO `sys_field_model` VALUES ('397', 'article_content', '文章内容', 'text', null, null, '1', '0', '2020-10-15 16:40:25', '6', 'NULL', '{}', '37', '6');
INSERT INTO `sys_field_model` VALUES ('398', 'article_subtitle', '副标题', 'varchar', '512', null, '1', '0', '2020-10-15 16:40:25', '5', 'NULL', '{}', '37', '5');
INSERT INTO `sys_field_model` VALUES ('399', 'article_title', '标题', 'varchar', '128', null, '0', '0', '2020-10-15 16:40:25', '4', 'NULL', '{}', '37', '4');
INSERT INTO `sys_field_model` VALUES ('400', 'article_type', '文章类型', 'varchar', '24', null, '0', '0', '2020-10-15 16:40:25', '3', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"dic\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\",\"configValue\":\"17\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\",\"configValue\":\"code\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '37', '3');
INSERT INTO `sys_field_model` VALUES ('401', 'catalog_id', '所在栏目', 'varchar', '32', null, '0', '0', '2020-10-15 16:40:25', '2', 'NULL', '{\"isAutoIncrease\":false,\"releaseType\":\"table\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\",\"configValue\":\"cms_catalog\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\",\"configValue\":\"catalog_id\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\",\"configValue\":\"catalog_name\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\",\"configValue\":\"catalog_pid\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[]\"}}}}', '37', '2');
INSERT INTO `sys_field_model` VALUES ('402', 'article_id', '文章编号', 'varchar', '32', null, '0', '1', '2020-10-15 16:40:25', '1', 'NULL', '{}', '37', '1');
INSERT INTO `sys_field_model` VALUES ('410', 'file_type', '文件类型', 'varchar', '32', null, '0', '0', '2020-10-30 13:42:53', '4', 'OTHER', '{\"isAutoIncrease\":false,\"releaseType\":\"enum\",\"releaseConfig\":{\"config\":{\"table\":{\"configZhName\":\"关联表\",\"configName\":\"table\"},\"fieldKey\":{\"configZhName\":\"关联字段\",\"configName\":\"fieldKey\"},\"fieldTitle\":{\"configZhName\":\"显示字段\",\"configName\":\"fieldTitle\"},\"fieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"fieldPKey\"},\"dicId\":{\"configZhName\":\"关联字典\",\"configName\":\"dicId\"},\"dicVType\":{\"configZhName\":\"关联值\",\"configName\":\"dicVType\"},\"sql\":{\"configZhName\":\"关联SQL语句\",\"configName\":\"sql\"},\"sqlFieldKey\":{\"configZhName\":\"SQL关联字段\",\"configName\":\"sqlFieldKey\"},\"sqlFieldTitle\":{\"configZhName\":\"SQL显示字段\",\"configName\":\"sqlFieldTitle\"},\"sqlFieldPKey\":{\"configZhName\":\"上级字段\",\"configName\":\"sqlFieldPKey\"},\"enumList\":{\"configZhName\":\"枚举列表\",\"configName\":\"enumList\",\"configValue\":\"[{\\\"title\\\":\\\"图片\\\",\\\"value\\\":\\\"IMAGE\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"视频\\\",\\\"value\\\":\\\"VIDEO\\\",\\\"no\\\":\\\"2\\\"},{\\\"title\\\":\\\"文档\\\",\\\"value\\\":\\\"DOC\\\",\\\"no\\\":\\\"3\\\"},{\\\"title\\\":\\\"其它\\\",\\\"value\\\":\\\"OTHER\\\",\\\"no\\\":\\\"4\\\"}]\"}}}}', '33', '2');
-- ----------------------------
-- Table structure for `sys_file`
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
`file_id` varchar(32) NOT NULL COMMENT '文件编号',
`file_name` varchar(128) NOT NULL COMMENT '文件名',
`file_suffix` varchar(32) DEFAULT NULL COMMENT '后缀名',
`file_type` varchar(32) NOT NULL DEFAULT 'OTHER' COMMENT '文件类型',
`file_path` varchar(128) NOT NULL COMMENT '文件路径',
`file_size` bigint(20) NOT NULL DEFAULT '0' COMMENT '文件大小',
`create_datetime` datetime NOT NULL COMMENT '上传时间',
PRIMARY KEY (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件';
-- ----------------------------
-- Records of sys_file
-- ----------------------------
-- ----------------------------
-- Table structure for `sys_generator_model`
-- ----------------------------
DROP TABLE IF EXISTS `sys_generator_model`;
CREATE TABLE `sys_generator_model` (
`generator_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '生成器编号',
`template_id` varchar(32) DEFAULT NULL COMMENT '关联模板id',
`generator_name` varchar(128) NOT NULL COMMENT '生成器名称',
`generator_config` text COMMENT '生成器配置',
`create_datetime` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`generator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COMMENT='代码生成器模型';
-- ----------------------------
-- Records of sys_generator_model
-- ----------------------------
INSERT INTO `sys_generator_model` VALUES ('5', null, '系统日志', '{\"ctlUri\":\"/system/log\",\"packagePath\":\"cc.jweb.adai.web.system.log\",\"template\":{\"attrs\":{\"template_config\":\"[{\\\"title\\\":\\\"生成模式\\\",\\\"name\\\":\\\"mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"列表过滤\\\",\\\"name\\\":\\\"listFilter\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"列表过滤条件,如 t.pid = 0 or t.pid is null \\\",\\\"no\\\":\\\"2\\\"},{\\\"title\\\":\\\"表格类型\\\",\\\"name\\\":\\\"tableType\\\",\\\"value\\\":\\\"table\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"3\\\"},{\\\"title\\\":\\\"树PID字段\\\",\\\"name\\\":\\\"tablePid\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表1表格类型为treeTable时有效\\\",\\\"no\\\":\\\"4\\\"}]\",\"is_system\":false,\"template_name\":\"标准单列表\",\"template_key\":\"std_single_model_list_crud\",\"official_id\":\"1\",\"thumb\":\"[{\\\"file_path\\\":\\\"20201102\\\\\\\\594c3ad01367499f9ab2b5e0946b3300.gif\\\",\\\"file_url\\\":\\\"/file/download?fileId=594c3ad01367499f9ab2b5e0946b3300\\\",\\\"create_datetime\\\":\\\"2020-11-02 19:03:04\\\",\\\"file_name\\\":\\\"GIF 2020-11-2 19-01-20.gif\\\",\\\"file_suffix\\\":\\\"gif\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"594c3ad01367499f9ab2b5e0946b3300\\\",\\\"file_size\\\":3266636}]\",\"author\":\"imlzw\",\"create_datetime\":\"2020-07-27 15:20:21\",\"table_require_count\":1,\"template_id\":\"1\",\"version\":\"0.0.1\",\"desc\":\"<p>213123</p><p style=\\\"display:none;\\\"><br/></p><p style=\\\"display:none;\\\"><br/></p><p style=\\\"display:none;\\\"><br/></p>\"}},\"tables\":[{\"attrs\":{\"table_key\":\"sys_log\",\"model_package\":\"cc.jweb.adai.web.system.model\",\"create_datetime\":\"2020-08-04 15:54:37\",\"table_id\":20,\"table_name\":\"系统日志\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":274,\"is_nullable\":false,\"is_primary\":true,\"field_length\":20,\"table_id\":20,\"field_name\":\"日志编号\",\"field_order\":1,\"field_key\":\"log_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"bigint\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":273,\"is_nullable\":true,\"is_primary\":false,\"field_length\":11,\"table_id\":20,\"field_name\":\"日志用户\",\"field_order\":2,\"field_key\":\"user_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"sql\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\",\\\"configValue\\\":\\\"select \\\\nuser_id, user_name \\\\nfrom user\\\\nwhere 1=1\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\",\\\"configValue\\\":\\\"user_id\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\",\\\"configValue\\\":\\\"user_name\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"int\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":272,\"is_nullable\":true,\"is_primary\":false,\"table_id\":20,\"field_name\":\"日志时间\",\"field_order\":3,\"field_key\":\"log_datetime\",\"field_config\":\"{}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"datetime\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"eq\",\"checkers\":[\"/^[1-9]\\\\d{3}-(0?[1-9]|1[0-2])-(0?[1-9]|[1-2][0-9]|3[0-1])\\\\s+(20|21|22|23|[0-1]?\\\\d):[0-5]?\\\\d:[0-5]?\\\\d$/【日期时间】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[\"/^[1-9]\\\\d{3}-(0?[1-9]|1[0-2])-(0?[1-9]|[1-2][0-9]|3[0-1])\\\\s+(20|21|22|23|[0-1]?\\\\d):[0-5]?\\\\d:[0-5]?\\\\d$/【日期时间】\"]},{\"attrs\":{\"field_id\":271,\"is_nullable\":true,\"is_primary\":false,\"field_length\":32,\"table_id\":20,\"field_name\":\"日志分类\",\"field_order\":4,\"field_key\":\"log_category\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"dic\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"field_key\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\",\\\"configValue\\\":\\\"1\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"varchar\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":3,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":270,\"is_nullable\":true,\"is_primary\":false,\"field_length\":1024,\"table_id\":20,\"field_name\":\"日志内容\",\"field_order\":5,\"field_key\":\"log_content\",\"field_config\":\"{}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"varchar\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":4,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":269,\"is_nullable\":true,\"is_primary\":false,\"field_length\":255,\"table_id\":20,\"field_name\":\"日志URL\",\"field_order\":6,\"field_key\":\"log_url\",\"field_config\":\"{}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"varchar\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":5,\"searchMethod\":\"eq\",\"checkers\":[\"/http(s)?:\\\\/\\\\/([\\\\w-]+\\\\.)+[\\\\w-]+(\\\\/[\\\\w- .\\\\/?%&=]*)?/【URL】\",\"/^1\\\\d{10}$/【手机号】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[\"/http(s)?:\\\\/\\\\/([\\\\w-]+\\\\.)+[\\\\w-]+(\\\\/[\\\\w- .\\\\/?%&=]*)?/【URL】\",\"/^1\\\\d{10}$/【手机号】\"]},{\"attrs\":{\"field_id\":268,\"is_nullable\":true,\"is_primary\":false,\"field_length\":32,\"table_id\":20,\"field_name\":\"日志IP\",\"field_order\":7,\"field_key\":\"log_ip\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"none\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"field_key\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"varchar\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":6,\"searchMethod\":\"eq\",\"checkers\":[\"/^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?).){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$/【IPv4】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[\"/^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?).){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$/【IPv4】\"]},{\"attrs\":{\"field_id\":267,\"is_nullable\":true,\"is_primary\":false,\"field_length\":2,\"table_id\":20,\"field_name\":\"日志状态\",\"field_order\":8,\"field_key\":\"log_status\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"enum\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"field_key\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[{\\\\\\\"title\\\\\\\":\\\\\\\"失败\\\\\\\",\\\\\\\"value\\\\\\\":\\\\\\\"0\\\\\\\",\\\\\\\"no\\\\\\\":\\\\\\\"1\\\\\\\"},{\\\\\\\"title\\\\\\\":\\\\\\\"成功\\\\\\\",\\\\\\\"value\\\\\\\":\\\\\\\"1\\\\\\\",\\\\\\\"no\\\\\\\":\\\\\\\"2\\\\\\\"}]\\\"}}}}\",\"create_datetime\":\"2020-08-04 15:54:37\",\"field_type\":\"tinyint\",\"table_id_title\":\"系统日志\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":7,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]}]}],\"releaseFieldsList\":[]}', '2020-08-04 18:08:41');
INSERT INTO `sys_generator_model` VALUES ('6', '2', '数据字典', '{\"ctlUri\":\"/system/dic\",\"packagePath\":\"cc.jweb.adai.web.system.dic\",\"template\":{\"attrs\":{\"template_config\":\"[{\\\"title\\\":\\\"表1生成模式\\\",\\\"name\\\":\\\"table1Mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"表2生成模式\\\",\\\"name\\\":\\\"table2Mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"2\\\"},{\\\"title\\\":\\\"表1过滤条件\\\",\\\"name\\\":\\\"table1Filter\\\",\\\"value\\\":\\\"t.dic_pid = 0\\\",\\\"desc\\\":\\\"表1列表过滤条件,如 t.pid = 0 or t.pid is null \\\",\\\"no\\\":\\\"3\\\"},{\\\"title\\\":\\\"表2过滤条件\\\",\\\"name\\\":\\\"table2Filter\\\",\\\"value\\\":\\\"t.dic_pid <> 0\\\",\\\"desc\\\":\\\"表1列表过滤条件,如 t.pid <> 0 and t.pid is not null \\\",\\\"no\\\":\\\"4\\\"},{\\\"title\\\":\\\"表1表格类型\\\",\\\"name\\\":\\\"table1Type\\\",\\\"value\\\":\\\"table\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"5\\\"},{\\\"title\\\":\\\"表1树PID\\\",\\\"name\\\":\\\"table1Pid\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表1表格类型为treeTable时有效\\\",\\\"no\\\":\\\"6\\\"},{\\\"title\\\":\\\"表2表格类型\\\",\\\"name\\\":\\\"table2Type\\\",\\\"value\\\":\\\"table\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"7\\\"},{\\\"title\\\":\\\"表2树PID\\\",\\\"name\\\":\\\"table2Pid\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表2表格类型为treeTable时有效\\\",\\\"no\\\":\\\"8\\\"}]\",\"is_system\":false,\"template_name\":\"标准双列表\",\"template_key\":\"std_double_model_list_crud\",\"official_id\":\"2\",\"thumb\":\"[{\\\"file_path\\\":\\\"20201102\\\\\\\\d89561fd17d74599b2d8e5997cc67e7d.jpg\\\",\\\"file_url\\\":\\\"/file/download?fileId=d89561fd17d74599b2d8e5997cc67e7d\\\",\\\"create_datetime\\\":\\\"2020-11-02 15:24:49\\\",\\\"file_name\\\":\\\"QQ截图20201102145747.jpg\\\",\\\"file_suffix\\\":\\\"jpg\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"d89561fd17d74599b2d8e5997cc67e7d\\\",\\\"file_size\\\":125451},{\\\"file_path\\\":\\\"20201102\\\\\\\\a7a40c790ab8435bab9a21a673c0d5cf.jpg\\\",\\\"file_url\\\":\\\"/file/download?fileId=a7a40c790ab8435bab9a21a673c0d5cf\\\",\\\"create_datetime\\\":\\\"2020-11-02 15:24:49\\\",\\\"file_name\\\":\\\"QQ截图20201102151037.jpg\\\",\\\"file_suffix\\\":\\\"jpg\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"a7a40c790ab8435bab9a21a673c0d5cf\\\",\\\"file_size\\\":78235},{\\\"file_path\\\":\\\"20201102\\\\\\\\5bf528f0bd3646cfae92ae09837a4e3f.jpg\\\",\\\"file_url\\\":\\\"/file/download?fileId=5bf528f0bd3646cfae92ae09837a4e3f\\\",\\\"create_datetime\\\":\\\"2020-11-02 15:24:49\\\",\\\"file_name\\\":\\\"QQ截图20201102151215.jpg\\\",\\\"file_suffix\\\":\\\"jpg\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"5bf528f0bd3646cfae92ae09837a4e3f\\\",\\\"file_size\\\":101106}]\",\"author\":\"imlzw\",\"create_datetime\":\"2020-09-04 14:41:10\",\"table_require_count\":2,\"template_id\":\"2\",\"version\":\"0.0.1\",\"desc\":\"<h3><strong>简介</strong>:</h3><p style=\\\"margin-top: 5px;\\\">关联两张表,实现左右列表展示界面效果,如下图</p><p style=\\\"margin-top: 5px;\\\"><img src=\\\"/file/download?fileId=cd6676ac190f407cacc7938814d4bdb8\\\"/></p><h3 style=\\\"margin-top: 5px;\\\"><strong>配置说明:</strong></h3><p style=\\\"margin-top: 5px;\\\">配置生成器时,左边列表为表1配置,右边列表为表2配置。</p><p style=\\\"margin-top: 5px;\\\">模板包含如下参数:</p><p style=\\\"margin-top: 5px;\\\"><img src=\\\"/file/download?fileId=db963120d5d74e99a92c7180cd16db2a\\\"/></p><p style=\\\"margin-top: 5px;\\\"><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p style=\\\"text-align: center;\\\"><br/></p>\"}},\"tables\":[{\"attrs\":{\"table_key\":\"sys_dic\",\"model_package\":\"cc.jweb.adai.web.system.dic.model\",\"create_datetime\":\"2020-07-27 14:20:08\",\"table_id\":17,\"table_name\":\"数据字典\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":251,\"order_no\":1,\"is_nullable\":false,\"is_primary\":true,\"field_length\":11,\"table_id\":17,\"field_name\":\"字典编号\",\"field_order\":7,\"field_key\":\"dic_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"int\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":250,\"order_no\":2,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":17,\"field_name\":\"上级编号\",\"field_order\":6,\"field_key\":\"dic_pid\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"sql\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\",\\\"configValue\\\":\\\"select * from data_dic where dic_pid = 0\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\",\\\"configValue\\\":\\\"dic_id\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\",\\\"configValue\\\":\\\"dic_name\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"int\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":249,\"order_no\":3,\"is_nullable\":false,\"is_primary\":false,\"field_length\":64,\"table_id\":17,\"field_name\":\"字典代码\",\"field_order\":5,\"field_key\":\"dic_code\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"varchar\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"eq\",\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"]},{\"attrs\":{\"field_id\":248,\"order_no\":4,\"is_nullable\":false,\"is_primary\":false,\"field_length\":128,\"table_id\":17,\"field_name\":\"字典名称\",\"field_order\":4,\"field_key\":\"dic_name\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"varchar\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":true,\"isRequired\":true,\"LAY_TABLE_INDEX\":3,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":true,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":247,\"order_no\":5,\"is_nullable\":false,\"is_primary\":false,\"field_length\":128,\"table_id\":17,\"field_name\":\"字典值\",\"field_order\":3,\"field_key\":\"dic_value\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"varchar\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":4,\"searchMethod\":\"eq\",\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"]},{\"attrs\":{\"field_id\":246,\"order_no\":6,\"is_nullable\":true,\"is_primary\":false,\"table_id\":17,\"field_name\":\"创建时间\",\"field_order\":2,\"field_key\":\"create_datetime\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"datetime\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":5,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":245,\"order_no\":7,\"is_nullable\":false,\"is_primary\":false,\"field_length\":1,\"table_id\":17,\"field_name\":\"是否启用\",\"field_order\":1,\"field_key\":\"is_enable\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"none\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"tinyint\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":6,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":350,\"order_no\":8,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":17,\"field_name\":\"排序号\",\"field_order\":8,\"field_key\":\"order_no\",\"create_datetime\":\"2020-10-14 11:31:10\",\"field_type\":\"int\",\"table_id_title\":\"数据字典\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":7,\"searchMethod\":\"eq\",\"checkers\":[\"/^[0-9]{0,}$/【数字】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[\"/^[0-9]{0,}$/【数字】\"]}]},{\"attrs\":{\"table_key\":\"sys_dic\",\"model_package\":\"cc.jweb.adai.web.system.dic.model\",\"create_datetime\":\"2020-07-27 14:20:08\",\"table_id\":17,\"table_name\":\"数据字典\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":251,\"order_no\":1,\"is_nullable\":false,\"is_primary\":true,\"field_length\":11,\"table_id\":17,\"field_name\":\"字典编号\",\"field_order\":7,\"field_key\":\"dic_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"int\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":250,\"order_no\":2,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":17,\"field_name\":\"上级编号\",\"field_order\":6,\"field_key\":\"dic_pid\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"sql\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\",\\\"configValue\\\":\\\"select * from data_dic where dic_pid = 0\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\",\\\"configValue\\\":\\\"dic_id\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\",\\\"configValue\\\":\\\"dic_name\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"int\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":249,\"order_no\":3,\"is_nullable\":false,\"is_primary\":false,\"field_length\":64,\"table_id\":17,\"field_name\":\"字典代码\",\"field_order\":5,\"field_key\":\"dic_code\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"varchar\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"eq\",\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"]},{\"attrs\":{\"field_id\":248,\"order_no\":4,\"is_nullable\":false,\"is_primary\":false,\"field_length\":128,\"table_id\":17,\"field_name\":\"字典名称\",\"field_order\":4,\"field_key\":\"dic_name\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"varchar\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":true,\"isRequired\":true,\"LAY_TABLE_INDEX\":3,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":true,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":247,\"order_no\":5,\"is_nullable\":false,\"is_primary\":false,\"field_length\":128,\"table_id\":17,\"field_name\":\"字典值\",\"field_order\":3,\"field_key\":\"dic_value\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"varchar\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":4,\"searchMethod\":\"eq\",\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"]},{\"attrs\":{\"field_id\":246,\"order_no\":6,\"is_nullable\":true,\"is_primary\":false,\"table_id\":17,\"field_name\":\"创建时间\",\"field_order\":2,\"field_key\":\"create_datetime\",\"field_config\":\"{}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"datetime\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":5,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":245,\"order_no\":7,\"is_nullable\":false,\"is_primary\":false,\"field_length\":1,\"table_id\":17,\"field_name\":\"是否启用\",\"field_order\":1,\"field_key\":\"is_enable\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"none\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-07-27 14:20:08\",\"field_type\":\"tinyint\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":6,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":350,\"order_no\":8,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":17,\"field_name\":\"排序号\",\"field_order\":8,\"field_key\":\"order_no\",\"create_datetime\":\"2020-10-14 11:31:10\",\"field_type\":\"int\",\"table_id_title\":\"数据字典\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":7,\"searchMethod\":\"eq\",\"checkers\":[\"/^[0-9]{0,}$/【数字】\"],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[\"/^[0-9]{0,}$/【数字】\"]}]}],\"releaseFieldsList\":[{\"releaseField1\":\"2.dic_pid\",\"releaseField2\":\"1.dic_id\",\"no\":\"1\"}]}', '2020-09-04 14:43:31');
INSERT INTO `sys_generator_model` VALUES ('12', '1', '操作权限', '{\"ctlUri\":\"/system/oper\",\"packagePath\":\"cc.jweb.adai.web.system.oper\",\"template\":{\"attrs\":{\"template_config\":\"[{\\\"title\\\":\\\"生成模式\\\",\\\"name\\\":\\\"mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"列表过滤\\\",\\\"name\\\":\\\"listFilter\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"列表过滤条件,如 t.pid = 0 or t.pid is null \\\",\\\"no\\\":\\\"2\\\"},{\\\"title\\\":\\\"表格类型\\\",\\\"name\\\":\\\"tableType\\\",\\\"value\\\":\\\"treeTable\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"3\\\"},{\\\"title\\\":\\\"树PID字段\\\",\\\"name\\\":\\\"tablePid\\\",\\\"value\\\":\\\"oper_pid\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表1表格类型为treeTable时有效\\\",\\\"no\\\":\\\"4\\\"}]\",\"is_system\":false,\"template_name\":\"标准单列表\",\"template_key\":\"std_single_model_list_crud\",\"official_id\":\"1\",\"thumb\":\"[{\\\"file_path\\\":\\\"20201102\\\\\\\\594c3ad01367499f9ab2b5e0946b3300.gif\\\",\\\"file_url\\\":\\\"/file/download?fileId=594c3ad01367499f9ab2b5e0946b3300\\\",\\\"create_datetime\\\":\\\"2020-11-02 19:03:04\\\",\\\"file_name\\\":\\\"GIF 2020-11-2 19-01-20.gif\\\",\\\"file_suffix\\\":\\\"gif\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"594c3ad01367499f9ab2b5e0946b3300\\\",\\\"file_size\\\":3266636}]\",\"author\":\"imlzw\",\"create_datetime\":\"2020-07-27 15:20:21\",\"table_require_count\":1,\"template_id\":\"1\",\"version\":\"0.0.1\",\"desc\":\"<h3><strong>简介</strong>:</h3><p style=\\\"margin-top: 5px;\\\">该模板用于单列表的数据展示,支持普通表格,树形表格。展示界面效果,如下图</p><p style=\\\"margin-top: 5px;\\\"><img src=\\\"/file/download?fileId=21bc9a91003b456ca94d465a9338f45a\\\"/></p><h3 style=\\\"margin-top: 5px;\\\"><strong>配置说明:</strong></h3><p style=\\\"margin-top: 5px;\\\">配置生成器时,模板包含如下参数:</p><p style=\\\"margin-top: 5px;\\\"><img src=\\\"/file/download?fileId=177f39e15e914e239997eca93904c40f\\\"/></p><p style=\\\"margin-top: 5px;\\\"><br/></p><p><br/></p><p><br/></p><p><br/></p><p><br/></p><p style=\\\"text-align: center;\\\"><br/></p>\"}},\"tables\":[{\"attrs\":{\"table_key\":\"sys_oper\",\"model_package\":\"cc.jweb.adai.web.system.oper.model\",\"create_datetime\":\"2020-09-27 14:28:53\",\"table_id\":28,\"table_name\":\"操作权限\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":333,\"order_no\":1,\"is_nullable\":false,\"is_primary\":true,\"field_length\":11,\"table_id\":28,\"field_name\":\"操作编号\",\"field_order\":1,\"field_key\":\"oper_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"int\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":330,\"order_no\":2,\"is_nullable\":false,\"is_primary\":false,\"field_length\":32,\"table_id\":28,\"field_name\":\"操作名称\",\"field_order\":2,\"field_key\":\"oper_name\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"varchar\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":true,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"like\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":true,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"like\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":357,\"order_no\":3,\"is_nullable\":false,\"is_primary\":false,\"field_length\":32,\"table_id\":28,\"field_name\":\"关键字\",\"field_order\":3,\"field_key\":\"oper_key\",\"create_datetime\":\"2020-10-15 10:29:18\",\"field_type\":\"varchar\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"like\",\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"like\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[\"/^[A-Za-z0-9_]+$/【英文、数字、下划线】\"]},{\"attrs\":{\"field_id\":332,\"order_no\":4,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":28,\"field_name\":\"上级操作\",\"field_order\":4,\"field_key\":\"oper_pid\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"sql\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\",\\\"configValue\\\":\\\"select * from sys_oper order by order_no asc\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\",\\\"configValue\\\":\\\"oper_id\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\",\\\"configValue\\\":\\\"oper_name\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\",\\\"configValue\\\":\\\"oper_pid\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"int\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":3,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":331,\"order_no\":5,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":28,\"field_name\":\"操作类型\",\"field_order\":5,\"field_key\":\"oper_type\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"enum\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[{\\\\\\\"title\\\\\\\":\\\\\\\"菜单\\\\\\\",\\\\\\\"value\\\\\\\":\\\\\\\"0\\\\\\\",\\\\\\\"no\\\\\\\":\\\\\\\"1\\\\\\\"},{\\\\\\\"title\\\\\\\":\\\\\\\"权限\\\\\\\",\\\\\\\"value\\\\\\\":\\\\\\\"1\\\\\\\",\\\\\\\"no\\\\\\\":\\\\\\\"2\\\\\\\"}]\\\"}}}}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"int\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":4,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":327,\"order_no\":6,\"is_nullable\":true,\"is_primary\":false,\"field_length\":128,\"table_id\":28,\"field_name\":\"操作路径\",\"field_order\":6,\"field_key\":\"oper_path\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"varchar\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":5,\"searchMethod\":\"like\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"like\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":328,\"order_no\":7,\"is_nullable\":false,\"is_primary\":false,\"field_length\":128,\"table_id\":28,\"field_name\":\"权限标识\",\"field_order\":7,\"field_key\":\"permission_key\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"varchar\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":6,\"searchMethod\":\"like\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"like\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":326,\"order_no\":8,\"is_nullable\":false,\"is_primary\":false,\"field_length\":1,\"table_id\":28,\"field_name\":\"状态\",\"field_order\":8,\"field_key\":\"status\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"enum\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[{\\\\\\\"title\\\\\\\":\\\\\\\"启用\\\\\\\",\\\\\\\"value\\\\\\\":\\\\\\\"1\\\\\\\",\\\\\\\"no\\\\\\\":\\\\\\\"1\\\\\\\"},{\\\\\\\"title\\\\\\\":\\\\\\\"禁用\\\\\\\",\\\\\\\"value\\\\\\\":\\\\\\\"0\\\\\\\",\\\\\\\"no\\\\\\\":\\\\\\\"2\\\\\\\"}]\\\"}}}}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"tinyint\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":7,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":329,\"order_no\":9,\"is_nullable\":true,\"is_primary\":false,\"field_length\":32,\"table_id\":28,\"field_name\":\"图标\",\"field_order\":9,\"field_key\":\"oper_icon\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"varchar\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":true,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":8,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"icon\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"icon\",\"isRequired\":false,\"checkers\":[]},{\"attrs\":{\"field_id\":324,\"order_no\":10,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":28,\"field_name\":\"排序号\",\"field_order\":10,\"field_key\":\"order_no\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"int\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":9,\"searchMethod\":\"eq\",\"checkers\":[\"/^[0-9]{0,}$/【数字】\"],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":false,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[\"/^[0-9]{0,}$/【数字】\"]},{\"attrs\":{\"field_id\":325,\"order_no\":12,\"is_nullable\":false,\"is_primary\":false,\"table_id\":28,\"field_name\":\"创建时间\",\"field_order\":11,\"field_key\":\"create_datetime\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-27 14:28:53\",\"field_type\":\"datetime\",\"table_id_title\":\"操作权限\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":false,\"LAY_TABLE_INDEX\":10,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"formComponent\":\"auto\",\"isCopyModel\":false},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":false,\"checkers\":[]}]}],\"releaseFieldsList\":[]}', '2020-09-27 14:41:43');
INSERT INTO `sys_generator_model` VALUES ('13', null, '组织机构', '{\"ctlUri\":\"/system/org\",\"packagePath\":\"cc.jweb.adai.web.system.org\",\"tables\":[],\"template\":{\"attrs\":{}},\"releaseFieldsList\":[]}', '2020-09-27 17:42:10');
INSERT INTO `sys_generator_model` VALUES ('17', '3', '角色人员权限', '{\"ctlUri\":\"/system/role\",\"packagePath\":\"cc.jweb.adai.web.system.role\",\"template\":{\"attrs\":{\"template_config\":\"[{\\\"title\\\":\\\"表1生成模式\\\",\\\"name\\\":\\\"table1Mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"1\\\"},{\\\"title\\\":\\\"表2生成模式\\\",\\\"name\\\":\\\"table2Mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"2\\\"},{\\\"title\\\":\\\"表3生成模式\\\",\\\"name\\\":\\\"table3Mode\\\",\\\"value\\\":\\\"CRUD\\\",\\\"desc\\\":\\\"模式说明:C:新建,R:查询,U:修改,D:删除。可自由组合配置\\\",\\\"no\\\":\\\"3\\\"},{\\\"title\\\":\\\"表1过滤条件\\\",\\\"name\\\":\\\"table1Filter\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"表1列表过滤条件,如 t.pid = 0 or t.pid is null \\\",\\\"no\\\":\\\"4\\\"},{\\\"title\\\":\\\"表2过滤条件\\\",\\\"name\\\":\\\"table2Filter\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"表2列表过滤条件,如 t.pid = 0 or t.pid is null \\\",\\\"no\\\":\\\"5\\\"},{\\\"title\\\":\\\"表3过滤条件\\\",\\\"name\\\":\\\"table3Filter\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"表3列表过滤条件,如 t.pid = 0 or t.pid is null \\\",\\\"no\\\":\\\"6\\\"},{\\\"title\\\":\\\"表1表格类型\\\",\\\"name\\\":\\\"table1Type\\\",\\\"value\\\":\\\"table\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"7\\\"},{\\\"title\\\":\\\"表2表格类型\\\",\\\"name\\\":\\\"table2Type\\\",\\\"value\\\":\\\"table\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"8\\\"},{\\\"title\\\":\\\"表3表格类型\\\",\\\"name\\\":\\\"table3Type\\\",\\\"value\\\":\\\"treeTable\\\",\\\"desc\\\":\\\"表格类型:table:普通表格,treeTable:树表格\\\",\\\"no\\\":\\\"9\\\"},{\\\"title\\\":\\\"表1树PID\\\",\\\"name\\\":\\\"table1Pid\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表1表格类型为treeTable时有效\\\",\\\"no\\\":\\\"10\\\"},{\\\"title\\\":\\\"表2树PID\\\",\\\"name\\\":\\\"table2Pid\\\",\\\"value\\\":\\\"\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表2表格类型为treeTable时有效\\\",\\\"no\\\":\\\"11\\\"},{\\\"title\\\":\\\"表3树PID\\\",\\\"name\\\":\\\"table3Pid\\\",\\\"value\\\":\\\"oper_pid\\\",\\\"desc\\\":\\\"树表格的PID字段名称,仅表3表格类型为treeTable时有效\\\",\\\"no\\\":\\\"12\\\"}]\",\"is_system\":false,\"template_name\":\"标准三列表(左1右2)\",\"template_key\":\"std_3_model_list_crud\",\"official_id\":\"3\",\"thumb\":\"[{\\\"file_path\\\":\\\"20201118\\\\\\\\ddb3e6b082e344eca9e7fe933d4baf67.gif\\\",\\\"file_url\\\":\\\"/file/download?fileId=ddb3e6b082e344eca9e7fe933d4baf67\\\",\\\"create_datetime\\\":\\\"2020-11-18 15:44:20\\\",\\\"file_name\\\":\\\"temp3.gif\\\",\\\"file_suffix\\\":\\\"gif\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"ddb3e6b082e344eca9e7fe933d4baf67\\\",\\\"file_size\\\":1311195},{\\\"file_path\\\":\\\"20201118\\\\\\\\db1425ea59724fdfa0d57757613cef28.jpg\\\",\\\"file_url\\\":\\\"/file/download?fileId=db1425ea59724fdfa0d57757613cef28\\\",\\\"create_datetime\\\":\\\"2020-11-18 15:44:43\\\",\\\"file_name\\\":\\\"QQ截图20201118154148.jpg\\\",\\\"file_suffix\\\":\\\"jpg\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"db1425ea59724fdfa0d57757613cef28\\\",\\\"file_size\\\":67140},{\\\"file_path\\\":\\\"20201118\\\\\\\\f9941d4a8c70473f80ff97a119a01793.jpg\\\",\\\"file_url\\\":\\\"/file/download?fileId=f9941d4a8c70473f80ff97a119a01793\\\",\\\"create_datetime\\\":\\\"2020-11-18 15:44:43\\\",\\\"file_name\\\":\\\"QQ截图20201118154208.jpg\\\",\\\"file_suffix\\\":\\\"jpg\\\",\\\"file_type\\\":\\\"IMAGE\\\",\\\"file_id\\\":\\\"f9941d4a8c70473f80ff97a119a01793\\\",\\\"file_size\\\":90654}]\",\"author\":\"imlzw\",\"create_datetime\":\"2020-09-30 11:59:39\",\"table_require_count\":3,\"template_id\":\"3\",\"version\":\"0.0.1\",\"desc\":\"<p>标准左右列表3列表模板,效果如下 :</p><p><img src=\\\"/file/download?fileId=479a5e71622446d0a7b71a6c3f2206ce\\\"/></p><p>其中,左边一个列表,右边两个列表,用tabPage页切换。</p><p>本模板参数如下:</p><p><img src=\\\"/file/download?fileId=0f1323c3b3704be99c2a405009bf9522\\\"/></p>\"}},\"tables\":[{\"attrs\":{\"table_key\":\"sys_role\",\"model_package\":\"cc.jweb.adai.web.system.role.model\",\"create_datetime\":\"2020-09-30 11:24:42\",\"table_id\":30,\"table_name\":\"角色\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":343,\"order_no\":1,\"is_nullable\":false,\"is_primary\":true,\"field_length\":11,\"table_id\":30,\"field_name\":\"角色编号\",\"field_order\":1,\"field_key\":\"role_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true}\",\"create_datetime\":\"2020-09-30 11:24:42\",\"field_type\":\"int\",\"table_id_title\":\"角色\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":342,\"order_no\":2,\"is_nullable\":false,\"is_primary\":false,\"field_length\":32,\"table_id\":30,\"field_name\":\"角色名称\",\"field_order\":2,\"field_key\":\"role_name\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-30 11:24:42\",\"field_type\":\"varchar\",\"table_id_title\":\"角色\",\"tableNo\":1,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":true,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"like\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":true,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"like\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":341,\"order_no\":3,\"is_nullable\":false,\"is_primary\":false,\"table_id\":30,\"field_name\":\"创建时间\",\"field_order\":3,\"field_key\":\"create_datetime\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-30 11:24:42\",\"field_type\":\"datetime\",\"table_id_title\":\"角色\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":340,\"order_no\":4,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":30,\"field_name\":\"上级角色\",\"field_order\":4,\"field_key\":\"role_pid\",\"field_config\":\"{}\",\"create_datetime\":\"2020-09-30 11:24:42\",\"field_type\":\"int\",\"table_id_title\":\"角色\",\"tableNo\":1,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":3,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]}]},{\"attrs\":{\"table_key\":\"sys_role_user\",\"model_package\":\"cc.jweb.adai.web.system.role.model\",\"create_datetime\":\"2020-09-30 11:26:10\",\"table_id\":31,\"table_name\":\"角色人员\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":349,\"order_no\":1,\"is_nullable\":false,\"is_primary\":true,\"field_length\":11,\"table_id\":31,\"field_name\":\"角色人员编号\",\"field_order\":2,\"field_key\":\"ru_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true,\\\"releaseType\\\":\\\"none\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-30 11:37:07\",\"field_type\":\"int\",\"table_id_title\":\"角色人员\",\"tableNo\":2,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":345,\"order_no\":2,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":31,\"field_name\":\"角色编号\",\"field_order\":1,\"field_key\":\"role_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"table\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\",\\\"configValue\\\":\\\"sys_role\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\",\\\"configValue\\\":\\\"role_id\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\",\\\"configValue\\\":\\\"role_name\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\",\\\"configValue\\\":\\\"\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-30 11:26:10\",\"field_type\":\"int\",\"table_id_title\":\"角色人员\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":344,\"order_no\":3,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":31,\"field_name\":\"人员编号\",\"field_order\":3,\"field_key\":\"user_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"table\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\",\\\"configValue\\\":\\\"sys_user\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\",\\\"configValue\\\":\\\"user_id\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\",\\\"configValue\\\":\\\"user_name\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\",\\\"configValue\\\":\\\"\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-30 11:26:10\",\"field_type\":\"int\",\"table_id_title\":\"角色人员\",\"tableNo\":2,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]}]},{\"attrs\":{\"table_key\":\"sys_role_oper\",\"model_package\":\"cc.jweb.adai.web.system.role.model\",\"create_datetime\":\"2020-09-30 11:27:33\",\"table_id\":32,\"table_name\":\"角色权限\"},\"fieldModelList\":[{\"attrs\":{\"field_id\":348,\"order_no\":1,\"is_nullable\":false,\"is_primary\":true,\"field_length\":11,\"table_id\":32,\"field_name\":\"角色权限编号\",\"field_order\":2,\"field_key\":\"ro_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":true,\\\"releaseType\\\":\\\"none\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-30 11:36:26\",\"field_type\":\"int\",\"table_id_title\":\"角色权限\",\"tableNo\":3,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":0,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":false,\"showInSearchForm\":false,\"showInList\":false,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":347,\"order_no\":2,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":32,\"field_name\":\"角色编号\",\"field_order\":1,\"field_key\":\"role_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"table\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\",\\\"configValue\\\":\\\"sys_role\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\",\\\"configValue\\\":\\\"role_id\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\",\\\"configValue\\\":\\\"role_name\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\",\\\"configValue\\\":\\\"\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-30 11:27:33\",\"field_type\":\"int\",\"table_id_title\":\"角色权限\",\"tableNo\":3,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":1,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]},{\"attrs\":{\"field_id\":346,\"order_no\":3,\"is_nullable\":false,\"is_primary\":false,\"field_length\":11,\"table_id\":32,\"field_name\":\"操作编号\",\"field_order\":3,\"field_key\":\"oper_id\",\"field_config\":\"{\\\"isAutoIncrease\\\":false,\\\"releaseType\\\":\\\"table\\\",\\\"releaseConfig\\\":{\\\"config\\\":{\\\"table\\\":{\\\"configZhName\\\":\\\"关联表\\\",\\\"configName\\\":\\\"table\\\",\\\"configValue\\\":\\\"sys_oper\\\"},\\\"fieldKey\\\":{\\\"configZhName\\\":\\\"关联字段\\\",\\\"configName\\\":\\\"fieldKey\\\",\\\"configValue\\\":\\\"oper_id\\\"},\\\"fieldTitle\\\":{\\\"configZhName\\\":\\\"显示字段\\\",\\\"configName\\\":\\\"fieldTitle\\\",\\\"configValue\\\":\\\"oper_name\\\"},\\\"fieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"fieldPKey\\\",\\\"configValue\\\":\\\"\\\"},\\\"dicId\\\":{\\\"configZhName\\\":\\\"关联字典\\\",\\\"configName\\\":\\\"dicId\\\"},\\\"sql\\\":{\\\"configZhName\\\":\\\"关联SQL语句\\\",\\\"configName\\\":\\\"sql\\\"},\\\"sqlFieldKey\\\":{\\\"configZhName\\\":\\\"SQL关联字段\\\",\\\"configName\\\":\\\"sqlFieldKey\\\"},\\\"sqlFieldTitle\\\":{\\\"configZhName\\\":\\\"SQL显示字段\\\",\\\"configName\\\":\\\"sqlFieldTitle\\\"},\\\"sqlFieldPKey\\\":{\\\"configZhName\\\":\\\"上级字段\\\",\\\"configName\\\":\\\"sqlFieldPKey\\\"},\\\"enumList\\\":{\\\"configZhName\\\":\\\"枚举列表\\\",\\\"configName\\\":\\\"enumList\\\",\\\"configValue\\\":\\\"[]\\\"}}}}\",\"create_datetime\":\"2020-09-30 11:27:33\",\"field_type\":\"int\",\"table_id_title\":\"角色权限\",\"tableNo\":3,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"isTitle\":false,\"isRequired\":true,\"LAY_TABLE_INDEX\":2,\"searchMethod\":\"eq\",\"checkers\":[],\"isNullable\":false,\"isPrimary\":false,\"isCopyModel\":false,\"formComponent\":\"auto\"},\"isTitle\":false,\"showInForm\":true,\"showInSearchForm\":true,\"showInList\":true,\"searchMethod\":\"eq\",\"formComponent\":\"auto\",\"isRequired\":true,\"checkers\":[]}]}],\"releaseFieldsList\":[{\"releaseField1\":\"1.role_id\",\"releaseField2\":\"2.role_id\",\"no\":\"1\"},{\"releaseField1\":\"1.role_id\",\"releaseField2\":\"3.role_id\",\"no\":\"2\"}]}', '2020-09