{"text_format":"2","workbook":"xlsx","n_sheets":53,"sheets":["数据结构清单","flow_definition","flow_his_task","flow_instance","flow_node","flow_skip","flow_task","flow_user","jetplasma_alteration_apply","jetplasma_demo","jetplasma_demo_execute","jetplasma_demo_execute_progress","jetplasma_demo_execute_view","jetplasma_device","jetplasma_device_attachment","jetplasma_device_component","jetplasma_device_defect","jetplasma_device_list","jetplasma_device_problem_all","jetplasma_device_problem_check","jetplasma_device_problem_instal","jetplasma_device_problem_reply","jetplasma_device_problem_sale","jetplasma_device_problem_test","jetplasma_device_sn","jetplasma_device_user","jetplasma_download_hist","jetplasma_ecn","jetplasma_ecn_meta","jetplasma_ecn_progress","jetplasma_ecn_spread","jetplasma_ecn_view","jetplasma_eco","jetplasma_eco_meta","jetplasma_eco_view","jetplasma_proj_type","sys_config","sys_dept","sys_dict_data","sys_dict_type","sys_job","sys_job_log","sys_logininfor","sys_menu","sys_notice","sys_oper_log","sys_post","sys_role","sys_role_dept","sys_role_menu","sys_user","sys_user_post","sys_user_role"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"数据结构清单","index":0,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2]]}
[null,"JET Product Traceability System数据字典"]
[null,"系统数据库中共有表52张"]
[null,"表名",null,"注释"]
[null,"flow_definition",null,"流程定义表"]
[null,"flow_his_task",null,"历史任务记录表"]
[null,"flow_instance",null,"流程实例表"]
[null,"flow_node",null,"流程结点表"]
[null,"flow_skip",null,"结点跳转关联表"]
[null,"flow_task",null,"待办任务表"]
[null,"flow_user",null,"流程用户表"]
[null,"jetplasma_alteration_apply",null,"变更申请表"]
[null,"jetplasma_demo",null,"DEMO申请表"]
[null,"jetplasma_demo_execute",null,"DEMO执行表"]
[null,"jetplasma_demo_execute_progress",null,"DEMO执行进度表"]
[null,"jetplasma_demo_execute_view",null,"DEMO执行查询视图"]
[null,"jetplasma_device",null,"设备表"]
[null,"jetplasma_device_attachment",null,"产品附件表"]
[null,"jetplasma_device_component",null,"设备核心物料清单"]
[null,"jetplasma_device_defect",null,"设备残件管理表"]
[null,"jetplasma_device_list",null,"设备核心物料清单"]
[null,"jetplasma_device_problem_all",null,"设备问题查询视图"]
[null,"jetplasma_device_problem_check",null,"设备组装问题登记表"]
[null,"jetplasma_device_problem_install",null,"设备组装问题登记表"]
[null,"jetplasma_device_problem_reply",null,"设备问题登记表"]
[null,"jetplasma_device_problem_sale",null,"设备售后问题登记表"]
[null,"jetplasma_device_problem_test",null,"设备测试问题登记表"]
[null,"jetplasma_device_sn",null,"设备部件SN列表"]
[null,"jetplasma_device_user",null,"设备类型与用户的权限配置表"]
[null,"jetplasma_download_hist",null,"附件下载历史表"]
[null,"jetplasma_ecn",null,"ECN执行"]
[null,"jetplasma_ecn_meta",null,"ECN执行辅助信息表"]
[null,"jetplasma_ecn_progress",null,"ECN执行进度"]
[null,"jetplasma_ecn_spread",null,"ECN展开机型"]
[null,"jetplasma_ecn_view",null,"ECN查询视图"]
[null,"jetplasma_eco",null,"ECO验证"]
[null,"jetplasma_eco_meta",null,"ECO验证辅助信息表"]
[null,"jetplasma_eco_view",null,"ECO查询视图"]
[null,"jetplasma_proj_type",null,"项目系列类型表"]
[null,"sys_config",null,"参数配置表"]
[null,"sys_dept",null,"部门表"]
[null,"sys_dict_data",null,"字典数据表"]
[null,"sys_dict_type",null,"字典类型表"]
[null,"sys_job",null,"定时任务调度表"]
[null,"sys_job_log",null,"定时任务调度日志表"]
[null,"sys_logininfor",null,"系统访问记录"]
[null,"sys_menu",null,"菜单权限表"]
[null,"sys_notice",null,"通知公告表"]
[null,"sys_oper_log",null,"操作日志记录"]
[null,"sys_post",null,"岗位信息表"]
[null,"sys_role",null,"角色信息表"]
[null,"sys_role_dept",null,"角色和部门关联表"]
[null,"sys_role_menu",null,"角色和菜单关联表"]
[null,"sys_user",null,"用户信息表"]
[null,"sys_user_post",null,"用户与岗位关联表"]
[null,"sys_user_role",null,"用户和角色关联表"]

