达梦初始化
DROP TABLE IF EXISTS SYS_OPER_LOG;
CREATE TABLE SYS_OPER_LOG
(
ID bigint NOT NULL COMMENT '主键id',
TITLE varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作模块',
BUSINESS_TYPE int NULL DEFAULT NULL COMMENT '业务类型|0其它 1新增 2修改 3删除',
OPER_URL varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '请求url',
METHOD varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '请求后端方法',
REQUEST_METHOD varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '请求方式',
OPER_IP varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作地址',
OPER_LOCATION varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作地点',
OPER_STATUS int NULL DEFAULT NULL COMMENT '操作状态|0正常 1异常',
ERROR_MSG text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '错误消息',
OPER_TIME datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
OPER_PARAM text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '请求参数',
JSON_RESULT text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '返回响应体',
USER_ID varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户id',
LOGIN_NAME varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户名',
OPER_OS varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作系统',
BROWSER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '浏览器',
SERVER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '本地服务器',
PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS SYS_DATA_HELP;
CREATE TABLE SYS_DATA_HELP
(
ID bigint NOT NULL COMMENT '自增主键',
QUERY_KEY varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询key',
QUERY_TYPE varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询类型1:下拉框 2:放大镜',
SQL_COMMAND varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'SQL',
BASE_COMMENT varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '说明',
SYS varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '使用系统',
CREATE_TIME datetime DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime DEFAULT NULL COMMENT '更新时间',
USE_CACHE char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'N' COMMENT '缓存启用状态0不用1用',
LANGUAGE_TYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言类型',
DATA_CHANGE_CODE varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据转换代码',
DATA_CHANGE_NAME varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据转换名称',
TG_SORT_FIELD varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '排序',
CREATE_USER varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
UPDAETE_USER varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
CODE_MEMO varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代码描述',
NAME_MEMO varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '名称描述',
COMPARE_TYPE varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询方式 like eq',
CHOOSE_SHOW varchar(2000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '放大镜显示-----功能暂不实现',
TG_QUERY_FIELD varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询列和conn配合使用-----功能暂不实现',
AUTO_UPPER char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '自动转大写-----功能暂不实现',
QUERY_MODE varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询模式-----功能暂不实现',
STATUS varchar(2) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态-----保留',
ECI_LOCK char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '锁定状态',
CONVERT_SQL varchar(2000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '转换SQL',
PL_VERSION varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '当前版本',
NEED_DOWNLOAD char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否需要下载',
MEMO_DETAIL varchar(800) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '详细备注',
ADMIN_LOCK char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '管理员锁定',
ASSEMBLY_NAME varchar(400) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '程序集扩展',
FILTER char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '打开页面是否条件过滤',
LAYOUT varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '布局',
EDIT_URL varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '编辑地址',
CONFIG varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配置信息',
WIDTH varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '宽度',
HEIGHT varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '高度',
QUERY_DATA varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询数据',
TG_PAGE_SIZE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '分页大小',
PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS SYS_USER_INFO;
CREATE TABLE SYS_USER_INFO
(
ID bigint NOT NULL COMMENT '自增列',
USER_ID varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '权限平台用户ID',
LOGIN_NAME varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '权限平台登录用户名',
TRUE_NAME varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限平台真实名',
COMPANY_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '企业代码',
COMPANY_NAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '企业名称',
CUST_CODE varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '关区代码',
CUST_NAME varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '关区名称',
USER_NICKNAME varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户别名',
USER_IMG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
USER_SEX varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '性别(0-保密/1-男/2-女)',
LOGIN_COUNT int DEFAULT '0' COMMENT '登录次数',
LOGIN_TIME datetime DEFAULT NULL COMMENT '本次登录时间',
LOGIN_LAST_TIME datetime DEFAULT NULL COMMENT '上次登录时间',
CLIENT_IP varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端IP',
CLIENT_PROVINCE varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端IP所在省份',
CLIENT_CITY varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端IP所在城市',
CLIENT_BROWSER varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端浏览器',
CLIENT_OS varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端操作系统',
USER_TOKEN varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'USER_TOKEN',
BIND_PHONE_NO varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '绑定手机号',
WEB_SIDE_TYPE varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '2' COMMENT '侧边栏类型(1-栏式1/2-栏式2)',
WEB_HEAD_TYPE varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '3' COMMENT '顶部模式(1-白/2-黑/3-主题色)',
WEB_THEME varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '#409eff' COMMENT '主题颜色',
WEB_LAYOUT varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '3' COMMENT '布局模式(1-侧边/2-顶部/3-混合)',
WEB_SIDE_IS_ICON varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1' COMMENT '侧边栏彩色图标',
WEB_SIDE_IS_OPEN varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1' COMMENT '侧栏排它展开',
WEB_IS_TAB varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1' COMMENT '启用标签页',
WEB_TAB_TYPE varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1' COMMENT '标签显示风格(1-默认/2-圆点/3-卡片)',
MAIL_ADDRESS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户邮箱地址',
PWD_LAST_UPDATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '密码最后修改时间',
DEV varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '是否运维|0否1是',
PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS SYS_USER_LOGIN_LOG;
CREATE TABLE SYS_USER_LOGIN_LOG
(
ID bigint NOT NULL COMMENT '自增列(业务无关)',
USER_ID varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限平台用户ID',
LOGIN_NAME varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限平台登录用户名',
SYS_CODE varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '系统代码',
CLIENT_IP varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端IP',
CLIENT_PROVINCE varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端IP所在省份',
CLIENT_CITY varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端IP所在城市',
CLIENT_BROWSER varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端浏览器',
CLIENT_OS varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '客户端操作系统',
LOGIN_TIME datetime DEFAULT NULL COMMENT '登录时间',
LOGIN_STATUS int DEFAULT NULL COMMENT '登录状态(1-成功/0-失败)',
LOGIN_DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登录失败原因',
ACTION_PARAMS text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '请求参数',
PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS SYS_ENTERPRISE_INFO;
CREATE TABLE SYS_ENTERPRISE_INFO
(
ID bigint NOT NULL AUTO_INCREMENT COMMENT '自增列(业务无关)',
COMPANY_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '企业编码',
COMPANY_NAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '企业名称',
EP_SCCD varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '企业18位社会信用代码',
CUST_CODE varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '关区代码',
CUST_NAME varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '关区名称',
CONTACTS varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系人',
CONTACTS_TEL varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系电话',
MAIL_ADDRESS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮件地址',
EP_ADDRESS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '企业地址',
EP_LOGO_URL varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '企业专属logoURL',
EP_SYS_NAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '企业专属系统名称',
REMARK varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
CREATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
UPDATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS SYS_TABLE_SETTING;
CREATE TABLE SYS_TABLE_SETTING
(
ID bigint NOT NULL COMMENT '主键',
USER_ID varchar(36) DEFAULT NULL COMMENT '用户id',
SETTING_TYPE varchar(1) DEFAULT NULL COMMENT '设置类型|1筛选项2表单项',
TABLE_CODE varchar(255) DEFAULT NULL COMMENT '表名',
JSON_DETAIL text COMMENT 'json明细',
CREATE_TIME datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (ID)
);
CREATE TABLE SYS_QUICK_MY_COLLECTION
(
ID bigint NOT NULL COMMENT '自增主键',
USER_ID varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限平台用户ID',
LOGIN_NAME varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户名(权限平台登录用户名)',
TRUE_NAME varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '真实姓名',
MENU_ID varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单编号',
MENU_NAME varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单名称',
MENU_ROUTE varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '菜单路由地址',
REMARK varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注(图标)',
CREATE_USER varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
CREATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
UPDATE_USER varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
UPDATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (ID)
);
CREATE TABLE SYS_MONITOR_API
(
ID bigint NOT NULL COMMENT '主键',
APP_NAME varchar(50) DEFAULT NULL COMMENT '系统名称',
URI varchar(255) DEFAULT NULL COMMENT '接口地址',
RESP_TIME int DEFAULT NULL COMMENT '响应时长(毫秒)',
RESP_STATUS int DEFAULT NULL COMMENT '返回状态:0正常 1异常',
CREATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (ID)
);
CREATE TABLE SYS_MONITOR_SQL
(
ID bigint NOT NULL COMMENT '主键',
URI varchar(255) DEFAULT NULL COMMENT '接口地址',
SQL_STR text COMMENT 'SQL语句',
SQL_TIME int DEFAULT NULL COMMENT 'SQL时长(毫秒)',
CREATE_TIME datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (ID)
);
DROP TABLE IF EXISTS SYS_CACHE_HELP;
CREATE TABLE SYS_CACHE_HELP
(
ID bigint NOT NULL COMMENT '自增主键',
QUERY_KEY varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询key',
STATUS varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态-----保留',
SQL_COMMAND varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'SQL',
BASE_COMMENT varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
MEMO varchar(400) COLLATE utf8mb4_bin DEFAULT NULL,
MEMO_DETAIL varchar(400) COLLATE utf8mb4_bin DEFAULT NULL,
SYS varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '使用系统',
LANGUAGE_TYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言类型',
CREATE_TIME datetime DEFAULT NULL COMMENT '创建时间',
UPDATE_TIME datetime DEFAULT NULL COMMENT '更新时间',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
UPDATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改人',
PL_VERSION varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '当前缓存版本',
DB_VERSION varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '当前DB库版本',
PRIMARY KEY (ID)
);
-- 删除表 ECI_NOTICE_INFO 如果存在
DROP TABLE IF EXISTS ECI_NOTICE_INFO;
-- 创建表 ECI_NOTICE_INFO，邮件通知消息
CREATE TABLE ECI_NOTICE_INFO
(
ID VARCHAR(50) NOT NULL COMMENT '主键',
BIZ_ID varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '查询业务主键',
TYPE_CODE varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '类型',
STATUS varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
SEND_DATE datetime DEFAULT NULL COMMENT '执行日期',
NOTICE_TO varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '收件人',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建用户',
UPDATE_DATE datetime DEFAULT NULL COMMENT '更新日期',
UPDATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新用户',
BIZ_TYPE varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务类型',
MESSAGE CLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '异常描述',
STACK_TRACE CLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代码报错信息',
FLOW_NO varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '环节',
NOTICE_CC varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '抄送人',
NOTICE_DATE datetime DEFAULT NULL COMMENT '计划发送日期',
BIZ_NO varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务单号',
PRIMARY KEY (ID)
);
-- 删除表 ECI_NOTICE_TYPE 如果存在
DROP TABLE IF EXISTS ECI_NOTICE_TYPE;
-- 创建表 ECI_NOTICE_TYPE，邮件通知类型
CREATE TABLE ECI_NOTICE_TYPE
(
ID VARCHAR(50) NOT NULL COMMENT '主键',
CODE VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '编码',
NAME VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '名称',
SUBJECT VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '主题',
BODY CLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '内容',
SQL_NAME VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'SQL语句',
CREATE_DATE datetime COMMENT '创建日期',
CREATE_USER VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建用户',
UPDATE_DATE datetime COMMENT '更新日期',
UPDATE_USER VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新用户',
IS_DELETE VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否删除',
STATUS varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
FLOW_NO VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '环节',
UNIQUE_CODE VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '唯一代码',
ONE_EXCEL varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '导出到一个EXCEL',
EXCEL_NAME VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '导出EXCEL名称',
FILE_API VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '下载文件API',
ON_EXCEL varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '在一个EXCEL中',
PRIMARY KEY (ID)
);
-- 删除表 ECI_NOTICE_TYPE_ATTACH 如果存在
DROP TABLE IF EXISTS ECI_NOTICE_TYPE_ATTACH;
-- 创建表 ECI_NOTICE_TYPE_ATTACH，邮件通知附件信息
CREATE TABLE ECI_NOTICE_TYPE_ATTACH
(
ID VARCHAR(50) NOT NULL COMMENT '主键',
HEAD_ID VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头表数据ID',
SQL_NAME VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'SQL语句',
NAME VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '名称',
CREATE_DATE datetime COMMENT '创建日期',
CREATE_USER VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建用户',
UPDATE_DATE datetime COMMENT '更新日期',
UPDATE_USER VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新用户',
IS_DELETE VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '是否删除',
USE_TEMPLATE_FILE varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '使用模板',
TEMPLATE_FILE VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板文件名称',
STATUS varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
TEMPLATE_FILE_CONTENT CLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板文件内容',
START_ROW VARCHAR(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '起始行',
HEAD_SQL VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头查询SQL语句',
PIC_MIN_ROW VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片开始行位置',
PIC_MAX_ROW VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片结束行位置',
PIC_MIN_COL VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片开始列位置',
PIC_MAX_COL VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片结束列位置',
TEMPLATE_PIC_CONTENT CLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片文件内容',
TEMPLATE_PIC VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板图片名称',
PRIMARY KEY (ID)
);
-- 删除表 ECI_NOTICE_TYPE_REF 如果存在
DROP TABLE IF EXISTS ECI_NOTICE_TYPE_REF;
-- 创建表 ECI_NOTICE_TYPE_REF，邮件通知类型引用
CREATE TABLE ECI_NOTICE_TYPE_REF
(
ID VARCHAR(36) NOT NULL COMMENT '主键',
HEAD_ID VARCHAR(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头表数据',
CODE VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代码',
NAME VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '名称',
SQL_NAME VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'SQL语句',
BODY CLOB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '内容',
CREATE_DATE datetime CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建日期',
CREATE_USER VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建用户',
UPDATE_DATE datetime CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改日期',
UPDATE_USER VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '修改用户',
STATUS varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
DETAIL_DATA varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '明细数据',
DATA_ROW_INDEX int CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据开始行',
PRIMARY KEY (ID)
);
CREATE TABLE "SYS_TASK_INFO"
(
"ID" BIGINT NOT NULL ENABLE,
"TASK_NAME" VARCHAR2(255) NOT NULL,
"TASK_NO" VARCHAR2(50) NOT NULL,
"TASK_TYPE" VARCHAR2(50) NOT NULL,
"TASK_STATUS" CHAR(1) DEFAULT NULL,
"LINK_URL" VARCHAR2(255) DEFAULT NULL,
"TASK_PROCESS" INT NOT NULL,
"TASK_PROCESS_DESC" VARCHAR2(255) DEFAULT NULL,
"CREATE_USER" VARCHAR2(36) NOT NULL,
"CREATE_TIME" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
"UPDATE_TIME" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
"REMARK" TEXT,
CONSTRAINT "SYS_TASK_INFO_PK" PRIMARY KEY ("ID")
)
-- ECI_TG.EA_LANG_DATA definition
DROP TABLE IF EXISTS EA_LANG_DATA;
CREATE TABLE EA_LANG_DATA
(
ID varchar(144) NOT NULL,
GROUP_CODE varchar(400) DEFAULT NULL,
LANG varchar(80) DEFAULT NULL,
CODE varchar(400) DEFAULT NULL,
NAME varchar(2000) DEFAULT NULL,
MEMO varchar(800) DEFAULT NULL,
NAME_ORI varchar(2000) DEFAULT NULL,
CREATE_DATE datetime DEFAULT NULL,
CREATE_USER varchar(200) DEFAULT NULL,
UPDATE_DATE datetime DEFAULT NULL,
UPDATE_USER varchar(200) DEFAULT NULL,
SEQ float DEFAULT NULL,
COMPANY_CODE varchar(200) DEFAULT NULL,
COMPANY_NAME varchar(800) DEFAULT NULL,
SYS_CODE varchar(80) DEFAULT NULL,
STATUS char(1) DEFAULT NULL,
TYPE_CODE varchar(50) DEFAULT NULL,
UDF1 varchar(300) DEFAULT NULL,
UDF2 varchar(300) DEFAULT NULL,
PRIMARY KEY (ID)
);
-- ECI_TG.EA_LANG_ENTITY definition
DROP TABLE IF EXISTS EA_LANG_ENTITY;
CREATE TABLE EA_LANG_ENTITY
(
ID varchar(144) NOT NULL,
CODE varchar(200) DEFAULT NULL,
NAME varchar(800) DEFAULT NULL,
TABLE_NAME varchar(400) DEFAULT NULL,
SQL varchar(2000) DEFAULT NULL,
MEMO varchar(400) DEFAULT NULL,
CREATE_DATE datetime DEFAULT NULL,
CREATE_USER varchar(200) DEFAULT NULL,
UPDATE_DATE datetime DEFAULT NULL,
UPDATE_USER varchar(200) DEFAULT NULL,
TYPE varchar(40) DEFAULT NULL,
SYS_ID varchar(144) DEFAULT NULL,
SYS_CODE varchar(200) DEFAULT NULL,
PRIMARY KEY (ID)
);
-- ECI_TG.ECI_DATA_CACHE definition
DROP TABLE IF EXISTS ECI_DATA_CACHE;
CREATE TABLE ECI_DATA_CACHE
(
GUID varchar(72) NOT NULL,
QUERY_TYPE varchar(200) NOT NULL,
STATUS varchar(2) DEFAULT NULL,
SQL varchar(1000) DEFAULT NULL,
MEMO varchar(800) DEFAULT NULL,
DATA_CHANGE_CODE varchar(200) DEFAULT NULL,
DATA_CHANGE_NAME varchar(200) DEFAULT NULL,
CREATE_DATE date DEFAULT NULL,
ECI_LOCK varchar(1) DEFAULT NULL,
CONVERT_SQL varchar(4000) DEFAULT NULL,
SYS varchar(1) DEFAULT NULL,
PL_VERSION varchar(200) DEFAULT NULL,
UPDATE_DATE date DEFAULT NULL,
NEED_DOWNLOAD varchar(1) DEFAULT NULL,
SORT_FIELD varchar(200) DEFAULT NULL,
MEMO_DETAIL varchar(800) DEFAULT NULL,
CREATE_USER varchar(72) DEFAULT NULL,
UPDATE_USER varchar(72) DEFAULT NULL,
ADMIN_LOCK varchar(1) DEFAULT NULL,
CODE_MEMO varchar(100) DEFAULT NULL,
NAME_MEMO varchar(100) DEFAULT NULL,
CHOOSE_SHOW varchar(200) DEFAULT NULL,
ASSEMBLY_NAME varchar(100) DEFAULT NULL,
USE_CACHE char(1) DEFAULT NULL
);
-- ECI_TG.ECI_DATA_CODE definition
DROP TABLE IF EXISTS ECI_DATA_CODE;
CREATE TABLE ECI_DATA_CODE
(
GROUP_CODE varchar(200) NOT NULL,
KEY_NAME varchar(200) DEFAULT NULL,
KEY_VALUE varchar(200) NOT NULL,
ID varchar(200) DEFAULT NULL,
STATUS varchar(1) DEFAULT NULL,
MEMO varchar(4000) DEFAULT NULL,
UDF1 varchar(400) DEFAULT NULL,
UDF2 varchar(200) DEFAULT NULL,
UDF3 varchar(200) DEFAULT NULL,
UDF4 varchar(200) DEFAULT NULL,
CREATE_DATE datetime DEFAULT NULL,
SEQ decimal(10, 0) DEFAULT NULL,
CREATE_USER varchar(72) DEFAULT NULL,
UPDATE_DATE datetime DEFAULT NULL,
UPDATE_USER varchar(72) DEFAULT NULL,
ADMIN_LOCK varchar(1) DEFAULT NULL,
UDF5 varchar(200) DEFAULT NULL,
PRIMARY KEY (GROUP_CODE, KEY_VALUE)
);
-- ECI_TG.ECI_DATA_GROUP definition
DROP TABLE IF EXISTS ECI_DATA_GROUP;
CREATE TABLE ECI_DATA_GROUP
(
GROUP_NAME varchar(36) DEFAULT NULL,
ID varchar(200) DEFAULT NULL,
STATUS varchar(1) DEFAULT NULL,
MEMO varchar(200) DEFAULT NULL,
GROUP_CODE varchar(200) NOT NULL,
CREATE_USER varchar(72) DEFAULT NULL,
CREATE_DATE datetime DEFAULT NULL,
UPDATE_USER varchar(72) DEFAULT NULL,
UPDATE_DATE datetime DEFAULT NULL,
ADMIN_LOCK varchar(1) DEFAULT NULL,
CATELOG varchar(72) DEFAULT NULL
);
-- ECI_TG.ECI_DATA_HELP definition
DROP TABLE IF EXISTS ECI_DATA_HELP;
CREATE TABLE ECI_DATA_HELP
(
GUID varchar(72) NOT NULL,
QUERY_TYPE varchar(200) NOT NULL,
STATUS varchar(2) DEFAULT NULL,
SQL varchar(2000) DEFAULT NULL,
MEMO varchar(800) DEFAULT NULL,
DATA_CHANGE_CODE varchar(200) DEFAULT NULL,
DATA_CHANGE_NAME varchar(200) DEFAULT NULL,
CREATE_DATE datetime DEFAULT NULL,
ECI_LOCK varchar(1) DEFAULT NULL,
CONVERT_SQL varchar(4000) DEFAULT NULL,
SYS varchar(1) DEFAULT NULL,
PL_VERSION varchar(200) DEFAULT NULL,
UPDATE_DATE datetime DEFAULT NULL,
NEED_DOWNLOAD varchar(1) DEFAULT NULL,
SORT_FIELD varchar(200) DEFAULT NULL,
MEMO_DETAIL varchar(800) DEFAULT NULL,
CREATE_USER varchar(72) DEFAULT NULL,
UPDATE_USER varchar(72) DEFAULT NULL,
ADMIN_LOCK varchar(1) DEFAULT NULL,
CODE_MEMO varchar(100) DEFAULT NULL,
NAME_MEMO varchar(100) DEFAULT NULL,
CHOOSE_SHOW varchar(200) DEFAULT NULL,
ASSEMBLY_NAME varchar(100) DEFAULT NULL,
USE_CACHE char(1) DEFAULT 'N',
QUERY_FIELD varchar(255) DEFAULT NULL,
SYS_CODE varchar(255) DEFAULT NULL,
AUTO_UPPER varchar(255) DEFAULT NULL,
FILTER varchar(255) DEFAULT NULL,
COMPARE_TYPE varchar(255) DEFAULT NULL,
LAYOUT varchar(255) DEFAULT NULL,
EDIT_URL varchar(255) DEFAULT NULL,
CONFIG varchar(255) DEFAULT NULL,
QUERY_DATA varchar(255) DEFAULT NULL,
PAGE_SIZE varchar(20) DEFAULT NULL,
QUERY_MODE varchar(20) DEFAULT NULL,
PRIMARY KEY (QUERY_TYPE)
);
-- ECI_TG.ECI_FILE_BIZ_TYPE definition
DROP TABLE IF EXISTS ECI_FILE_BIZ_TYPE;
CREATE TABLE ECI_FILE_BIZ_TYPE
(
GUID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
CODE varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '代码',
NAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名称',
CONFIG varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '配置',
STATUS char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '状态',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
IS_DELETE char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '是否删除',
SAVE_DB varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '是否保存到数据库',
CATALOG varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类别',
MEMO varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
FILE_TYPE varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '文件类型',
MAX_NUM int DEFAULT NULL COMMENT '最大数量',
MAX_SIZE int DEFAULT NULL COMMENT '文件大小',
PRIMARY KEY (GUID)
);
-- ECI_TG.ECI_FILE_CONTENT definition
DROP TABLE IF EXISTS ECI_FILE_CONTENT;
CREATE TABLE ECI_FILE_CONTENT
(
GUID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
FILE_ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件主键',
DATA_CONTENT text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '文件内容',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
UPDATE_DATE datetime DEFAULT NULL COMMENT '更新日期',
UPDATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
PRIMARY KEY (GUID)
);
-- ECI_TG.ECI_FILE_INFO definition
DROP TABLE IF EXISTS ECI_FILE_INFO;
CREATE TABLE ECI_FILE_INFO
(
GUID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
BIZ_NO varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务单号',
BIZ_TYPE varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务类型',
TYPE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类型',
FILE_NAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '文件名',
FILE_NAME_ORI varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '原文件名',
PATH varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '文件路径',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
SEQ int DEFAULT NULL COMMENT '序号',
SAVE_DB varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '是否保存数据库',
DATA_CONTENT text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '文件内容',
STATUS varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '状态',
CATALOG varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类别',
EXTENSION varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '拓展名',
FILE_LENGTH int DEFAULT NULL COMMENT '文件大小',
P_NO varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '字段编号',
PRIMARY KEY (GUID)
);
-- ECI_TG.ECI_FILE_INFO_TEMP definition
DROP TABLE IF EXISTS ECI_FILE_INFO_TEMP;
CREATE TABLE ECI_FILE_INFO_TEMP
(
GUID varchar(36) NOT NULL,
BIZ_NO varchar(100) DEFAULT NULL,
BIZ_TYPE varchar(50) DEFAULT NULL,
TYPE varchar(20) DEFAULT NULL,
FILE_NAME varchar(100) DEFAULT NULL,
FILE_NAME_ORI varchar(100) DEFAULT NULL,
PATH varchar(500) DEFAULT NULL,
CREATE_DATE datetime DEFAULT NULL,
CREATE_USER varchar(50) DEFAULT NULL,
SEQ int DEFAULT NULL,
PRIMARY KEY (GUID)
);
-- ECI_TG.ECI_NS_BIZ_TYPE definition
DROP TABLE IF EXISTS ECI_NS_BIZ_TYPE;
CREATE TABLE ECI_NS_BIZ_TYPE
(
ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '代码',
NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名称',
STATUS varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '状态',
SEQ int DEFAULT NULL COMMENT '顺序',
MEMO varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
UPDATE_DATE datetime DEFAULT NULL COMMENT '更新日期',
UPDATE_USER varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
ASSEMBLY_NAME varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '应用程序集',
VIEW_URL varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '查阅地址',
ACTION1_NAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '一级审批名称',
ACTION2_NAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '二级审批名称',
ACTION3_NAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '三级审批名称',
SUB_URL varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '明细地址',
CATELOG varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审批分类',
PRINT_URL varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '打印地址',
APPLY_CATELOG varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '申报分类',
BIZ_ID varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务主键',
PRIMARY KEY (ID)
);
-- ECI_TG.ECI_NS_BIZ_TYPE_ATTR definition
DROP TABLE IF EXISTS ECI_NS_BIZ_TYPE_ATTR;
CREATE TABLE ECI_NS_BIZ_TYPE_ATTR
(
ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
BIZ_TYPE varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务类型',
ATTR_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '属性中文名',
ATTR_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '属性代码',
SAVE_FIELD varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '保存字段',
UI_TYPE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '控件类型',
UI_CONFIG varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '控件配置',
PRIMARY KEY (ID)
);
-- ECI_TG.ECI_NS_COM_CONFIG definition
DROP TABLE IF EXISTS ECI_NS_COM_CONFIG;
CREATE TABLE ECI_NS_COM_CONFIG
(
ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
COMPANY_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '企业代码',
COMPANY_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '企业名称',
BIZ_TYPE varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务类型',
AUDIT_LEVEL varchar(10) DEFAULT NULL COMMENT '审批级别',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
UPDATE_DATE datetime DEFAULT NULL COMMENT '更新日期',
UPDATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
ATTR_MEMO varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '拓展属性',
TIP_APPLY_HG varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' COMMENT '是否提示申报',
PRIMARY KEY (ID)
);
-- ECI_TG.ECI_NS_COM_CONFIG_ATTR definition
DROP TABLE IF EXISTS ECI_NS_COM_CONFIG_ATTR;
CREATE TABLE ECI_NS_COM_CONFIG_ATTR
(
ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
HEAD_ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '关键主键',
ATTR_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '属性代码',
ATTR_VALUE varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '属性值',
ATTR_VALUE_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '属性值名称',
PRIMARY KEY (ID)
);
-- ECI_TG.ECI_NS_COM_SWITCH definition
DROP TABLE IF EXISTS ECI_NS_COM_SWITCH;
CREATE TABLE ECI_NS_COM_SWITCH
(
ID varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
COMPANY_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '公司代码',
COMPANY_NAME varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '公司名称',
BIZ_TYPE varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务类型',
STATUS varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '是否启用',
VIEW_URL varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '查阅地址',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
UPDATE_DATE datetime DEFAULT NULL COMMENT '更新日期',
UPDATE_USER varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
PRIMARY KEY (ID)
);
-- ECI_TG.ECI_NS_TASK definition
DROP TABLE IF EXISTS ECI_NS_TASK;
CREATE TABLE ECI_NS_TASK
(
TASK_ID varchar(144) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '审单编号',
BIZ_NO varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务编号',
BIZ_TYPE varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '内审类型',
SUMMARY varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '摘要',
APPLY_DATE datetime DEFAULT NULL COMMENT '申请日期',
APPLY_USER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '申请人',
CREATE_DATE datetime DEFAULT NULL COMMENT '创建日期',
CREATE_USER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
CREATE_USER_ID varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人Id',
STATUS varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '内审状态',
COMPANY_CODE varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作企业代码',
COMPANY_NAME varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作企业名称',
DCL_CODE varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '申报企业代码',
DCL_NAME varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '申报企业名称',
QW_CODE varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '区外企业代码',
QW_NAME varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '区外企业名称',
UDF1 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '扩展信息1',
UDF2 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '扩展信息2',
UDF3 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '扩展信息3',
UDF4 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '扩展信息4',
UDF5 varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '扩展信息5',
INPUT_USER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '录入人',
INPUT_DATE datetime DEFAULT NULL COMMENT '录入日期',
UPDATE_DATE datetime DEFAULT NULL COMMENT '更新日期',
UPDATE_USER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
AUDIT_USER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '处理人',
AUDIT_DATE datetime DEFAULT NULL COMMENT '处理日期',
STATUS_NAME varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '内审状态名称',
BIZ_ID varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务主键',
SUB_NO varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '明细编号',
TAG varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'TAG',
CUSTOMER_NO varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '企业内控编号',
SUB_URL varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '明细地址',
TRADE_CODE varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '经营单位代码',
TRADE_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '经营单位名称',
TH_REASON varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '退回原因',
PRIMARY KEY (TASK_ID)
);
-- ECI_TG.ECI_NS_TRACE definition
DROP TABLE IF EXISTS ECI_NS_TRACE;
CREATE TABLE ECI_NS_TRACE
(
ID varchar(144) NOT NULL,
TASK_ID varchar(144) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审单编号',
BIZ_NO varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '业务编号',
BIZ_TYPE varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '内审类型',
OPER_USER varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作人',
OPER_DATE datetime DEFAULT NULL COMMENT '操作日期',
AUDIT_MEMO varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '审批意见',
OPER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作名称',
OPER_CODE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作代码',
PRIMARY KEY (ID)
);
-- ECI_TG.TG_JOB definition
DROP TABLE IF EXISTS TG_JOB;
CREATE TABLE TG_JOB
(
ID bigint NOT NULL AUTO_INCREMENT COMMENT '任务编号',
NAME varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
STATUS varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务状态',
HANDLER_NAME varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '处理器的名字',
HANDLER_PARAM varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '处理器的参数',
CRON_EXPRESSION varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'CRON 表达式',
RETRY_COUNT int NOT NULL DEFAULT '0' COMMENT '重试次数',
RETRY_INTERVAL int NOT NULL DEFAULT '0' COMMENT '重试间隔',
MONITOR_TIMEOUT int NOT NULL DEFAULT '0' COMMENT '监控超时时间',
CREATOR varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
CREATE_TIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
UPDATER varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
UPDATE_TIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
DELETED int NOT NULL DEFAULT '0' COMMENT '是否删除',
PRIMARY KEY (ID)
);
-- ECI_TG.TG_JOB_LOG definition
DROP TABLE IF EXISTS TG_JOB_LOG;
CREATE TABLE TG_JOB_LOG
(
ID bigint NOT NULL AUTO_INCREMENT COMMENT '日志编号',
JOB_ID bigint NOT NULL COMMENT '任务编号',
HANDLER_NAME varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '处理器的名字',
HANDLER_PARAM varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '处理器的参数',
EXECUTE_INDEX bigint NOT NULL DEFAULT '1' COMMENT '第几次执行',
BEGIN_TIME datetime NOT NULL COMMENT '开始执行时间',
END_TIME datetime DEFAULT NULL COMMENT '结束执行时间',
DURATION int DEFAULT NULL COMMENT '执行时长',
STATUS varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务状态',
RESULT varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '结果数据',
CREATOR varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
CREATE_TIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
UPDATER varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
UPDATE_TIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
DELETED int NOT NULL DEFAULT '0' COMMENT '是否删除',
PRIMARY KEY (ID)
);
-- ECI_TG.QRTZ_CALENDARS definition
DROP TABLE IF EXISTS QRTZ_CALENDARS;
CREATE TABLE QRTZ_CALENDARS
(
SCHED_NAME varchar(120) NOT NULL,
CALENDAR_NAME varchar(190) NOT NULL,
CALENDAR blob NOT NULL,
PRIMARY KEY (SCHED_NAME, CALENDAR_NAME)
);
-- ECI_TG.QRTZ_FIRED_TRIGGERS definition
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
CREATE TABLE QRTZ_FIRED_TRIGGERS
(
SCHED_NAME varchar(120) NOT NULL,
ENTRY_ID varchar(95) NOT NULL,
TRIGGER_NAME varchar(190) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
INSTANCE_NAME varchar(190) NOT NULL,
FIRED_TIME bigint NOT NULL,
SCHED_TIME bigint NOT NULL,
PRIORITY int NOT NULL,
STATE varchar(16) NOT NULL,
JOB_NAME varchar(190) DEFAULT NULL,
JOB_GROUP varchar(190) DEFAULT NULL,
IS_NONCONCURRENT varchar(1) DEFAULT NULL,
REQUESTS_RECOVERY varchar(1) DEFAULT NULL,
PRIMARY KEY (SCHED_NAME, ENTRY_ID)
);
-- ECI_TG.QRTZ_JOB_DETAILS definition
DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
CREATE TABLE QRTZ_JOB_DETAILS
(
SCHED_NAME varchar(120) NOT NULL,
JOB_NAME varchar(190) NOT NULL,
JOB_GROUP varchar(190) NOT NULL,
DESCRIPTION varchar(250) DEFAULT NULL,
JOB_CLASS_NAME varchar(250) NOT NULL,
IS_DURABLE varchar(1) NOT NULL,
IS_NONCONCURRENT varchar(1) NOT NULL,
IS_UPDATE_DATA varchar(1) NOT NULL,
REQUESTS_RECOVERY varchar(1) NOT NULL,
JOB_DATA blob,
PRIMARY KEY (SCHED_NAME, JOB_NAME, JOB_GROUP)
);
-- ECI_TG.QRTZ_LOCKS definition
DROP TABLE IF EXISTS QRTZ_LOCKS;
CREATE TABLE QRTZ_LOCKS
(
SCHED_NAME varchar(120) NOT NULL,
LOCK_NAME varchar(40) NOT NULL,
PRIMARY KEY (SCHED_NAME, LOCK_NAME)
);
-- ECI_TG.QRTZ_PAUSED_TRIGGER_GRPS definition
DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS
(
SCHED_NAME varchar(120) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_GROUP)
);
-- ECI_TG.QRTZ_SCHEDULER_STATE definition
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
CREATE TABLE QRTZ_SCHEDULER_STATE
(
SCHED_NAME varchar(120) NOT NULL,
INSTANCE_NAME varchar(190) NOT NULL,
LAST_CHECKIN_TIME bigint NOT NULL,
CHECKIN_INTERVAL bigint NOT NULL,
PRIMARY KEY (SCHED_NAME, INSTANCE_NAME)
);
-- ECI_TG.QRTZ_TRIGGERS definition
DROP TABLE IF EXISTS QRTZ_TRIGGERS;
CREATE TABLE QRTZ_TRIGGERS
(
SCHED_NAME varchar(120) NOT NULL,
TRIGGER_NAME varchar(190) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
JOB_NAME varchar(190) NOT NULL,
JOB_GROUP varchar(190) NOT NULL,
DESCRIPTION varchar(250) DEFAULT NULL,
NEXT_FIRE_TIME bigint DEFAULT NULL,
PREV_FIRE_TIME bigint DEFAULT NULL,
PRIORITY int DEFAULT NULL,
TRIGGER_STATE varchar(16) NOT NULL,
TRIGGER_TYPE varchar(8) NOT NULL,
START_TIME bigint NOT NULL,
END_TIME bigint DEFAULT NULL,
CALENDAR_NAME varchar(190) DEFAULT NULL,
MISFIRE_INSTR tinyint DEFAULT NULL,
JOB_DATA blob,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
-- ECI_TG.QRTZ_BLOB_TRIGGERS definition
DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
CREATE TABLE QRTZ_BLOB_TRIGGERS
(
SCHED_NAME varchar(120) NOT NULL,
TRIGGER_NAME varchar(190) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
BLOB_DATA blob,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
-- ECI_TG.QRTZ_SIMPLE_TRIGGERS definition
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
CREATE TABLE QRTZ_SIMPLE_TRIGGERS
(
SCHED_NAME varchar(120) NOT NULL,
TRIGGER_NAME varchar(190) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
REPEAT_COUNT bigint NOT NULL,
REPEAT_INTERVAL bigint NOT NULL,
TIMES_TRIGGERED bigint NOT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
-- ECI_TG.QRTZ_SIMPROP_TRIGGERS definition
DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;
CREATE TABLE QRTZ_SIMPROP_TRIGGERS
(
SCHED_NAME varchar(120) NOT NULL,
TRIGGER_NAME varchar(190) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
STR_PROP_1 varchar(512) DEFAULT NULL,
STR_PROP_2 varchar(512) DEFAULT NULL,
STR_PROP_3 varchar(512) DEFAULT NULL,
INT_PROP_1 int DEFAULT NULL,
INT_PROP_2 int DEFAULT NULL,
LONG_PROP_1 bigint DEFAULT NULL,
LONG_PROP_2 bigint DEFAULT NULL,
DEC_PROP_1 decimal(13, 4) DEFAULT NULL,
DEC_PROP_2 decimal(13, 4) DEFAULT NULL,
BOOL_PROP_1 varchar(1) DEFAULT NULL,
BOOL_PROP_2 varchar(1) DEFAULT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
-- ECI_TG.QRTZ_CRON_TRIGGERS definition
DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
CREATE TABLE QRTZ_CRON_TRIGGERS
(
SCHED_NAME varchar(120) NOT NULL,
TRIGGER_NAME varchar(190) NOT NULL,
TRIGGER_GROUP varchar(190) NOT NULL,
CRON_EXPRESSION varchar(120) NOT NULL,
TIME_ZONE_ID varchar(80) DEFAULT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
上次更新: 2024/5/23 14:31:04