{"sheet":"flow_definition","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,2,13,4],[13,5,13,9],[14,2,14,4],[14,5,14,9],[15,2,15,4],[15,5,15,9],[16,2,16,4],[16,5,16,9],[17,0,17,9],[18,0,18,9]]}
["表名/描述","flow_definition",null,null,null,"流程定义表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","20","0","不允许","是",null,"NULL","主键id"]
["flow_code","varchar","40","0","不允许","否",null,"NULL","流程编码"]
["flow_name","varchar","100","0","不允许","否",null,"NULL","流程名称"]
["version","varchar","20","0","不允许","否",null,"NULL","流程版本"]
["is_publish","tinyint","3","0","不允许","否",null,"0","是否发布（0未发布 1已发布 9失效）"]
["from_custom","char","1","0","允许","否",null,"N","审批表单是否自定义（Y是 N否）"]
["from_path","varchar","100","0","允许","否",null,"NULL","审批表单路径"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["Unique","BTREE","FLOW_CODE_VERSION",null,null,"VERSION"]
["Unique","BTREE","FLOW_CODE_VERSION",null,null,"FLOW_CODE"]
["初始化脚本"]
["CREATE TABLE `flow_definition` (\n  `id` bigint(20) unsigned NOT NULL COMMENT '主键id',\n  `flow_code` varchar(40) NOT NULL COMMENT '流程编码',\n  `flow_name` varchar(100) NOT NULL COMMENT '流程名称',\n  `version` varchar(20) NOT NULL COMMENT '流程版本',\n  `is_publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否发布（0未发布 1已发布 9失效）',\n  `from_custom` char(1) DEFAULT 'N' COMMENT '审批表单是否自定义（Y是 N否）',\n  `from_path` varchar(100) DEFAULT NULL COMMENT '审批表单路径',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE,\n  UNIQUE KEY `flow_code_version` (`flow_code`,`version`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程定义表'"]

{"sheet":"flow_his_task","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,2,20,4],[20,5,20,9],[21,2,21,4],[21,5,21,9],[22,0,22,9],[23,0,23,9]]}
["表名/描述","flow_his_task",null,null,null,"历史任务记录表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","20","0","不允许","是",null,"NULL","主键id"]
["definition_id","bigint","19","0","不允许","否",null,"NULL","对应flow_definition表的id"]
["instance_id","bigint","19","0","不允许","否",null,"NULL","对应flow_instance表的id"]
["task_id","bigint","19","0","不允许","否",null,"NULL","对应flow_task表的id"]
["node_code","varchar","100","0","允许","否",null,"NULL","开始节点编码"]
["node_name","varchar","100","0","允许","否",null,"NULL","开始节点名称"]
["node_type","tinyint","3","0","允许","否",null,"NULL","开始节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）"]
["target_node_code","varchar","100","0","允许","否",null,"NULL","目标节点编码"]
["target_node_name","varchar","100","0","允许","否",null,"NULL","结束节点名称"]
["approver","varchar","40","0","允许","否",null,"NULL","审批者"]
["cooperate_type","tinyint","3","0","允许","否",null,"0","协作方式(1或签 2转办 3委派 4会签 5票签 6加签 7减签)"]
["collaborator","varchar","40","0","允许","否",null,"NULL","协作人"]
["flow_status","tinyint","3","0","不允许","否",null,"NULL","流程状态（0待提交 1审批中 2 审批通过 8已完成 9已退回 10失效）"]
["message","varchar","500","0","允许","否",null,"NULL","审批意见"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `flow_his_task` (\n  `id` bigint(20) unsigned NOT NULL COMMENT '主键id',\n  `definition_id` bigint(20) NOT NULL COMMENT '对应flow_definition表的id',\n  `instance_id` bigint(20) NOT NULL COMMENT '对应flow_instance表的id',\n  `task_id` bigint(19) NOT NULL COMMENT '对应flow_task表的id',\n  `node_code` varchar(100) DEFAULT NULL COMMENT '开始节点编码',\n  `node_name` varchar(100) DEFAULT NULL COMMENT '开始节点名称',\n  `node_type` tinyint(1) DEFAULT NULL COMMENT '开始节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',\n  `target_node_code` varchar(100) DEFAULT NULL COMMENT '目标节点编码',\n  `target_node_name` varchar(100) DEFAULT NULL COMMENT '结束节点名称',\n  `approver` varchar(40) DEFAULT NULL COMMENT '审批者',\n  `cooperate_type` tinyint(1) DEFAULT '0' COMMENT '协作方式(1或签 2转办 3委派 4会签 5票签 6加签 7减签)',\n  `collaborator` varchar(40) DEFAULT NULL COMMENT '协作人',\n  `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已退回 10失效）',\n  `message` varchar(500) DEFAULT NULL COMMENT '审批意见',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='历史任务记录表'"]

{"sheet":"flow_instance","index":3,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,2,16,4],[16,5,16,9],[17,2,17,4],[17,5,17,9],[18,0,18,9],[19,0,19,9]]}
["表名/描述","flow_instance",null,null,null,"流程实例表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键id"]
["definition_id","bigint","19","0","不允许","否",null,"NULL","对应flow_definition表的id"]
["business_id","varchar","40","0","不允许","否",null,"NULL","业务id"]
["node_type","tinyint","3","0","不允许","否",null,"NULL","结点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）"]
["node_code","varchar","40","0","不允许","否",null,"NULL","流程节点编码"]
["node_name","varchar","100","0","允许","否",null,"NULL","流程节点名称"]
["variable","text","65535","0","允许","否",null,"NULL","任务变量"]
["flow_status","tinyint","3","0","不允许","否",null,"NULL","流程状态（0待提交 1审批中 2 审批通过 8已完成 9已退回 10失效）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["ext","varchar","500","0","允许","否",null,"NULL","扩展字段"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `flow_instance` (\n  `id` bigint(20) NOT NULL COMMENT '主键id',\n  `definition_id` bigint(20) NOT NULL COMMENT '对应flow_definition表的id',\n  `business_id` varchar(40) NOT NULL COMMENT '业务id',\n  `node_type` tinyint(1) NOT NULL COMMENT '结点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',\n  `node_code` varchar(40) NOT NULL COMMENT '流程节点编码',\n  `node_name` varchar(100) DEFAULT NULL COMMENT '流程节点名称',\n  `variable` text COMMENT '任务变量',\n  `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已退回 10失效）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `ext` varchar(500) DEFAULT NULL COMMENT '扩展字段',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程实例表'"]

{"sheet":"flow_node","index":4,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,2,20,4],[20,5,20,9],[21,2,21,4],[21,5,21,9],[22,2,22,4],[22,5,22,9],[23,2,23,4],[23,5,23,9],[24,0,24,9],[25,0,25,9]]}
["表名/描述","flow_node",null,null,null,"流程结点表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","20","0","不允许","是",null,"NULL","主键id"]
["node_type","tinyint","3","0","不允许","否",null,"NULL","节点类型（0开始节点 1中间节点 2结束结点 3互斥网关 4并行网关）"]
["definition_id","bigint","19","0","不允许","否",null,"NULL","流程定义id"]
["node_code","varchar","100","0","不允许","否",null,"NULL","流程节点编码"]
["node_name","varchar","100","0","允许","否",null,"NULL","流程节点名称"]
["node_ratio","decimal","6","3","允许","否",null,"NULL","流程签署比例值"]
["permission_flag","varchar","200","0","允许","否",null,"NULL","权限标识（权限类型:权限标识，可以多个，如role:1,role:2)"]
["coordinate","varchar","100","0","允许","否",null,"NULL","坐标"]
["skip_any_node","varchar","100","0","允许","否",null,"N","是否可以退回任意节点（Y是 N否）"]
["listener_type","varchar","100","0","允许","否",null,"NULL","监听器类型"]
["listener_path","varchar","400","0","允许","否",null,"NULL","监听器路径"]
["handler_type","varchar","100","0","允许","否",null,"NULL","处理器类型"]
["handler_path","varchar","400","0","允许","否",null,"NULL","处理器路径"]
["version","varchar","20","0","不允许","否",null,"NULL","版本"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["Unique","BTREE","INFO_ID_CODE",null,null,"NODE_CODE"]
["Unique","BTREE","INFO_ID_CODE",null,null,"DEFINITION_ID"]
["初始化脚本"]
["CREATE TABLE `flow_node` (\n  `id` bigint(20) unsigned NOT NULL COMMENT '主键id',\n  `node_type` tinyint(1) NOT NULL COMMENT '节点类型（0开始节点 1中间节点 2结束结点 3互斥网关 4并行网关）',\n  `definition_id` bigint(20) NOT NULL COMMENT '流程定义id',\n  `node_code` varchar(100) NOT NULL COMMENT '流程节点编码',\n  `node_name` varchar(100) DEFAULT NULL COMMENT '流程节点名称',\n  `node_ratio` decimal(6,3) DEFAULT NULL COMMENT '流程签署比例值',\n  `permission_flag` varchar(200) DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',\n  `coordinate` varchar(100) DEFAULT NULL COMMENT '坐标',\n  `skip_any_node` varchar(100) DEFAULT 'N' COMMENT '是否可以退回任意节点（Y是 N否）',\n  `listener_type` varchar(100) DEFAULT NULL COMMENT '监听器类型',\n  `listener_path` varchar(400) DEFAULT NULL COMMENT '监听器路径',\n  `handler_type` varchar(100) DEFAULT NULL COMMENT '处理器类型',\n  `handler_path` varchar(400) DEFAULT NULL COMMENT '处理器路径',\n  `version` varchar(20) NOT NULL COMMENT '版本',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE,\n  UNIQUE KEY `info_id_code` (`definition_id`,`node_code`) USING BTREE COMMENT '保证一个流程中node_code是唯一的'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程结点表'"]

{"sheet":"flow_skip","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,2,16,4],[16,5,16,9],[17,2,17,4],[17,5,17,9],[18,0,18,9],[19,0,19,9]]}
["表名/描述","flow_skip",null,null,null,"结点跳转关联表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","20","0","不允许","是",null,"NULL","主键id"]
["definition_id","bigint","19","0","不允许","否",null,"NULL","流程定义id"]
["now_node_code","varchar","100","0","不允许","否",null,"NULL","当前流程节点的编码"]
["now_node_type","tinyint","3","0","允许","否",null,"NULL","当前节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）"]
["next_node_code","varchar","100","0","不允许","否",null,"NULL","下一个流程节点的编码"]
["next_node_type","tinyint","3","0","允许","否",null,"NULL","下一个节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）"]
["skip_name","varchar","100","0","允许","否",null,"NULL","跳转名称"]
["skip_type","varchar","40","0","允许","否",null,"NULL","跳转类型（PASS审批通过 REJECT退回）"]
["skip_condition","varchar","200","0","允许","否",null,"NULL","跳转条件"]
["coordinate","varchar","100","0","允许","否",null,"NULL","坐标"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `flow_skip` (\n  `id` bigint(20) unsigned NOT NULL COMMENT '主键id',\n  `definition_id` bigint(20) NOT NULL COMMENT '流程定义id',\n  `now_node_code` varchar(100) NOT NULL COMMENT '当前流程节点的编码',\n  `now_node_type` tinyint(1) DEFAULT NULL COMMENT '当前节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',\n  `next_node_code` varchar(100) NOT NULL COMMENT '下一个流程节点的编码',\n  `next_node_type` tinyint(1) DEFAULT NULL COMMENT '下一个节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',\n  `skip_name` varchar(100) DEFAULT NULL COMMENT '跳转名称',\n  `skip_type` varchar(40) DEFAULT NULL COMMENT '跳转类型（PASS审批通过 REJECT退回）',\n  `skip_condition` varchar(200) DEFAULT NULL COMMENT '跳转条件',\n  `coordinate` varchar(100) DEFAULT NULL COMMENT '坐标',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='结点跳转关联表'"]

{"sheet":"flow_task","index":6,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","flow_task",null,null,null,"待办任务表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键id"]
["definition_id","bigint","19","0","不允许","否",null,"NULL","对应flow_definition表的id"]
["instance_id","bigint","19","0","不允许","否",null,"NULL","对应flow_instance表的id"]
["node_code","varchar","100","0","不允许","否",null,"NULL","节点编码"]
["node_name","varchar","100","0","允许","否",null,"NULL","节点名称"]
["node_type","tinyint","3","0","不允许","否",null,"NULL","节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `flow_task` (\n  `id` bigint(20) NOT NULL COMMENT '主键id',\n  `definition_id` bigint(20) NOT NULL COMMENT '对应flow_definition表的id',\n  `instance_id` bigint(20) NOT NULL COMMENT '对应flow_instance表的id',\n  `node_code` varchar(100) NOT NULL COMMENT '节点编码',\n  `node_name` varchar(100) DEFAULT NULL COMMENT '节点名称',\n  `node_type` tinyint(1) NOT NULL COMMENT '节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='待办任务表'"]

{"sheet":"flow_user","index":7,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,2,11,4],[11,5,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,2,14,4],[14,5,14,9],[15,0,15,9],[16,0,16,9]]}
["表名/描述","flow_user",null,null,null,"流程用户表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","20","0","不允许","是",null,"NULL","主键id"]
["type","char","1","0","不允许","否",null,"NULL","人员类型（1代办任务的审批人权限 2代办任务的转办人权限 3流程实例的抄送人权限 4待办任务的委托人权限）"]
["processed_by","varchar","80","0","允许","否",null,"NULL","权限人"]
["associated","bigint","19","0","不允许","否",null,"NULL","关联表id"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["create_by","varchar","80","0","允许","否",null,"NULL","创建人"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["del_flag","char","1","0","允许","否",null,"NULL","删除标志"]
["tenant_id","varchar","40","0","允许","否",null,"NULL","租户id"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["Normal","BTREE","USER_PROCESSED_TYPE",null,null,"TYPE"]
["Normal","BTREE","USER_PROCESSED_TYPE",null,null,"PROCESSED_BY"]
["初始化脚本"]
["CREATE TABLE `flow_user` (\n  `id` bigint(20) unsigned NOT NULL COMMENT '主键id',\n  `type` char(1) NOT NULL COMMENT '人员类型（1代办任务的审批人权限 2代办任务的转办人权限 3流程实例的抄送人权限 4待办任务的委托人权限）',\n  `processed_by` varchar(80) DEFAULT NULL COMMENT '权限人',\n  `associated` bigint(20) NOT NULL COMMENT '关联表id',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `create_by` varchar(80) DEFAULT NULL COMMENT '创建人',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `del_flag` char(1) DEFAULT NULL COMMENT '删除标志',\n  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',\n  PRIMARY KEY (`id`) USING BTREE,\n  KEY `user_processed_type` (`processed_by`,`type`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程用户表'"]

{"sheet":"jetplasma_alteration_apply","index":8,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,2,19,4],[19,5,19,9],[20,2,20,4],[20,5,20,9],[21,2,21,4],[21,5,21,9],[22,0,22,9],[23,0,23,9]]}
["表名/描述","jetplasma_alteration_apply",null,null,null,"变更申请表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["no","varchar","20","0","不允许","否",null,"NULL","申请编号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["type","varchar","20","0","不允许","否",null,"NULL","变更类型"]
["child_type","varchar","50","0","不允许","否",null,"NULL","变更子类型"]
["item_type","longtext",null,"0","不允许","否",null,"NULL","变更项目"]
["project","varchar","200","0","允许","否",null,"NULL","项目"]
["apply_depart","bigint","19","0","允许","否",null,"NULL","申请部门"]
["apply_user","bigint","19","0","允许","否",null,"NULL","申请人"]
["apply_date","datetime","NULL","0","允许","否",null,"NULL","申请日期"]
["reason","longtext",null,"0","允许","否",null,"NULL","变更原因"]
["description","longtext",null,"0","允许","否",null,"NULL","变更详细描述"]
["problem","longtext",null,"0","允许","否",null,"NULL","问题描述"]
["suggest","longtext",null,"0","允许","否",null,"NULL","改善建议"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核"]
["attachment","longtext",null,"0","允许","否",null,"NULL","附件"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["Unique","BTREE","JETPLASMA_ALTERATION_APPLY_NO_UINDEX",null,null,"NO"]
["初始化脚本"]
["CREATE TABLE `jetplasma_alteration_apply` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `no` varchar(20) NOT NULL COMMENT '申请编号',\n  `subject` varchar(200) DEFAULT NULL COMMENT '主题',\n  `type` varchar(20) NOT NULL COMMENT '变更类型',\n  `child_type` varchar(50) NOT NULL COMMENT '变更子类型',\n  `item_type` longtext NOT NULL COMMENT '变更项目',\n  `project` varchar(200) DEFAULT NULL COMMENT '项目',\n  `apply_depart` bigint(20) DEFAULT NULL COMMENT '申请部门',\n  `apply_user` bigint(20) DEFAULT NULL COMMENT '申请人',\n  `apply_date` datetime DEFAULT NULL COMMENT '申请日期',\n  `reason` longtext COMMENT '变更原因',\n  `description` longtext COMMENT '变更详细描述',\n  `problem` longtext COMMENT '问题描述',\n  `suggest` longtext COMMENT '改善建议',\n  `approve_status` int(11) DEFAULT NULL COMMENT '审核状态：1 - 创建， 2 - 审核中 3 - 已审核',\n  `attachment` longtext COMMENT '附件',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `jetplasma_alteration_apply_no_uindex` (`no`)\n) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COMMENT='变更申请表'"]

{"sheet":"jetplasma_demo","index":9,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,2,20,4],[20,5,20,9],[21,2,21,4],[21,5,21,9],[22,0,22,9],[23,0,23,9]]}
["表名/描述","jetplasma_demo",null,null,null,"DEMO申请表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["demo_no","varchar","20","0","允许","否",null,"NULL","申请单号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["customer","varchar","20","0","允许","否",null,"NULL","客户名称"]
["device_type","varchar","200","0","允许","否",null,"NULL","产品类型"]
["order_num","int","10","0","允许","否",null,"NULL","预计订单量"]
["requirements","longtext","4294967295","0","允许","否",null,"NULL","技术要求"]
["saler","varchar","200","0","允许","否",null,"NULL","负责销售"]
["delivery","datetime","NULL","0","允许","否",null,"NULL","预计交付日期"]
["wafer_day","datetime","NULL","0","允许","否",null,"NULL","Wafer交付日期"]
["blanket_qty","varchar","100","0","允许","否",null,"NULL","Blanket Qty"]
["pattern_qty","varchar","100","0","允许","否",null,"NULL","Pattern Qty"]
["structure_qty","varchar","100","0","允许","否",null,"NULL","Structure Qty"]
["wafer_return","varchar","100","0","允许","否",null,"NULL","Wafer Return Or Not"]
["por_chamber","varchar","100","0","允许","否",null,"NULL","POR chamber type"]
["attachment","varchar","100","0","允许","否",null,"NULL","技术要求附件"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_demo` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `demo_no` varchar(20) DEFAULT NULL COMMENT '申请单号',\n  `subject` varchar(200) DEFAULT NULL COMMENT '主题',\n  `customer` varchar(20) DEFAULT NULL COMMENT '客户名称',\n  `device_type` varchar(200) DEFAULT NULL COMMENT '产品类型',\n  `order_num` int(4) DEFAULT NULL COMMENT '预计订单量',\n  `requirements` longtext COMMENT '技术要求',\n  `saler` varchar(200) DEFAULT NULL COMMENT '负责销售',\n  `delivery` datetime DEFAULT NULL COMMENT '预计交付日期',\n  `wafer_day` datetime DEFAULT NULL COMMENT 'Wafer交付日期',\n  `blanket_qty` varchar(100) DEFAULT NULL COMMENT 'Blanket Qty',\n  `pattern_qty` varchar(100) DEFAULT NULL COMMENT 'Pattern Qty',\n  `structure_qty` varchar(100) DEFAULT NULL COMMENT 'Structure Qty',\n  `wafer_return` varchar(100) DEFAULT NULL COMMENT 'Wafer Return Or Not',\n  `por_chamber` varchar(100) DEFAULT NULL COMMENT 'POR chamber type',\n  `attachment` varchar(100) DEFAULT NULL COMMENT '技术要求附件',\n  `approve_status` int(1) DEFAULT NULL COMMENT '审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='DEMO申请表'"]

{"sheet":"jetplasma_demo_execute","index":10,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,2,15,4],[15,5,15,9],[16,2,16,4],[16,5,16,9],[17,0,17,9],[18,0,18,9]]}
["表名/描述","jetplasma_demo_execute",null,null,null,"DEMO执行表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["demo_id","bigint","19","0","允许","否",null,"NULL","DEMO编号"]
["exec_no","varchar","20","0","允许","否",null,"NULL","执行编号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["exec_date","datetime","NULL","0","允许","否",null,"NULL","执行日期"]
["principals","varchar","200","0","允许","否",null,"NULL","执行负责人"]
["exec_status","int","10","0","允许","否",null,"NULL","执行状态：1 - 进行中, 2 - 已完成"]
["exec_result","varchar","20","0","允许","否",null,"NULL","执行结果， positive match、partial match、miss match"]
["suggestion","longtext","4294967295","0","允许","否",null,"NULL","建议"]
["conclusion","longtext","4294967295","0","允许","否",null,"NULL","销售结论"]
["attachment","varchar","200","0","允许","否",null,"NULL","附件"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_demo_execute` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `demo_id` bigint(20) DEFAULT NULL COMMENT 'DEMO编号',\n  `exec_no` varchar(20) DEFAULT NULL COMMENT '执行编号',\n  `subject` varchar(200) DEFAULT NULL COMMENT '主题',\n  `exec_date` datetime DEFAULT NULL COMMENT '执行日期',\n  `principals` varchar(200) DEFAULT NULL COMMENT '执行负责人',\n  `exec_status` int(1) DEFAULT NULL COMMENT '执行状态：1 - 进行中, 2 - 已完成',\n  `exec_result` varchar(20) DEFAULT NULL COMMENT '执行结果， positive match、partial match、miss match',\n  `suggestion` longtext COMMENT '建议',\n  `conclusion` longtext COMMENT '销售结论',\n  `attachment` varchar(200) DEFAULT NULL COMMENT '附件',\n  `approve_status` int(1) DEFAULT NULL COMMENT '审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='DEMO执行表'"]

{"sheet":"jetplasma_demo_execute_progress","index":11,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,2,8,4],[8,5,8,9],[9,2,9,4],[9,5,9,9],[10,0,10,9],[11,0,11,9]]}
["表名/描述","jetplasma_demo_execute_progress",null,null,null,"DEMO执行进度表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["exec_id","bigint","19","0","允许","否",null,"NULL","demo执行ID"]
["description","longtext","4294967295","0","允许","否",null,"NULL","执行进展描述"]
["report","varchar","200","0","允许","否",null,"NULL","阶段成果报告"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_demo_execute_progress` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `exec_id` bigint(20) DEFAULT NULL COMMENT 'demo执行ID',\n  `description` longtext COMMENT '执行进展描述',\n  `report` varchar(200) DEFAULT NULL COMMENT '阶段成果报告',\n  `approve_status` int(1) DEFAULT NULL COMMENT '审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='DEMO执行进度表'"]

{"sheet":"jetplasma_demo_execute_view","index":12,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,2,19,4],[19,5,19,9],[20,0,20,9],[21,0,21,9]]}
["表名/描述","jetplasma_demo_execute_view",null,null,null,"VIEW",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","否",null,"0","主键ID"]
["demo_id","bigint","19","0","允许","否",null,"NULL","DEMO编号"]
["exec_no","varchar","20","0","允许","否",null,"NULL","执行编号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["exec_date","datetime","NULL","0","允许","否",null,"NULL","执行日期"]
["principals","varchar","200","0","允许","否",null,"NULL","执行负责人"]
["exec_status","int","10","0","允许","否",null,"NULL","执行状态：1 - 进行中, 2 - 已完成"]
["exec_result","varchar","20","0","允许","否",null,"NULL","执行结果， positive match、partial match、miss match"]
["suggestion","longtext","4294967295","0","允许","否",null,"NULL","建议"]
["conclusion","longtext","4294967295","0","允许","否",null,"NULL","销售结论"]
["attachment","varchar","200","0","允许","否",null,"NULL","附件"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核, 4 - 审核未通过"]
["create_at","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["customer","varchar","20","0","允许","否",null,"NULL","客户名称"]
["device_type","varchar","200","0","允许","否",null,"NULL","产品类型"]
["saler","varchar","200","0","允许","否",null,"NULL","负责销售"]
["requirements","longtext","4294967295","0","允许","否",null,"NULL","技术要求"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["初始化脚本"]
["CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jetplasma_demo_execute_view` AS select `e`.`id` AS `id`,`e`.`demo_id` AS `demo_id`,`e`.`exec_no` AS `exec_no`,`e`.`subject` AS `subject`,`e`.`exec_date` AS `exec_date`,`e`.`principals` AS `principals`,`e`.`exec_status` AS `exec_status`,`e`.`exec_result` AS `exec_result`,`e`.`suggestion` AS `suggestion`,`e`.`conclusion` AS `conclusion`,`e`.`attachment` AS `attachment`,`e`.`approve_status` AS `approve_status`,`e`.`create_at` AS `create_at`,`d`.`customer` AS `customer`,`d`.`device_type` AS `device_type`,`d`.`saler` AS `saler`,`d`.`requirements` AS `requirements` from (`jetplasma_demo` `d` join `jetplasma_demo_execute` `e`) where (`d`.`id` = `e`.`demo_id`)"]

{"sheet":"jetplasma_device","index":13,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,2,26,4],[26,5,26,9],[27,2,27,4],[27,5,27,9],[28,0,28,9],[29,0,29,9]]}
["表名/描述","jetplasma_device",null,null,null,"设备表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","设备ID"]
["device_no","varchar","20","0","不允许","否",null,"NULL","设备编号"]
["name","varchar","50","0","不允许","否",null,"NULL","设备名称"]
["proj_number","varchar","30","0","允许","否",null,"NULL","项目号"]
["order_no","varchar","20","0","允许","否",null,"NULL","订单编号"]
["customer_name","varchar","50","0","允许","否",null,"NULL","客户名称"]
["salesman","bigint","19","0","允许","否",null,"NULL","负责销售"]
["serial_number","varchar","30","0","允许","否",null,"NULL","序列号"]
["create_user","varchar","30","0","不允许","否",null,"NULL","录入人员"]
["delivery_date","varchar","10","0","不允许","否",null,"NULL","交付日期"]
["planned_date","varchar","10","0","允许","否",null,"NULL","计划交付日期"]
["acceptance_date","varchar","10","0","允许","否",null,"NULL","验收日期"]
["maintain_date","varchar","10","0","允许","否",null,"NULL","维保日期"]
["extended_date","varchar","60","0","允许","否",null,"NULL","延保日期"]
["maintain_start","varchar","10","0","允许","否",null,"NULL","维保开始日期"]
["maintain_end","varchar","10","0","允许","否",null,"NULL","维保结束日期"]
["device_type","varchar","10","0","允许","否",null,"NULL","设备类型"]
["attach_first","varchar","100","0","允许","否",null,"NULL","技术协议"]
["attach_inventory","varchar","100","0","允许","否",null,"NULL","核心物料清单"]
["attach_receipt","varchar","100","0","允许","否",null,"NULL","验收单"]
["status","int","10","0","不允许","否",null,"NULL","设备状态, 1: 录入， 2: 安装， 3: 验收前， 4：验收后， 5：过保  -1:作废"]
["in_approve","bigint","19","0","允许","否",null,"NULL","审核状态： 1：创建  2：审批中  3:审批不通过 4.审批通过"]
["approve_type","bigint","19","0","允许","否",null,"NULL","在途审核类型"]
["create_at","timestamp","NULL","0","不允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '设备ID',\n  `device_no` varchar(20) NOT NULL COMMENT '设备编号',\n  `name` varchar(50) NOT NULL COMMENT '设备名称',\n  `proj_number` varchar(30) DEFAULT NULL COMMENT '项目号',\n  `order_no` varchar(20) DEFAULT NULL COMMENT '订单编号',\n  `customer_name` varchar(50) DEFAULT NULL COMMENT '客户名称',\n  `salesman` bigint(20) DEFAULT NULL COMMENT '负责销售',\n  `serial_number` varchar(30) DEFAULT NULL COMMENT '序列号',\n  `create_user` varchar(30) NOT NULL COMMENT '录入人员',\n  `delivery_date` varchar(10) NOT NULL COMMENT '交付日期',\n  `planned_date` varchar(10) DEFAULT NULL COMMENT '计划交付日期',\n  `acceptance_date` varchar(10) DEFAULT NULL COMMENT '验收日期',\n  `maintain_date` varchar(10) DEFAULT NULL COMMENT '维保日期',\n  `extended_date` varchar(60) DEFAULT NULL COMMENT '延保日期',\n  `maintain_start` varchar(10) DEFAULT NULL COMMENT '维保开始日期',\n  `maintain_end` varchar(10) DEFAULT NULL COMMENT '维保结束日期',\n  `device_type` varchar(10) DEFAULT NULL COMMENT '设备类型',\n  `attach_first` varchar(100) DEFAULT NULL COMMENT '技术协议',\n  `attach_inventory` varchar(100) DEFAULT NULL COMMENT '核心物料清单',\n  `attach_receipt` varchar(100) DEFAULT NULL COMMENT '验收单',\n  `status` int(2) NOT NULL COMMENT '设备状态, 1: 录入， 2: 安装， 3: 验收前， 4：验收后， 5：过保  -1:作废',\n  `in_approve` bigint(20) DEFAULT NULL COMMENT '审核状态： 1：创建  2：审批中  3:审批不通过 4.审批通过',\n  `approve_type` bigint(20) DEFAULT NULL COMMENT '在途审核类型',\n  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='设备表'"]

{"sheet":"jetplasma_device_attachment","index":14,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,2,7,4],[7,5,7,9],[8,2,8,4],[8,5,8,9],[9,0,9,9],[10,0,10,9]]}
["表名/描述","jetplasma_device_attachment",null,null,null,"产品附件表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","id"]
["device_id","bigint","19","0","允许","否",null,"NULL","产品id"]
["files_type","varchar","50","0","允许","否",null,"NULL","文件类型"]
["files_url","varchar","200","0","允许","否",null,"NULL","文件路径"]
["creat_time","varchar","50","0","允许","否",null,"NULL","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_attachment` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',\n  `device_id` bigint(20) DEFAULT NULL COMMENT '产品id',\n  `files_type` varchar(50) DEFAULT NULL COMMENT '文件类型',\n  `files_url` varchar(200) DEFAULT NULL COMMENT '文件路径',\n  `creat_time` varchar(50) DEFAULT NULL COMMENT '创建时间',\n  PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='产品附件表'"]

{"sheet":"jetplasma_device_component","index":15,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,2,8,4],[8,5,8,9],[9,2,9,4],[9,5,9,9],[10,0,10,9],[11,0,11,9]]}
["表名/描述","jetplasma_device_component",null,null,null,"设备核心物料清单",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","设备ID"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备编号"]
["sntrace","varchar","50","0","不允许","否",null,"NULL","S/N序列号"]
["comp_number","varchar","50","0","不允许","否",null,"NULL","部件编号"]
["name","varchar","50","0","不允许","否",null,"NULL","名称"]
["number","varchar","20","0","允许","否",null,"NULL","数量"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_component` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '设备ID',\n  `device_id` bigint(20) NOT NULL COMMENT '设备编号',\n  `sntrace` varchar(50) NOT NULL COMMENT 'S/N序列号',\n  `comp_number` varchar(50) NOT NULL COMMENT '部件编号',\n  `name` varchar(50) NOT NULL COMMENT '名称',\n  `number` varchar(20) DEFAULT NULL COMMENT '数量',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='设备核心物料清单'"]

{"sheet":"jetplasma_device_defect","index":16,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,2,13,4],[13,5,13,9],[14,2,14,4],[14,5,14,9],[15,0,15,9],[16,0,16,9]]}
["表名/描述","jetplasma_device_defect",null,null,null,"设备残件管理表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键"]
["serial_number","bigint","19","0","不允许","否",null,"NULL","序号"]
["materiel_no","varchar","20","0","不允许","否",null,"NULL","物料编码"]
["materiel_desc","varchar","200","0","允许","否",null,"NULL","物料描述"]
["quantity","bigint","19","0","允许","否",null,"NULL","数量"]
["delivery_date","varchar","20","0","允许","否",null,"NULL","交期"]
["principal","bigint","19","0","允许","否",null,"NULL","负责人"]
["pro_no","varchar","50","0","允许","否",null,"NULL","问题编号"]
["pro_table","varchar","20","0","允许","否",null,"NULL","问题表名"]
["device_id","bigint","19","0","允许","否",null,"NULL","设备ID"]
["approve_status","int","10","0","允许","否",null,"NULL","状态,1 - 待处理, 2 - 已解决, 3 - 关闭,4 - 审核中,5 - 审核不通过，6-审核通过"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_defect` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',\n  `serial_number` bigint(20) NOT NULL COMMENT '序号',\n  `materiel_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '物料编码',\n  `materiel_desc` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '物料描述',\n  `quantity` bigint(20) DEFAULT NULL COMMENT '数量',\n  `delivery_date` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '交期',\n  `principal` bigint(20) DEFAULT NULL COMMENT '负责人',\n  `pro_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '问题编号',\n  `pro_table` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '问题表名',\n  `device_id` bigint(20) DEFAULT NULL COMMENT '设备ID',\n  `approve_status` int(11) DEFAULT NULL COMMENT '状态,1 - 待处理, 2 - 已解决, 3 - 关闭,4 - 审核中,5 - 审核不通过，6-审核通过',\n  PRIMARY KEY (`id`) USING BTREE\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='设备残件管理表'"]

{"sheet":"jetplasma_device_list","index":17,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,2,13,4],[13,5,13,9],[14,2,14,4],[14,5,14,9],[15,0,15,9],[16,0,16,9]]}
["表名/描述","jetplasma_device_list",null,null,null,"设备核心物料清单",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","设备ID"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备编号"]
["sntrace","varchar","50","0","不允许","否",null,"NULL","S/N序列号"]
["comp_number","varchar","50","0","不允许","否",null,"NULL","部件编号"]
["name","varchar","50","0","不允许","否",null,"NULL","名称"]
["number","varchar","20","0","允许","否",null,"NULL","数量"]
["sn1","varchar","50","0","允许","否",null,"NULL","sn1"]
["sn2","varchar","50","0","允许","否",null,"NULL","sn2"]
["sn3","varchar","50","0","允许","否",null,"NULL","sn3"]
["sn4","varchar","50","0","允许","否",null,"NULL","sn4"]
["remark","varchar","50","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_list` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '设备ID',\n  `device_id` bigint(20) NOT NULL COMMENT '设备编号',\n  `sntrace` varchar(50) NOT NULL COMMENT 'S/N序列号',\n  `comp_number` varchar(50) NOT NULL COMMENT '部件编号',\n  `name` varchar(50) NOT NULL COMMENT '名称',\n  `number` varchar(20) DEFAULT NULL COMMENT '数量',\n  `sn1` varchar(50) DEFAULT NULL COMMENT 'sn1',\n  `sn2` varchar(50) DEFAULT NULL COMMENT 'sn2',\n  `sn3` varchar(50) DEFAULT NULL COMMENT 'sn3',\n  `sn4` varchar(50) DEFAULT NULL COMMENT 'sn4',\n  `remark` varchar(50) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='设备核心物料清单'"]

{"sheet":"jetplasma_device_problem_all","index":18,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,2,16,4],[16,5,16,9],[17,0,17,9],[18,0,18,9]]}
["表名/描述","jetplasma_device_problem_all",null,null,null,"VIEW",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["pro_no","varchar","50","0","允许","否",null,"NULL",""]
["device_id","bigint","19","0","不允许","否",null,"0",""]
["type","varchar","20","0","不允许","否",null,"",""]
["subject","varchar","50","0","允许","否",null,"NULL",""]
["depart_id","bigint","19","0","不允许","否",null,"0",""]
["user_id","bigint","19","0","不允许","否",null,"0",""]
["principal","bigint","19","0","不允许","否",null,"0",""]
["create_at","datetime","NULL","0","允许","否",null,"NULL",""]
["complete_date","datetime","NULL","0","允许","否",null,"NULL",""]
["status","int","10","0","允许","否",null,"NULL",""]
["expect_date","datetime","NULL","0","允许","否",null,"NULL",""]
["pro_type","varchar","7","0","不允许","否",null,"",""]
["case_id","varchar","6","0","允许","否",null,"NULL",""]
["id","bigint","19","0","不允许","否",null,"0",""]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["初始化脚本"]
["CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jetplasma_device_problem_all` AS select `jetplasma_device_problem_install`.`pro_no` AS `pro_no`,`jetplasma_device_problem_install`.`device_id` AS `device_id`,`jetplasma_device_problem_install`.`type` AS `type`,`jetplasma_device_problem_install`.`subject` AS `subject`,`jetplasma_device_problem_install`.`depart_id` AS `depart_id`,`jetplasma_device_problem_install`.`user_id` AS `user_id`,`jetplasma_device_problem_install`.`principal` AS `principal`,`jetplasma_device_problem_install`.`CREATE_AT` AS `create_at`,`jetplasma_device_problem_install`.`complete_date` AS `complete_date`,`jetplasma_device_problem_install`.`status` AS `status`,NULL AS `expect_date`,'install' AS `pro_type`,`jetplasma_device_problem_install`.`case_id` AS `case_id`,`jetplasma_device_problem_install`.`id` AS `id` from `jetplasma_device_problem_install` union all select `jetplasma_device_problem_test`.`pro_no` AS `pro_no`,`jetplasma_device_problem_test`.`device_id` AS `device_id`,`jetplasma_device_problem_test`.`type` AS `type`,`jetplasma_device_problem_test`.`subject` AS `subject`,`jetplasma_device_problem_test`.`depart_id` AS `depart_id`,`jetplasma_device_problem_test`.`user_id` AS `user_id`,`jetplasma_device_problem_test`.`principal` AS `principal`,`jetplasma_device_problem_test`.`CREATE_AT` AS `create_at`,`jetplasma_device_problem_test`.`complete_date` AS `complete_date`,`jetplasma_device_problem_test`.`status` AS `status`,NULL AS `expect_date`,'test' AS `pro_type`,`jetplasma_device_problem_test`.`case_id` AS `case_id`,`jetplasma_device_problem_test`.`id` AS `id` from `jetplasma_device_problem_test` union all select `jetplasma_device_problem_check`.`pro_no` AS `pro_no`,`jetplasma_device_problem_check`.`device_id` AS `device_id`,`jetplasma_device_problem_check`.`type` AS `type`,`jetplasma_device_problem_check`.`subject` AS `subject`,`jetplasma_device_problem_check`.`depart_id` AS `depart_id`,`jetplasma_device_problem_check`.`user_id` AS `user_id`,`jetplasma_device_problem_check`.`principal` AS `principal`,`jetplasma_device_problem_check`.`CREATE_AT` AS `create_at`,`jetplasma_device_problem_check`.`complete_date` AS `complete_date`,`jetplasma_device_problem_check`.`status` AS `status`,NULL AS `expect_date`,'check' AS `pro_type`,`jetplasma_device_problem_check`.`case_id` AS `case_id`,`jetplasma_device_problem_check`.`id` AS `id` from `jetplasma_device_problem_check` union all select `jetplasma_device_problem_sale`.`pro_no` AS `pro_no`,`jetplasma_device_problem_sale`.`device_id` AS `device_id`,`jetplasma_device_problem_sale`.`type` AS `type`,`jetplasma_device_problem_sale`.`subject` AS `subject`,`jetplasma_device_problem_sale`.`depart_id` AS `depart_id`,`jetplasma_device_problem_sale`.`user_id` AS `user_id`,`jetplasma_device_problem_sale`.`principal` AS `principal`,`jetplasma_device_problem_sale`.`CREATE_AT` AS `create_at`,`jetplasma_device_problem_sale`.`complete_date` AS `complete_date`,`jetplasma_device_problem_sale`.`status` AS `status`,`jetplasma_device_problem_sale`.`expect_date` AS `expect_date`,'sale' AS `pro_type`,`jetplasma_device_problem_sale`.`case_id` AS `case_id`,`jetplasma_device_problem_sale`.`id` AS `id` from `jetplasma_device_problem_sale`"]

{"sheet":"jetplasma_device_problem_check","index":19,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,2,20,4],[20,5,20,9],[21,2,21,4],[21,5,21,9],[22,0,22,9],[23,0,23,9]]}
["表名/描述","jetplasma_device_problem_check",null,null,null,"设备组装问题登记表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","问题ID"]
["pro_no","varchar","50","0","允许","否",null,"NULL","问题编号"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备ID"]
["type","varchar","20","0","不允许","否",null,"NULL","问题类型"]
["depart_id","bigint","19","0","不允许","否",null,"NULL","提出部门"]
["user_id","bigint","19","0","不允许","否",null,"NULL","提出人"]
["principal","bigint","19","0","不允许","否",null,"NULL","负责人"]
["CREATE_AT","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP",""]
["complete_date","datetime","NULL","0","允许","否",null,"NULL","实际完成日期"]
["subject","varchar","50","0","允许","否",null,"NULL","主题"]
["description","longtext","4294967295","0","不允许","否",null,"NULL","问题描述"]
["reply_date","varchar","12","0","允许","否",null,"NULL","回复日期"]
["status","int","10","0","允许","否",null,"NULL","状态,1 - 待处理, 2 - 已解决, 3 - 关闭"]
["check_stage","varchar","3","0","允许","否",null,"NULL","验收阶段"]
["device_status","varchar","8","0","允许","否",null,"NULL","设备状态"]
["remark","varchar","20","0","允许","否",null,"NULL","备注"]
["case_id","varchar","6","0","允许","否",null,"NULL","问题自增序列号"]
["description_files","varchar","1000","0","允许","否",null,"NULL","问题描述附件"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_problem_check` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '问题ID',\n  `pro_no` varchar(50) DEFAULT NULL COMMENT '问题编号',\n  `device_id` bigint(20) NOT NULL COMMENT '设备ID',\n  `type` varchar(20) NOT NULL COMMENT '问题类型',\n  `depart_id` bigint(20) NOT NULL COMMENT '提出部门',\n  `user_id` bigint(20) NOT NULL COMMENT '提出人',\n  `principal` bigint(20) NOT NULL COMMENT '负责人',\n  `CREATE_AT` datetime DEFAULT CURRENT_TIMESTAMP,\n  `complete_date` datetime DEFAULT NULL COMMENT '实际完成日期',\n  `subject` varchar(50) DEFAULT NULL COMMENT '主题',\n  `description` longtext NOT NULL COMMENT '问题描述',\n  `reply_date` varchar(12) DEFAULT NULL COMMENT '回复日期',\n  `status` int(1) DEFAULT NULL COMMENT '状态,1 - 待处理, 2 - 已解决, 3 - 关闭',\n  `check_stage` varchar(3) DEFAULT NULL COMMENT '验收阶段',\n  `device_status` varchar(8) DEFAULT NULL COMMENT '设备状态',\n  `remark` varchar(20) DEFAULT NULL COMMENT '备注',\n  `case_id` varchar(6) DEFAULT NULL COMMENT '问题自增序列号',\n  `description_files` varchar(1000) DEFAULT NULL COMMENT '问题描述附件',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='设备组装问题登记表'"]

{"sheet":"jetplasma_device_problem_instal","index":20,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,2,21,4],[21,5,21,9],[22,2,22,4],[22,5,22,9],[23,0,23,9],[24,0,24,9]]}
["表名/描述","jetplasma_device_problem_install",null,null,null,"设备组装问题登记表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","问题ID"]
["pro_no","varchar","50","0","允许","否",null,"NULL","问题编号"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备ID"]
["type","varchar","20","0","不允许","否",null,"NULL","问题类型"]
["depart_id","bigint","19","0","不允许","否",null,"NULL","提出部门"]
["user_id","bigint","19","0","不允许","否",null,"NULL","提出人"]
["principal","bigint","19","0","不允许","否",null,"NULL","负责人"]
["CREATE_AT","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP",""]
["complete_date","datetime","NULL","0","允许","否",null,"NULL","实际完成日期"]
["subject","varchar","50","0","允许","否",null,"NULL","主题"]
["description","longtext","4294967295","0","不允许","否",null,"NULL","问题描述"]
["reply_date","varchar","12","0","允许","否",null,"NULL","回复日期"]
["status","int","10","0","允许","否",null,"NULL","状态,1 - 待处理, 2 - 已解决, 3 - 关闭,4 - 审核中,5 - 审核不通过，6-审核通过"]
["deliver_status","varchar","2","0","允许","否",null,"NULL","缺陷发货 0 - 是, 1 - 否"]
["station","varchar","20","0","允许","否",null,"NULL","工位"]
["module_type","varchar","20","0","允许","否",null,"NULL","所属模块"]
["remark","varchar","20","0","允许","否",null,"NULL","备注"]
["case_id","varchar","6","0","允许","否",null,"NULL","问题自增序列号"]
["description_files","varchar","1000","0","允许","否",null,"NULL","问题描述附件"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_problem_install` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '问题ID',\n  `pro_no` varchar(50) DEFAULT NULL COMMENT '问题编号',\n  `device_id` bigint(20) NOT NULL COMMENT '设备ID',\n  `type` varchar(20) NOT NULL COMMENT '问题类型',\n  `depart_id` bigint(20) NOT NULL COMMENT '提出部门',\n  `user_id` bigint(20) NOT NULL COMMENT '提出人',\n  `principal` bigint(20) NOT NULL COMMENT '负责人',\n  `CREATE_AT` datetime DEFAULT CURRENT_TIMESTAMP,\n  `complete_date` datetime DEFAULT NULL COMMENT '实际完成日期',\n  `subject` varchar(50) DEFAULT NULL COMMENT '主题',\n  `description` longtext NOT NULL COMMENT '问题描述',\n  `reply_date` varchar(12) DEFAULT NULL COMMENT '回复日期',\n  `status` int(1) DEFAULT NULL COMMENT '状态,1 - 待处理, 2 - 已解决, 3 - 关闭,4 - 审核中,5 - 审核不通过，6-审核通过',\n  `deliver_status` varchar(2) DEFAULT NULL COMMENT '缺陷发货 0 - 是, 1 - 否',\n  `station` varchar(20) DEFAULT NULL COMMENT '工位',\n  `module_type` varchar(20) DEFAULT NULL COMMENT '所属模块',\n  `remark` varchar(20) DEFAULT NULL COMMENT '备注',\n  `case_id` varchar(6) DEFAULT NULL COMMENT '问题自增序列号',\n  `description_files` varchar(1000) DEFAULT NULL COMMENT '问题描述附件',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='设备组装问题登记表'"]

{"sheet":"jetplasma_device_problem_reply","index":21,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,2,10,4],[10,5,10,9],[11,2,11,4],[11,5,11,9],[12,0,12,9],[13,0,13,9]]}
["表名/描述","jetplasma_device_problem_reply",null,null,null,"设备问题登记表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","审核意见ID"]
["pro_id","bigint","19","0","不允许","否",null,"NULL","问题"]
["type","varchar","10","0","不允许","否",null,"NULL","类型"]
["reply","longtext",null,"0","允许","否",null,"NULL","解决方案"]
["reply_user","bigint","19","0","允许","否",null,"NULL","回复人"]
["attachment","varchar","100","0","允许","否",null,"NULL","附件"]
["reply_date","timestamp","NULL","0","不允许","否",null,"CURRENT_TIMESTAMP","回复日期"]
["case_id","varchar","6","0","允许","否",null,"NULL","问题自增序列号"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_problem_reply` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '审核意见ID',\n  `pro_id` bigint(20) NOT NULL COMMENT '问题',\n  `type` varchar(10) NOT NULL COMMENT '类型',\n  `reply` longtext COMMENT '解决方案',\n  `reply_user` bigint(20) DEFAULT NULL COMMENT '回复人',\n  `attachment` varchar(100) DEFAULT NULL COMMENT '附件',\n  `reply_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '回复日期',\n  `case_id` varchar(6) DEFAULT NULL COMMENT '问题自增序列号',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='设备问题登记表'"]

{"sheet":"jetplasma_device_problem_sale","index":22,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,2,22,4],[22,5,22,9],[23,2,23,4],[23,5,23,9],[24,0,24,9],[25,0,25,9]]}
["表名/描述","jetplasma_device_problem_sale",null,null,null,"设备售后问题登记表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","问题ID"]
["pro_no","varchar","50","0","允许","否",null,"NULL","问题编号"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备ID"]
["type","varchar","20","0","不允许","否",null,"NULL","问题类型"]
["depart_id","bigint","19","0","不允许","否",null,"NULL","提出部门"]
["user_id","bigint","19","0","不允许","否",null,"NULL","提出人"]
["principal","bigint","19","0","不允许","否",null,"NULL","负责人"]
["CREATE_AT","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP",""]
["complete_date","datetime","NULL","0","允许","否",null,"NULL","实际完成日期"]
["subject","varchar","50","0","允许","否",null,"NULL","主题"]
["description","longtext",null,"0","不允许","否",null,"NULL","问题描述"]
["reply_date","varchar","12","0","允许","否",null,"NULL","回复日期"]
["status","int","10","0","允许","否",null,"NULL","状态,1 - 待处理, 2 - 已解决, 3 - 关闭"]
["device_status","varchar","8","0","允许","否",null,"NULL","设备状态"]
["urgency","varchar","20","0","允许","否",null,"NULL","紧急程度"]
["critical","varchar","20","0","允许","否",null,"NULL","严重程度"]
["expect_date","datetime","NULL","0","允许","否",null,"NULL","期望完成日期"]
["remark","varchar","20","0","允许","否",null,"NULL","备注"]
["case_id","varchar","6","0","允许","否",null,"NULL","问题自增序列号"]
["description_files","varchar","1000","0","允许","否",null,"NULL","问题描述附件"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_problem_sale` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '问题ID',\n  `pro_no` varchar(50) DEFAULT NULL COMMENT '问题编号',\n  `device_id` bigint(20) NOT NULL COMMENT '设备ID',\n  `type` varchar(20) NOT NULL COMMENT '问题类型',\n  `depart_id` bigint(20) NOT NULL COMMENT '提出部门',\n  `user_id` bigint(20) NOT NULL COMMENT '提出人',\n  `principal` bigint(20) NOT NULL COMMENT '负责人',\n  `CREATE_AT` datetime DEFAULT CURRENT_TIMESTAMP,\n  `complete_date` datetime DEFAULT NULL COMMENT '实际完成日期',\n  `subject` varchar(50) DEFAULT NULL COMMENT '主题',\n  `description` longtext NOT NULL COMMENT '问题描述',\n  `reply_date` varchar(12) DEFAULT NULL COMMENT '回复日期',\n  `status` int(1) DEFAULT NULL COMMENT '状态,1 - 待处理, 2 - 已解决, 3 - 关闭',\n  `device_status` varchar(8) DEFAULT NULL COMMENT '设备状态',\n  `urgency` varchar(20) DEFAULT NULL COMMENT '紧急程度',\n  `critical` varchar(20) DEFAULT NULL COMMENT '严重程度',\n  `expect_date` datetime DEFAULT NULL COMMENT '期望完成日期',\n  `remark` varchar(20) DEFAULT NULL COMMENT '备注',\n  `case_id` varchar(6) DEFAULT NULL COMMENT '问题自增序列号',\n  `description_files` varchar(1000) DEFAULT NULL COMMENT '问题描述附件',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='设备售后问题登记表'"]

{"sheet":"jetplasma_device_problem_test","index":23,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,2,25,4],[25,5,25,9],[26,2,26,4],[26,5,26,9],[27,0,27,9],[28,0,28,9]]}
["表名/描述","jetplasma_device_problem_test",null,null,null,"设备测试问题登记表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","问题ID"]
["pro_no","varchar","50","0","允许","否",null,"NULL","问题编号"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备ID"]
["type","varchar","20","0","不允许","否",null,"NULL","问题类型"]
["depart_id","bigint","19","0","不允许","否",null,"NULL","提出部门"]
["user_id","bigint","19","0","不允许","否",null,"NULL","提出人"]
["principal","bigint","19","0","不允许","否",null,"NULL","负责人"]
["CREATE_AT","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP",""]
["complete_date","datetime","NULL","0","允许","否",null,"NULL","实际完成日期"]
["subject","varchar","50","0","允许","否",null,"NULL","主题"]
["description","longtext","4294967295","0","不允许","否",null,"NULL","问题描述"]
["reply_date","varchar","12","0","允许","否",null,"NULL","回复日期"]
["status","int","10","0","允许","否",null,"NULL","状态,1 - 待处理, 2 - 已解决, 3 - 关闭"]
["test_stage","varchar","50","0","允许","否",null,"NULL","测试阶段"]
["test_version","varchar","50","0","允许","否",null,"NULL","测试软件版本"]
["plc_version","varchar","50","0","允许","否",null,"NULL","PLC程序版本"]
["system_version","varchar","50","0","允许","否",null,"NULL","系统版本"]
["esd_version","varchar","50","0","允许","否",null,"NULL","电气原理图版本"]
["test_result","varchar","50","0","允许","否",null,"NULL","测试结果"]
["test_report","varchar","1000","0","允许","否",null,"NULL","测试报告"]
["remark","varchar","200","0","允许","否",null,"NULL","备注"]
["case_id","varchar","6","0","允许","否",null,"NULL","问题自增序列号"]
["description_files","varchar","1000","0","允许","否",null,"NULL","问题描述附件"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_problem_test` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '问题ID',\n  `pro_no` varchar(50) DEFAULT NULL COMMENT '问题编号',\n  `device_id` bigint(20) NOT NULL COMMENT '设备ID',\n  `type` varchar(20) NOT NULL COMMENT '问题类型',\n  `depart_id` bigint(20) NOT NULL COMMENT '提出部门',\n  `user_id` bigint(20) NOT NULL COMMENT '提出人',\n  `principal` bigint(20) NOT NULL COMMENT '负责人',\n  `CREATE_AT` datetime DEFAULT CURRENT_TIMESTAMP,\n  `complete_date` datetime DEFAULT NULL COMMENT '实际完成日期',\n  `subject` varchar(50) DEFAULT NULL COMMENT '主题',\n  `description` longtext NOT NULL COMMENT '问题描述',\n  `reply_date` varchar(12) DEFAULT NULL COMMENT '回复日期',\n  `status` int(1) DEFAULT NULL COMMENT '状态,1 - 待处理, 2 - 已解决, 3 - 关闭',\n  `test_stage` varchar(50) DEFAULT NULL COMMENT '测试阶段',\n  `test_version` varchar(50) DEFAULT NULL COMMENT '测试软件版本',\n  `plc_version` varchar(50) DEFAULT NULL COMMENT 'PLC程序版本',\n  `system_version` varchar(50) DEFAULT NULL COMMENT '系统版本',\n  `esd_version` varchar(50) DEFAULT NULL COMMENT '电气原理图版本',\n  `test_result` varchar(50) DEFAULT NULL COMMENT '测试结果',\n  `test_report` varchar(1000) DEFAULT NULL COMMENT '测试报告',\n  `remark` varchar(200) DEFAULT NULL COMMENT '备注',\n  `case_id` varchar(6) DEFAULT NULL COMMENT '问题自增序列号',\n  `description_files` varchar(1000) DEFAULT NULL COMMENT '问题描述附件',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='设备测试问题登记表'"]

{"sheet":"jetplasma_device_sn","index":24,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,2,8,4],[8,5,8,9],[9,2,9,4],[9,5,9,9],[10,0,10,9],[11,0,11,9]]}
["表名/描述","jetplasma_device_sn",null,null,null,"设备部件SN列表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","SN_ID"]
["component_id","bigint","19","0","不允许","否",null,"NULL","部件ID"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备ID"]
["sn_name","varchar","50","0","允许","否",null,"NULL","SN名称"]
["sn_value","varchar","50","0","允许","否",null,"NULL","SN值"]
["remark","varchar","50","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_sn` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'SN_ID',\n  `component_id` bigint(20) NOT NULL COMMENT '部件ID',\n  `device_id` bigint(20) NOT NULL COMMENT '设备ID',\n  `sn_name` varchar(50) DEFAULT NULL COMMENT 'SN名称',\n  `sn_value` varchar(50) DEFAULT NULL COMMENT 'SN值',\n  `remark` varchar(50) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='设备部件SN列表'"]

{"sheet":"jetplasma_device_user","index":25,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,2,5,4],[5,5,5,9],[6,2,6,4],[6,5,6,9],[7,0,7,9],[8,0,8,9]]}
["表名/描述","jetplasma_device_user",null,null,null,"设备类型与用户的权限配置表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","日志主键"]
["user_id","bigint","19","0","不允许","否",null,"NULL","用户ID"]
["device_type","varchar","20","0","不允许","否",null,"NULL","设备类型"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_device_user` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',\n  `user_id` bigint(20) NOT NULL COMMENT '用户ID',\n  `device_type` varchar(20) NOT NULL COMMENT '设备类型',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=1818623191719886850 DEFAULT CHARSET=utf8mb4 COMMENT='设备类型与用户的权限配置表'"]

{"sheet":"jetplasma_download_hist","index":26,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,2,13,4],[13,5,13,9],[14,2,14,4],[14,5,14,9],[15,0,15,9],[16,0,16,9]]}
["表名/描述","jetplasma_download_hist",null,null,null,"附件下载历史表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","日志主键"]
["file_name","varchar","200","0","不允许","否",null,"NULL","下载文件名"]
["device_id","bigint","19","0","不允许","否",null,"NULL","设备ID"]
["device_no","varchar","20","0","不允许","否",null,"NULL","设备编号"]
["device_name","varchar","20","0","不允许","否",null,"NULL","设备名称"]
["user_name","varchar","50","0","允许","否",null,"","用户账号"]
["ipaddr","varchar","128","0","允许","否",null,"","登录IP地址"]
["location","varchar","255","0","允许","否",null,"","登录地点"]
["browser","varchar","50","0","允许","否",null,"","浏览器类型"]
["os","varchar","50","0","允许","否",null,"","操作系统"]
["download_time","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","下载时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_download_hist` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',\n  `file_name` varchar(200) NOT NULL COMMENT '下载文件名',\n  `device_id` bigint(20) NOT NULL COMMENT '设备ID',\n  `device_no` varchar(20) NOT NULL COMMENT '设备编号',\n  `device_name` varchar(20) NOT NULL COMMENT '设备名称',\n  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',\n  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',\n  `location` varchar(255) DEFAULT '' COMMENT '登录地点',\n  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',\n  `os` varchar(50) DEFAULT '' COMMENT '操作系统',\n  `download_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '下载时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COMMENT='附件下载历史表'"]

{"sheet":"jetplasma_ecn","index":27,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,2,18,4],[18,5,18,9],[19,2,19,4],[19,5,19,9],[20,2,20,4],[20,5,20,9],[21,0,21,9],[22,0,22,9]]}
["表名/描述","jetplasma_ecn",null,null,null,"ECN执行",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["alteration_id","bigint","19","0","不允许","否",null,"NULL","变更申请ID"]
["alteration_no","varchar","20","0","不允许","否",null,"NULL","变更申请编号"]
["eco_id","bigint","19","0","不允许","否",null,"NULL","ECO编号"]
["ecn_no","varchar","20","0","不允许","否",null,"NULL","ECN单号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["device_type","varchar","500","0","允许","否",null,"NULL","设备类型"]
["project","varchar","200","0","允许","否",null,"NULL","项目"]
["module","varchar","200","0","允许","否",null,"NULL","模块"]
["pri","int","10","0","允许","否",null,"NULL","pri"]
["suggestion","longtext","4294967295","0","允许","否",null,"NULL","改善方案"]
["close_day","datetime","NULL","0","允许","否",null,"NULL","OPEN_DAY"]
["status","varchar","10","0","允许","否",null,"NULL","状态"]
["attachment","varchar","200","0","允许","否",null,"NULL","附件"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核 "]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["Unique","BTREE","JETPLASMA_ECN_NO_UINDEX",null,null,"ECN_NO"]
["初始化脚本"]
["CREATE TABLE `jetplasma_ecn` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `alteration_id` bigint(20) NOT NULL COMMENT '变更申请ID',\n  `alteration_no` varchar(20) NOT NULL COMMENT '变更申请编号',\n  `eco_id` bigint(20) NOT NULL COMMENT 'ECO编号',\n  `ecn_no` varchar(20) NOT NULL COMMENT 'ECN单号',\n  `subject` varchar(200) DEFAULT NULL COMMENT '主题',\n  `device_type` varchar(500) DEFAULT NULL COMMENT '设备类型',\n  `project` varchar(200) DEFAULT NULL COMMENT '项目',\n  `module` varchar(200) DEFAULT NULL COMMENT '模块',\n  `pri` int(1) DEFAULT NULL COMMENT 'pri',\n  `suggestion` longtext COMMENT '改善方案',\n  `close_day` datetime DEFAULT NULL COMMENT 'OPEN_DAY',\n  `status` varchar(10) DEFAULT NULL COMMENT '状态',\n  `attachment` varchar(200) DEFAULT NULL COMMENT '附件',\n  `approve_status` int(11) DEFAULT NULL COMMENT '审核状态：1 - 创建， 2 - 审核中 3 - 已审核 ',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `jetplasma_ecn_no_uindex` (`ecn_no`)\n) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='ECN执行'"]

{"sheet":"jetplasma_ecn_meta","index":28,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","jetplasma_ecn_meta",null,null,null,"ECN执行辅助信息表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["ecn_id","bigint","19","0","不允许","否",null,"NULL","ECN编号"]
["trace_type","varchar","20","0","允许","否",null,"NULL","变更追踪事项"]
["measure","longtext","4294967295","0","允许","否",null,"NULL","措施内容"]
["user_id","bigint","19","0","允许","否",null,"NULL","负责人"]
["depart_id","bigint","19","0","允许","否",null,"NULL","负责部门"]
["expect_date","datetime","NULL","0","允许","否",null,"NULL","预计完成日期"]
["complete_date","datetime","NULL","0","允许","否",null,"NULL","实际完成日期"]
["status","varchar","20","0","允许","否",null,"NULL","状态"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_ecn_meta` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `ecn_id` bigint(20) NOT NULL COMMENT 'ECN编号',\n  `trace_type` varchar(20) DEFAULT NULL COMMENT '变更追踪事项',\n  `measure` longtext COMMENT '措施内容',\n  `user_id` bigint(20) DEFAULT NULL COMMENT '负责人',\n  `depart_id` bigint(20) DEFAULT NULL COMMENT '负责部门',\n  `expect_date` datetime DEFAULT NULL COMMENT '预计完成日期',\n  `complete_date` datetime DEFAULT NULL COMMENT '实际完成日期',\n  `status` varchar(20) DEFAULT NULL COMMENT '状态',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='ECN执行辅助信息表'"]

{"sheet":"jetplasma_ecn_progress","index":29,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,2,10,4],[10,5,10,9],[11,2,11,4],[11,5,11,9],[12,0,12,9],[13,0,13,9]]}
["表名/描述","jetplasma_ecn_progress",null,null,null,"ECN执行进度",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["ecn_id","bigint","19","0","不允许","否",null,"NULL","关联ECN ID"]
["user_id","bigint","19","0","允许","否",null,"NULL","填写人"]
["depart_id","bigint","19","0","允许","否",null,"NULL","填写部门"]
["apply_date","datetime","NULL","0","允许","否",null,"NULL","填写日期"]
["description","longtext","4294967295","0","允许","否",null,"NULL","进度描述"]
["report","varchar","200","0","允许","否",null,"NULL","进度执行报告"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_ecn_progress` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `ecn_id` bigint(20) NOT NULL COMMENT '关联ECN ID',\n  `user_id` bigint(20) DEFAULT NULL COMMENT '填写人',\n  `depart_id` bigint(20) DEFAULT NULL COMMENT '填写部门',\n  `apply_date` datetime DEFAULT NULL COMMENT '填写日期',\n  `description` longtext COMMENT '进度描述',\n  `report` varchar(200) DEFAULT NULL COMMENT '进度执行报告',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='ECN执行进度'"]

{"sheet":"jetplasma_ecn_spread","index":30,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,2,8,4],[8,5,8,9],[9,2,9,4],[9,5,9,9],[10,0,10,9],[11,0,11,9]]}
["表名/描述","jetplasma_ecn_spread",null,null,null,"ECN展开机型",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["ecn_id","bigint","19","0","不允许","否",null,"NULL","所属ECN编号"]
["alteration_no","varchar","20","0","不允许","否",null,"NULL","变更申请编号"]
["device_type","varchar","200","0","允许","否",null,"NULL","设备类型"]
["remark","varchar","200","0","允许","否",null,"NULL","备注"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_ecn_spread` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `ecn_id` bigint(20) NOT NULL COMMENT '所属ECN编号',\n  `alteration_no` varchar(20) NOT NULL COMMENT '变更申请编号',\n  `device_type` varchar(200) DEFAULT NULL COMMENT '设备类型',\n  `remark` varchar(200) DEFAULT NULL COMMENT '备注',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='ECN展开机型'"]

{"sheet":"jetplasma_ecn_view","index":31,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,2,20,4],[20,5,20,9],[21,0,21,9],[22,0,22,9]]}
["表名/描述","jetplasma_ecn_view",null,null,null,"视图",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","否",null,"0","主键ID"]
["alteration_id","bigint","19","0","不允许","否",null,"NULL","变更申请ID"]
["alteration_no","varchar","20","0","不允许","否",null,"NULL","变更申请编号"]
["eco_id","bigint","19","0","不允许","否",null,"NULL","ECO编号"]
["ecn_no","varchar","20","0","不允许","否",null,"NULL","ECN单号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["device_type","varchar","500","0","允许","否",null,"NULL","设备类型"]
["project","varchar","200","0","允许","否",null,"NULL","项目"]
["module","varchar","200","0","允许","否",null,"NULL","模块"]
["pri","int","10","0","允许","否",null,"NULL","pri"]
["suggestion","longtext","4294967295","0","允许","否",null,"NULL","改善方案"]
["close_day","datetime","NULL","0","允许","否",null,"NULL","OPEN_DAY"]
["status","varchar","10","0","允许","否",null,"NULL","状态"]
["attachment","varchar","200","0","允许","否",null,"NULL","附件"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核 "]
["create_at","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["apply_user","bigint","19","0","允许","否",null,"NULL","申请人"]
["apply_depart","bigint","19","0","允许","否",null,"NULL","申请部门"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["初始化脚本"]
["CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jetplasma_ecn_view` AS select `e`.`id` AS `id`,`e`.`alteration_id` AS `alteration_id`,`e`.`alteration_no` AS `alteration_no`,`e`.`eco_id` AS `eco_id`,`e`.`ecn_no` AS `ecn_no`,`e`.`subject` AS `subject`,`e`.`device_type` AS `device_type`,`e`.`project` AS `project`,`e`.`module` AS `module`,`e`.`pri` AS `pri`,`e`.`suggestion` AS `suggestion`,`e`.`close_day` AS `close_day`,`e`.`status` AS `status`,`e`.`attachment` AS `attachment`,`e`.`approve_status` AS `approve_status`,`e`.`create_at` AS `create_at`,`jaa`.`apply_user` AS `apply_user`,`jaa`.`apply_depart` AS `apply_depart` from (`jetplasma_ecn` `e` left join `jetplasma_alteration_apply` `jaa` on((`e`.`alteration_id` = `jaa`.`id`)))"]

{"sheet":"jetplasma_eco","index":32,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,2,18,4],[18,5,18,9],[19,2,19,4],[19,5,19,9],[20,0,20,9],[21,0,21,9]]}
["表名/描述","jetplasma_eco",null,null,null,"ECO验证",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["alteration_id","bigint","19","0","不允许","否",null,"NULL","变更申请ID"]
["alteration_no","varchar","20","0","不允许","否",null,"NULL","申请编号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["item_type","varchar","100","0","不允许","否",null,"NULL","变更项目"]
["child_type","varchar","200","0","允许","否",null,"NULL","变更种类"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核"]
["level","varchar","2","0","允许","否",null,"NULL","重要程度"]
["description","longtext","4294967295","0","允许","否",null,"NULL","验证过程描述"]
["open_day","datetime","NULL","0","允许","否",null,"NULL","OPEN_DAY"]
["due_day","datetime","NULL","0","允许","否",null,"NULL","DUE_DAY"]
["close_day","datetime","NULL","0","允许","否",null,"NULL","CLOSE_DAY"]
["result","varchar","60","0","允许","否",null,"NULL","验证结果"]
["report","varchar","200","0","允许","否",null,"NULL","验证报告"]
["confirm","int","10","0","允许","否",null,"NULL","是否已确认：1 - 已确认， 0 - 未确认"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_eco` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `alteration_id` bigint(20) NOT NULL COMMENT '变更申请ID',\n  `alteration_no` varchar(20) NOT NULL COMMENT '申请编号',\n  `subject` varchar(200) DEFAULT NULL COMMENT '主题',\n  `item_type` varchar(100) NOT NULL COMMENT '变更项目',\n  `child_type` varchar(200) DEFAULT NULL COMMENT '变更种类',\n  `approve_status` int(11) DEFAULT NULL COMMENT '审核状态：1 - 创建， 2 - 审核中 3 - 已审核',\n  `level` varchar(2) DEFAULT NULL COMMENT '重要程度',\n  `description` longtext COMMENT '验证过程描述',\n  `open_day` datetime DEFAULT NULL COMMENT 'OPEN_DAY',\n  `due_day` datetime DEFAULT NULL COMMENT 'DUE_DAY',\n  `close_day` datetime DEFAULT NULL COMMENT 'CLOSE_DAY',\n  `result` varchar(60) DEFAULT NULL COMMENT '验证结果',\n  `report` varchar(200) DEFAULT NULL COMMENT '验证报告',\n  `confirm` int(11) DEFAULT NULL COMMENT '是否已确认：1 - 已确认， 0 - 未确认',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COMMENT='ECO验证'"]

{"sheet":"jetplasma_eco_meta","index":33,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,2,11,4],[11,5,11,9],[12,2,12,4],[12,5,12,9],[13,0,13,9],[14,0,14,9]]}
["表名/描述","jetplasma_eco_meta",null,null,null,"ECO验证辅助信息表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","主键ID"]
["eco_id","bigint","19","0","允许","否",null,"NULL","ECN编号"]
["measure","longtext","4294967295","0","允许","否",null,"NULL","措施内容"]
["user_id","bigint","19","0","允许","否",null,"NULL","负责人"]
["depart_id","bigint","19","0","允许","否",null,"NULL","负责部门"]
["expect_date","datetime","NULL","0","允许","否",null,"NULL","预计完成日期"]
["complete_date","datetime","NULL","0","允许","否",null,"NULL","实际完成日期"]
["status","varchar","20","0","允许","否",null,"NULL","状态"]
["create_at","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_eco_meta` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',\n  `eco_id` bigint(20) DEFAULT NULL COMMENT 'ECN编号',\n  `measure` longtext COMMENT '措施内容',\n  `user_id` bigint(20) DEFAULT NULL COMMENT '负责人',\n  `depart_id` bigint(20) DEFAULT NULL COMMENT '负责部门',\n  `expect_date` datetime DEFAULT NULL COMMENT '预计完成日期',\n  `complete_date` datetime DEFAULT NULL COMMENT '实际完成日期',\n  `status` varchar(20) DEFAULT NULL COMMENT '状态',\n  `create_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='ECO验证辅助信息表'"]

{"sheet":"jetplasma_eco_view","index":34,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,2,20,4],[20,5,20,9],[21,0,21,9],[22,0,22,9]]}
["表名/描述","jetplasma_eco_view",null,null,null,"VIEW",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","否",null,"0","主键ID"]
["alteration_id","bigint","19","0","不允许","否",null,"NULL","变更申请ID"]
["alteration_no","varchar","20","0","不允许","否",null,"NULL","申请编号"]
["subject","varchar","200","0","允许","否",null,"NULL","主题"]
["item_type","varchar","100","0","不允许","否",null,"NULL","变更项目"]
["child_type","varchar","200","0","允许","否",null,"NULL","变更种类"]
["approve_status","int","10","0","允许","否",null,"NULL","审核状态：1 - 创建， 2 - 审核中 3 - 已审核"]
["level","varchar","2","0","允许","否",null,"NULL","重要程度"]
["description","longtext","4294967295","0","允许","否",null,"NULL","验证过程描述"]
["open_day","datetime","NULL","0","允许","否",null,"NULL","OPEN_DAY"]
["due_day","datetime","NULL","0","允许","否",null,"NULL","DUE_DAY"]
["close_day","datetime","NULL","0","允许","否",null,"NULL","CLOSE_DAY"]
["result","varchar","60","0","允许","否",null,"NULL","验证结果"]
["report","varchar","200","0","允许","否",null,"NULL","验证报告"]
["confirm","int","10","0","允许","否",null,"NULL","是否已确认：1 - 已确认， 0 - 未确认"]
["create_at","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["apply_user","bigint","19","0","允许","否",null,"NULL","申请人"]
["apply_depart","bigint","19","0","允许","否",null,"NULL","申请部门"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["初始化脚本"]
["CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jetplasma_eco_view` AS select `e`.`id` AS `id`,`e`.`alteration_id` AS `alteration_id`,`e`.`alteration_no` AS `alteration_no`,`e`.`subject` AS `subject`,`e`.`item_type` AS `item_type`,`e`.`child_type` AS `child_type`,`e`.`approve_status` AS `approve_status`,`e`.`level` AS `level`,`e`.`description` AS `description`,`e`.`open_day` AS `open_day`,`e`.`due_day` AS `due_day`,`e`.`close_day` AS `close_day`,`e`.`result` AS `result`,`e`.`report` AS `report`,`e`.`confirm` AS `confirm`,`e`.`create_at` AS `create_at`,`jaa`.`apply_user` AS `apply_user`,`jaa`.`apply_depart` AS `apply_depart` from (`jetplasma_eco` `e` left join `jetplasma_alteration_apply` `jaa` on((`e`.`alteration_id` = `jaa`.`id`)))"]

{"sheet":"jetplasma_proj_type","index":35,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","jetplasma_proj_type",null,null,null,"项目系列类型表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["id","bigint","19","0","不允许","是",null,"NULL","项目id"]
["parent_id","bigint","19","0","允许","否",null,"0","父项目id"]
["proj_name","varchar","30","0","允许","否",null,"","项目名称"]
["order_num","int","10","0","允许","否",null,"0","显示顺序"]
["status","char","1","0","允许","否",null,"0","状态（0正常 1停用）"]
["del_flag","char","1","0","允许","否",null,"0","删除标志（0代表存在 2代表删除）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"CURRENT_TIMESTAMP","更新时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ID"]
["初始化脚本"]
["CREATE TABLE `jetplasma_proj_type` (\n  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '项目id',\n  `parent_id` bigint(20) DEFAULT '0' COMMENT '父项目id',\n  `proj_name` varchar(30) DEFAULT '' COMMENT '项目名称',\n  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',\n  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',\n  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='项目系列类型表'"]

{"sheet":"sys_config","index":36,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","sys_config",null,null,null,"参数配置表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["config_id","int","10","0","不允许","是",null,"NULL","参数主键"]
["config_name","varchar","100","0","允许","否",null,"","参数名称"]
["config_key","varchar","100","0","允许","否",null,"","参数键名"]
["config_value","varchar","500","0","允许","否",null,"","参数键值"]
["config_type","char","1","0","允许","否",null,"N","系统内置（Y是 N否）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"CONFIG_ID"]
["初始化脚本"]
["CREATE TABLE `sys_config` (\n  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',\n  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',\n  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',\n  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',\n  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`config_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='参数配置表'"]

{"sheet":"sys_dept","index":37,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,2,16,4],[16,5,16,9],[17,2,17,4],[17,5,17,9],[18,0,18,9],[19,0,19,9]]}
["表名/描述","sys_dept",null,null,null,"部门表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["dept_id","bigint","19","0","不允许","是",null,"NULL","部门id"]
["parent_id","bigint","19","0","允许","否",null,"0","父部门id"]
["ancestors","varchar","50","0","允许","否",null,"","祖级列表"]
["dept_name","varchar","30","0","允许","否",null,"","部门名称"]
["order_num","int","10","0","允许","否",null,"0","显示顺序"]
["leader","varchar","20","0","允许","否",null,"NULL","负责人"]
["phone","varchar","11","0","允许","否",null,"NULL","联系电话"]
["email","varchar","50","0","允许","否",null,"NULL","邮箱"]
["status","char","1","0","允许","否",null,"0","部门状态（0正常 1停用）"]
["del_flag","char","1","0","允许","否",null,"0","删除标志（0代表存在 2代表删除）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"DEPT_ID"]
["初始化脚本"]
["CREATE TABLE `sys_dept` (\n  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',\n  `parent_id` bigint(20) DEFAULT '0' COMMENT '父部门id',\n  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',\n  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',\n  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',\n  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',\n  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',\n  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',\n  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',\n  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  PRIMARY KEY (`dept_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COMMENT='部门表'"]

{"sheet":"sys_dict_data","index":38,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,2,16,4],[16,5,16,9],[17,2,17,4],[17,5,17,9],[18,0,18,9],[19,0,19,9]]}
["表名/描述","sys_dict_data",null,null,null,"字典数据表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["dict_code","bigint","19","0","不允许","是",null,"NULL","字典编码"]
["dict_sort","int","10","0","允许","否",null,"0","字典排序"]
["dict_label","varchar","100","0","允许","否",null,"","字典标签"]
["dict_value","varchar","100","0","允许","否",null,"","字典键值"]
["dict_type","varchar","100","0","允许","否",null,"","字典类型"]
["css_class","varchar","100","0","允许","否",null,"NULL","样式属性（其他样式扩展）"]
["list_class","varchar","100","0","允许","否",null,"NULL","表格回显样式"]
["is_default","char","1","0","允许","否",null,"N","是否默认（Y是 N否）"]
["status","char","1","0","允许","否",null,"0","状态（0正常 1停用）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"DICT_CODE"]
["初始化脚本"]
["CREATE TABLE `sys_dict_data` (\n  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',\n  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',\n  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',\n  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',\n  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',\n  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',\n  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',\n  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',\n  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`dict_code`)\n) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表'"]

{"sheet":"sys_dict_type","index":39,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,2,11,4],[11,5,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","sys_dict_type",null,null,null,"字典类型表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["dict_id","bigint","19","0","不允许","是",null,"NULL","字典主键"]
["dict_name","varchar","100","0","允许","否",null,"","字典名称"]
["dict_type","varchar","100","0","允许","否",null,"","字典类型"]
["status","char","1","0","允许","否",null,"0","状态（0正常 1停用）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"DICT_ID"]
["Unique","BTREE","DICT_TYPE",null,null,"DICT_TYPE"]
["初始化脚本"]
["CREATE TABLE `sys_dict_type` (\n  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',\n  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',\n  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',\n  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`dict_id`),\n  UNIQUE KEY `dict_type` (`dict_type`)\n) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COMMENT='字典类型表'"]

{"sheet":"sys_job","index":40,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,2,15,4],[15,5,15,9],[16,2,16,4],[16,5,16,9],[17,2,17,4],[17,5,17,9],[18,2,18,4],[18,5,18,9],[19,0,19,9],[20,0,20,9]]}
["表名/描述","sys_job",null,null,null,"定时任务调度表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["job_id","bigint","19","0","不允许","是",null,"NULL","任务ID"]
["job_name","varchar","64","0","不允许","是",null,"","任务名称"]
["job_group","varchar","64","0","不允许","是",null,"DEFAULT","任务组名"]
["invoke_target","varchar","500","0","不允许","否",null,"NULL","调用目标字符串"]
["cron_expression","varchar","255","0","允许","否",null,"","cron执行表达式"]
["misfire_policy","varchar","20","0","允许","否",null,"3","计划执行错误策略（1立即执行 2执行一次 3放弃执行）"]
["concurrent","char","1","0","允许","否",null,"1","是否并发执行（0允许 1禁止）"]
["status","char","1","0","允许","否",null,"0","状态（0正常 1暂停）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"","备注信息"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"JOB_ID"]
["Unique","BTREE","PRIMARY",null,null,"JOB_GROUP"]
["Unique","BTREE","PRIMARY",null,null,"JOB_NAME"]
["初始化脚本"]
["CREATE TABLE `sys_job` (\n  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',\n  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',\n  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',\n  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',\n  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',\n  `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',\n  `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',\n  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',\n  PRIMARY KEY (`job_id`,`job_name`,`job_group`)\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度表'"]

{"sheet":"sys_job_log","index":41,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,2,10,4],[10,5,10,9],[11,2,11,4],[11,5,11,9],[12,0,12,9],[13,0,13,9]]}
["表名/描述","sys_job_log",null,null,null,"定时任务调度日志表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["job_log_id","bigint","19","0","不允许","是",null,"NULL","任务日志ID"]
["job_name","varchar","64","0","不允许","否",null,"NULL","任务名称"]
["job_group","varchar","64","0","不允许","否",null,"NULL","任务组名"]
["invoke_target","varchar","500","0","不允许","否",null,"NULL","调用目标字符串"]
["job_message","varchar","500","0","允许","否",null,"NULL","日志信息"]
["status","char","1","0","允许","否",null,"0","执行状态（0正常 1失败）"]
["exception_info","varchar","2000","0","允许","否",null,"","异常信息"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"JOB_LOG_ID"]
["初始化脚本"]
["CREATE TABLE `sys_job_log` (\n  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',\n  `job_name` varchar(64) NOT NULL COMMENT '任务名称',\n  `job_group` varchar(64) NOT NULL COMMENT '任务组名',\n  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',\n  `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',\n  `status` char(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',\n  `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  PRIMARY KEY (`job_log_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度日志表'"]

{"sheet":"sys_logininfor","index":42,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,2,11,4],[11,5,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,2,14,4],[14,5,14,9],[15,0,15,9],[16,0,16,9]]}
["表名/描述","sys_logininfor",null,null,null,"系统访问记录",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["info_id","bigint","19","0","不允许","是",null,"NULL","访问ID"]
["user_name","varchar","50","0","允许","否",null,"","用户账号"]
["ipaddr","varchar","128","0","允许","否",null,"","登录IP地址"]
["login_location","varchar","255","0","允许","否",null,"","登录地点"]
["browser","varchar","50","0","允许","否",null,"","浏览器类型"]
["os","varchar","50","0","允许","否",null,"","操作系统"]
["status","char","1","0","允许","否",null,"0","登录状态（0成功 1失败）"]
["msg","varchar","255","0","允许","否",null,"","提示消息"]
["login_time","datetime","NULL","0","允许","否",null,"NULL","访问时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"INFO_ID"]
["Normal","BTREE","IDX_SYS_LOGININFOR_LT",null,null,"LOGIN_TIME"]
["Normal","BTREE","IDX_SYS_LOGININFOR_S",null,null,"STATUS"]
["初始化脚本"]
["CREATE TABLE `sys_logininfor` (\n  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',\n  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',\n  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',\n  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',\n  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',\n  `os` varchar(50) DEFAULT '' COMMENT '操作系统',\n  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',\n  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',\n  `login_time` datetime DEFAULT NULL COMMENT '访问时间',\n  PRIMARY KEY (`info_id`),\n  KEY `idx_sys_logininfor_s` (`status`),\n  KEY `idx_sys_logininfor_lt` (`login_time`)\n) ENGINE=InnoDB AUTO_INCREMENT=1095 DEFAULT CHARSET=utf8mb4 COMMENT='系统访问记录'"]

{"sheet":"sys_menu","index":43,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,2,21,4],[21,5,21,9],[22,2,22,4],[22,5,22,9],[23,0,23,9],[24,0,24,9]]}
["表名/描述","sys_menu",null,null,null,"菜单权限表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["menu_id","bigint","19","0","不允许","是",null,"NULL","菜单ID"]
["menu_name","varchar","50","0","不允许","否",null,"NULL","菜单名称"]
["parent_id","bigint","19","0","允许","否",null,"0","父菜单ID"]
["order_num","int","10","0","允许","否",null,"0","显示顺序"]
["path","varchar","200","0","允许","否",null,"","路由地址"]
["component","varchar","255","0","允许","否",null,"NULL","组件路径"]
["query","varchar","255","0","允许","否",null,"NULL","路由参数"]
["is_frame","int","10","0","允许","否",null,"1","是否为外链（0是 1否）"]
["is_cache","int","10","0","允许","否",null,"0","是否缓存（0缓存 1不缓存）"]
["menu_type","char","1","0","允许","否",null,"","菜单类型（M目录 C菜单 F按钮）"]
["visible","char","1","0","允许","否",null,"0","菜单状态（0显示 1隐藏）"]
["status","char","1","0","允许","否",null,"0","菜单状态（0正常 1停用）"]
["perms","varchar","100","0","允许","否",null,"NULL","权限标识"]
["icon","varchar","100","0","允许","否",null,"#","菜单图标"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"MENU_ID"]
["初始化脚本"]
["CREATE TABLE `sys_menu` (\n  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',\n  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',\n  `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',\n  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',\n  `path` varchar(200) DEFAULT '' COMMENT '路由地址',\n  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',\n  `query` varchar(255) DEFAULT NULL COMMENT '路由参数',\n  `is_frame` int(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',\n  `is_cache` int(1) DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',\n  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',\n  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',\n  `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',\n  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',\n  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT '' COMMENT '备注',\n  PRIMARY KEY (`menu_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2069 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表'"]

{"sheet":"sys_notice","index":44,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","sys_notice",null,null,null,"通知公告表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["notice_id","int","10","0","不允许","是",null,"NULL","公告ID"]
["notice_title","varchar","50","0","不允许","否",null,"NULL","公告标题"]
["notice_type","char","1","0","不允许","否",null,"NULL","公告类型（1通知 2公告）"]
["notice_content","longblob","4294967295","0","允许","否",null,"NULL","公告内容"]
["status","char","1","0","允许","否",null,"0","公告状态（0正常 1关闭）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","255","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"NOTICE_ID"]
["初始化脚本"]
["CREATE TABLE `sys_notice` (\n  `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',\n  `notice_title` varchar(50) NOT NULL COMMENT '公告标题',\n  `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）',\n  `notice_content` longblob COMMENT '公告内容',\n  `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(255) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`notice_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知公告表'"]

{"sheet":"sys_oper_log","index":45,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,2,19,4],[19,5,19,9],[20,2,20,4],[20,5,20,9],[21,2,21,4],[21,5,21,9],[22,2,22,4],[22,5,22,9],[23,2,23,4],[23,5,23,9],[24,0,24,9],[25,0,25,9]]}
["表名/描述","sys_oper_log",null,null,null,"操作日志记录",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["oper_id","bigint","19","0","不允许","是",null,"NULL","日志主键"]
["title","varchar","50","0","允许","否",null,"","模块标题"]
["business_type","int","10","0","允许","否",null,"0","业务类型（0其它 1新增 2修改 3删除）"]
["method","varchar","100","0","允许","否",null,"","方法名称"]
["request_method","varchar","10","0","允许","否",null,"","请求方式"]
["operator_type","int","10","0","允许","否",null,"0","操作类别（0其它 1后台用户 2手机端用户）"]
["oper_name","varchar","50","0","允许","否",null,"","操作人员"]
["dept_name","varchar","50","0","允许","否",null,"","部门名称"]
["oper_url","varchar","255","0","允许","否",null,"","请求URL"]
["oper_ip","varchar","128","0","允许","否",null,"","主机地址"]
["oper_location","varchar","255","0","允许","否",null,"","操作地点"]
["oper_param","varchar","2000","0","允许","否",null,"","请求参数"]
["json_result","varchar","2000","0","允许","否",null,"","返回参数"]
["status","int","10","0","允许","否",null,"0","操作状态（0正常 1异常）"]
["error_msg","varchar","2000","0","允许","否",null,"","错误消息"]
["oper_time","datetime","NULL","0","允许","否",null,"NULL","操作时间"]
["cost_time","bigint","19","0","允许","否",null,"0","消耗时间"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"OPER_ID"]
["Normal","BTREE","IDX_SYS_OPER_LOG_S",null,null,"STATUS"]
["Normal","BTREE","IDX_SYS_OPER_LOG_BT",null,null,"BUSINESS_TYPE"]
["Normal","BTREE","IDX_SYS_OPER_LOG_OT",null,null,"OPER_TIME"]
["初始化脚本"]
["CREATE TABLE `sys_oper_log` (\n  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',\n  `title` varchar(50) DEFAULT '' COMMENT '模块标题',\n  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',\n  `method` varchar(100) DEFAULT '' COMMENT '方法名称',\n  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',\n  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',\n  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',\n  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',\n  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',\n  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',\n  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',\n  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',\n  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',\n  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',\n  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',\n  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',\n  `cost_time` bigint(20) DEFAULT '0' COMMENT '消耗时间',\n  PRIMARY KEY (`oper_id`),\n  KEY `idx_sys_oper_log_bt` (`business_type`),\n  KEY `idx_sys_oper_log_s` (`status`),\n  KEY `idx_sys_oper_log_ot` (`oper_time`)\n) ENGINE=InnoDB AUTO_INCREMENT=3883 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志记录'"]

{"sheet":"sys_post","index":46,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,2,12,4],[12,5,12,9],[13,2,13,4],[13,5,13,9],[14,0,14,9],[15,0,15,9]]}
["表名/描述","sys_post",null,null,null,"岗位信息表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["post_id","bigint","19","0","不允许","是",null,"NULL","岗位ID"]
["post_code","varchar","64","0","不允许","否",null,"NULL","岗位编码"]
["post_name","varchar","50","0","不允许","否",null,"NULL","岗位名称"]
["post_sort","int","10","0","不允许","否",null,"NULL","显示顺序"]
["status","char","1","0","不允许","否",null,"NULL","状态（0正常 1停用）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"POST_ID"]
["初始化脚本"]
["CREATE TABLE `sys_post` (\n  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',\n  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',\n  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',\n  `post_sort` int(4) NOT NULL COMMENT '显示顺序',\n  `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`post_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='岗位信息表'"]

{"sheet":"sys_role","index":47,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,2,16,4],[16,5,16,9],[17,2,17,4],[17,5,17,9],[18,0,18,9],[19,0,19,9]]}
["表名/描述","sys_role",null,null,null,"角色信息表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["role_id","bigint","19","0","不允许","是",null,"NULL","角色ID"]
["role_name","varchar","30","0","不允许","否",null,"NULL","角色名称"]
["role_key","varchar","100","0","不允许","否",null,"NULL","角色权限字符串"]
["role_sort","int","10","0","不允许","否",null,"NULL","显示顺序"]
["data_scope","char","1","0","允许","否",null,"1","数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）"]
["menu_check_strictly","tinyint","3","0","允许","否",null,"1","菜单树选择项是否关联显示"]
["dept_check_strictly","tinyint","3","0","允许","否",null,"1","部门树选择项是否关联显示"]
["status","char","1","0","不允许","否",null,"NULL","角色状态（0正常 1停用）"]
["del_flag","char","1","0","允许","否",null,"0","删除标志（0代表存在 2代表删除）"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ROLE_ID"]
["初始化脚本"]
["CREATE TABLE `sys_role` (\n  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',\n  `role_name` varchar(30) NOT NULL COMMENT '角色名称',\n  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',\n  `role_sort` int(4) NOT NULL COMMENT '显示顺序',\n  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',\n  `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',\n  `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',\n  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',\n  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`role_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COMMENT='角色信息表'"]

{"sheet":"sys_role_dept","index":48,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,2,4,4],[4,5,4,9],[5,2,5,4],[5,5,5,9],[6,2,6,4],[6,5,6,9],[7,0,7,9],[8,0,8,9]]}
["表名/描述","sys_role_dept",null,null,null,"角色和部门关联表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["role_id","bigint","19","0","不允许","是",null,"NULL","角色ID"]
["dept_id","bigint","19","0","不允许","是",null,"NULL","部门ID"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ROLE_ID"]
["Unique","BTREE","PRIMARY",null,null,"DEPT_ID"]
["初始化脚本"]
["CREATE TABLE `sys_role_dept` (\n  `role_id` bigint(20) NOT NULL COMMENT '角色ID',\n  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',\n  PRIMARY KEY (`role_id`,`dept_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和部门关联表'"]

{"sheet":"sys_role_menu","index":49,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,2,4,4],[4,5,4,9],[5,2,5,4],[5,5,5,9],[6,2,6,4],[6,5,6,9],[7,0,7,9],[8,0,8,9]]}
["表名/描述","sys_role_menu",null,null,null,"角色和菜单关联表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["role_id","bigint","19","0","不允许","是",null,"NULL","角色ID"]
["menu_id","bigint","19","0","不允许","是",null,"NULL","菜单ID"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"ROLE_ID"]
["Unique","BTREE","PRIMARY",null,null,"MENU_ID"]
["初始化脚本"]
["CREATE TABLE `sys_role_menu` (\n  `role_id` bigint(20) NOT NULL COMMENT '角色ID',\n  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',\n  PRIMARY KEY (`role_id`,`menu_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关联表'"]

{"sheet":"sys_user","index":50,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,2,21,4],[21,5,21,9],[22,2,22,4],[22,5,22,9],[23,0,23,9],[24,0,24,9]]}
["表名/描述","sys_user",null,null,null,"用户信息表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["user_id","bigint","19","0","不允许","是",null,"NULL","用户ID"]
["dept_id","bigint","19","0","允许","否",null,"NULL","部门ID"]
["user_name","varchar","30","0","不允许","否",null,"NULL","用户账号"]
["nick_name","varchar","30","0","不允许","否",null,"NULL","用户昵称"]
["user_type","varchar","2","0","允许","否",null,"00","用户类型（00系统用户）"]
["email","varchar","50","0","允许","否",null,"","用户邮箱"]
["phonenumber","varchar","11","0","允许","否",null,"","手机号码"]
["sex","char","1","0","允许","否",null,"0","用户性别（0男 1女 2未知）"]
["avatar","varchar","100","0","允许","否",null,"","头像地址"]
["password","varchar","100","0","允许","否",null,"","密码"]
["status","char","1","0","允许","否",null,"0","帐号状态（0正常 1停用）"]
["del_flag","char","1","0","允许","否",null,"0","删除标志（0代表存在 2代表删除）"]
["login_ip","varchar","128","0","允许","否",null,"","最后登录IP"]
["login_date","datetime","NULL","0","允许","否",null,"NULL","最后登录时间"]
["create_by","varchar","64","0","允许","否",null,"","创建者"]
["create_time","datetime","NULL","0","允许","否",null,"NULL","创建时间"]
["update_by","varchar","64","0","允许","否",null,"","更新者"]
["update_time","datetime","NULL","0","允许","否",null,"NULL","更新时间"]
["remark","varchar","500","0","允许","否",null,"NULL","备注"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"USER_ID"]
["初始化脚本"]
["CREATE TABLE `sys_user` (\n  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',\n  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',\n  `user_name` varchar(30) NOT NULL COMMENT '用户账号',\n  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',\n  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',\n  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',\n  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',\n  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',\n  `avatar` varchar(100) DEFAULT '' COMMENT '头像地址',\n  `password` varchar(100) DEFAULT '' COMMENT '密码',\n  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',\n  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',\n  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',\n  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',\n  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',\n  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',\n  `update_time` datetime DEFAULT NULL COMMENT '更新时间',\n  `remark` varchar(500) DEFAULT NULL COMMENT '备注',\n  PRIMARY KEY (`user_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表'"]

{"sheet":"sys_user_post","index":51,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,2,4,4],[4,5,4,9],[5,2,5,4],[5,5,5,9],[6,2,6,4],[6,5,6,9],[7,0,7,9],[8,0,8,9]]}
["表名/描述","sys_user_post",null,null,null,"用户与岗位关联表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["user_id","bigint","19","0","不允许","是",null,"NULL","用户ID"]
["post_id","bigint","19","0","不允许","是",null,"NULL","岗位ID"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"USER_ID"]
["Unique","BTREE","PRIMARY",null,null,"POST_ID"]
["初始化脚本"]
["CREATE TABLE `sys_user_post` (\n  `user_id` bigint(20) NOT NULL COMMENT '用户ID',\n  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',\n  PRIMARY KEY (`user_id`,`post_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户与岗位关联表'"]

{"sheet":"sys_user_role","index":52,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,2,4,4],[4,5,4,9],[5,2,5,4],[5,5,5,9],[6,2,6,4],[6,5,6,9],[7,0,7,9],[8,0,8,9]]}
["表名/描述","sys_user_role",null,null,null,"用户和角色关联表",null,null,null,"返回首页"]
["字段名","类型","长度","小数点","允许空值","是否主键","是否自增长","默认值","注释"]
["user_id","bigint","19","0","不允许","是",null,"NULL","用户ID"]
["role_id","bigint","19","0","不允许","是",null,"NULL","角色ID"]
["索引类型","索引方式","索引名",null,null,"索引字段"]
["Unique","BTREE","PRIMARY",null,null,"USER_ID"]
["Unique","BTREE","PRIMARY",null,null,"ROLE_ID"]
["初始化脚本"]
["CREATE TABLE `sys_user_role` (\n  `user_id` bigint(20) NOT NULL COMMENT '用户ID',\n  `role_id` bigint(20) NOT NULL COMMENT '角色ID',\n  PRIMARY KEY (`user_id`,`role_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户和角色关联表'"]