CREATE TABLE "sys_oper_log"
(
"id"             int8 NOT NULL,
"title"          varchar(100),
"business_type"  int4,
"oper_url"       varchar(255),
"method"         varchar(255),
"request_method" varchar(10),
"oper_ip"        varchar(15),
"oper_location"  varchar(100),
"oper_status"    int4,
"error_msg"      text,
"oper_time"      timestamp(6),
"oper_param"     text,
"json_result"    text,
"user_id"        varchar(64),
"login_name"     varchar(64),
"oper_os"        varchar(20),
"browser"        varchar(50),
"server"         varchar(20),
CONSTRAINT "sys_oper_log_pkey" PRIMARY KEY ("id")
)
;
COMMENT
ON COLUMN "sys_oper_log"."id" IS '主键id';
COMMENT
ON COLUMN "sys_oper_log"."title" IS '操作模块';
COMMENT
ON COLUMN "sys_oper_log"."business_type" IS '业务类型|0其它 1新增 2修改 3删除';
COMMENT
ON COLUMN "sys_oper_log"."oper_url" IS '请求url';
COMMENT
ON COLUMN "sys_oper_log"."method" IS '请求后端方法';
COMMENT
ON COLUMN "sys_oper_log"."request_method" IS '请求方式';
COMMENT
ON COLUMN "sys_oper_log"."oper_ip" IS '操作地址';
COMMENT
ON COLUMN "sys_oper_log"."oper_location" IS '操作地点';
COMMENT
ON COLUMN "sys_oper_log"."oper_status" IS '操作状态|0正常 1异常';
COMMENT
ON COLUMN "sys_oper_log"."error_msg" IS '错误消息';
COMMENT
ON COLUMN "sys_oper_log"."oper_time" IS '操作时间';
COMMENT
ON COLUMN "sys_oper_log"."oper_param" IS '请求参数';
COMMENT
ON COLUMN "sys_oper_log"."json_result" IS '返回响应体';
COMMENT
ON COLUMN "sys_oper_log"."user_id" IS '用户id';
COMMENT
ON COLUMN "sys_oper_log"."login_name" IS '用户名';
COMMENT
ON COLUMN "sys_oper_log"."oper_os" IS '操作系统';
COMMENT
ON COLUMN "sys_oper_log"."browser" IS '浏览器';
COMMENT
ON COLUMN "sys_oper_log"."server" IS '本地服务器';
COMMENT
ON TABLE "sys_oper_log" IS '操作日志记录表';

CREATE TABLE "SYS_DATA_HELP"
(
"ID"               NUMBER(20),
"QUERY_KEY"        VARCHAR2(200) DEFAULT NULL,
"QUERY_TYPE"       VARCHAR2(1) DEFAULT NULL,
"SQL_COMMAND"      VARCHAR2(2000) DEFAULT NULL,
"BASE_COMMENT"     VARCHAR2(800) DEFAULT NULL,
"SYS"              VARCHAR2(30) DEFAULT NULL,
"CREATE_TIME"      date DEFAULT NULL,
"UPDATE_TIME"      date DEFAULT NULL,
"USE_CACHE"        VARCHAR2(10) DEFAULT 'N',
"LANGUAGE_TYPE"    VARCHAR2(10) DEFAULT NULL,
"DATA_CHANGE_CODE" VARCHAR2(50) DEFAULT NULL,
"DATA_CHANGE_NAME" VARCHAR2(50) DEFAULT NULL,
"TG_SORT_FIELD"    VARCHAR2(50) DEFAULT NULL,
"CREATE_USER"      VARCHAR2(50) DEFAULT NULL,
"UPDATE_USER"      VARCHAR2(50) DEFAULT NULL,
"CODE_MEMO"        VARCHAR2(50) DEFAULT NULL,
"NAME_MEMO"        VARCHAR2(50) DEFAULT NULL,
"COMPARE_TYPE"     VARCHAR2(20) DEFAULT NULL,
"CHOOSE_SHOW"      VARCHAR2(2000) DEFAULT NULL,
"TG_QUERY_FIELD"   VARCHAR2(100) DEFAULT NULL,
"AUTO_UPPER"       VARCHAR2(1) DEFAULT NULL,
"QUERY_MODE"       VARCHAR2(20) DEFAULT NULL,
"STATUS"           VARCHAR2(2) DEFAULT NULL,
"ECI_LOCK"         VARCHAR2(1) DEFAULT NULL,
"CONVERT_SQL"      VARCHAR2(2000) DEFAULT NULL,
"PL_VERSION"       VARCHAR2(200) DEFAULT NULL,
"NEED_DOWNLOAD"    VARCHAR2(1) DEFAULT NULL,
"MEMO_DETAIL"      VARCHAR2(800) DEFAULT NULL,
"ADMIN_LOCK"       VARCHAR2(1) DEFAULT NULL,
"ASSEMBLY_NAME"    VARCHAR2(400) DEFAULT NULL,
"FILTER"           VARCHAR2(1) DEFAULT NULL,
"LAYOUT"           VARCHAR2(200) DEFAULT NULL,
"EDIT_URL"         VARCHAR2(255) DEFAULT NULL,
"CONFIG"           VARCHAR2(255) DEFAULT NULL,
"WIDTH"            VARCHAR2(20) DEFAULT NULL,
"HEIGHT"           VARCHAR2(20) DEFAULT NULL,
"QUERY_DATA"       VARCHAR2(255) DEFAULT NULL,
"TG_PAGE_SIZE"     VARCHAR2(20) DEFAULT NULL,
PRIMARY KEY ("ID")
);
COMMENT
ON TABLE SYS_DATA_HELP is '基础参数维护';
COMMENT
ON COLUMN SYS_DATA_HELP.ID is '自增主键';
COMMENT
ON COLUMN SYS_DATA_HELP.QUERY_KEY is '查询key';
COMMENT
ON COLUMN SYS_DATA_HELP.QUERY_TYPE is '查询类型1:下拉框 2:放大镜';
COMMENT
ON COLUMN SYS_DATA_HELP.SQL_COMMAND is 'SQL';
COMMENT
ON COLUMN SYS_DATA_HELP.BASE_COMMENT is '说明';
COMMENT
ON COLUMN SYS_DATA_HELP.SYS is '使用系统';
COMMENT
ON COLUMN SYS_DATA_HELP.CREATE_TIME is '创建时间';
COMMENT
ON COLUMN SYS_DATA_HELP.UPDATE_TIME is '更新时间';
COMMENT
ON COLUMN SYS_DATA_HELP.USE_CACHE is '缓存启用状态0不用1用';
COMMENT
ON COLUMN SYS_DATA_HELP.LANGUAGE_TYPE is '语言类型';
COMMENT
ON COLUMN SYS_DATA_HELP.DATA_CHANGE_CODE is '数据转换代码';
COMMENT
ON COLUMN SYS_DATA_HELP.DATA_CHANGE_NAME is '数据转换名称';
COMMENT
ON COLUMN SYS_DATA_HELP.TG_SORT_FIELD is '排序';
COMMENT
ON COLUMN SYS_DATA_HELP.CREATE_USER is '创建人';
COMMENT
ON COLUMN SYS_DATA_HELP.UPDATE_USER is '修改人';
COMMENT
ON COLUMN SYS_DATA_HELP.CODE_MEMO is '代码描述';
COMMENT
ON COLUMN SYS_DATA_HELP.NAME_MEMO is '名称描述';
COMMENT
ON COLUMN SYS_DATA_HELP.COMPARE_TYPE is '查询方式 like eq';
COMMENT
ON COLUMN SYS_DATA_HELP.CHOOSE_SHOW is '放大镜显示-----功能暂不实现';
COMMENT
ON COLUMN SYS_DATA_HELP.TG_QUERY_FIELD is '查询列和conn配合使用-----功能暂不实现';
COMMENT
ON COLUMN SYS_DATA_HELP.AUTO_UPPER is '自动转大写-----功能暂不实现';
COMMENT
ON COLUMN SYS_DATA_HELP.QUERY_MODE is '查询模式-----功能暂不实现';
COMMENT
ON COLUMN SYS_DATA_HELP.STATUS is '状态-----保留';
COMMENT
ON COLUMN SYS_DATA_HELP.ECI_LOCK is '锁定状态';
COMMENT
ON COLUMN SYS_DATA_HELP.CONVERT_SQL is '转换SQL';
COMMENT
ON COLUMN SYS_DATA_HELP.PL_VERSION is '当前版本';
COMMENT
ON COLUMN SYS_DATA_HELP.NEED_DOWNLOAD is '是否需要下载';
COMMENT
ON COLUMN SYS_DATA_HELP.ADMIN_LOCK is '管理员锁定';
COMMENT
ON COLUMN SYS_DATA_HELP.ASSEMBLY_NAME is '程序集扩展';
COMMENT
ON COLUMN SYS_DATA_HELP.FILTER is '打开页面是否条件过滤';
COMMENT
ON COLUMN SYS_DATA_HELP.LAYOUT is '布局';
COMMENT
ON COLUMN SYS_DATA_HELP.EDIT_URL is '编辑地址';
COMMENT
ON COLUMN SYS_DATA_HELP.CONFIG is '配置信息';
COMMENT
ON COLUMN SYS_DATA_HELP.WIDTH is '宽度';
COMMENT
ON COLUMN SYS_DATA_HELP.HEIGHT is '高度';
COMMENT
ON COLUMN SYS_DATA_HELP.QUERY_DATA is '查询数据';
COMMENT
ON COLUMN SYS_DATA_HELP.TG_PAGE_SIZE is '分页大小';

CREATE TABLE "sys_user_info"
(
"id"                   int8         NOT NULL,
"user_id"              varchar(50)  NOT NULL,
"login_name"           varchar(30)  NOT NULL,
"true_name"            varchar(30),
"company_code"         varchar(10)  NOT NULL,
"company_name"         varchar(255) NOT NULL,
"cust_code"            varchar(4),
"cust_name"            varchar(20),
"user_nickname"        varchar(30),
"user_img"             varchar(255) DEFAULT NULL:: varchar,
"user_sex"             varchar(1)   DEFAULT '0':: varchar,
"login_count"          int4         DEFAULT 0,
"login_time"           timestamp(6),
"login_last_time"      timestamp(6),
"client_ip"            varchar(30),
"client_province"      varchar(30),
"client_city"          varchar(30),
"client_browser"       varchar(30),
"client_os"            varchar(30),
"user_token"           varchar(255),
"bind_phone_no"        varchar(20),
"web_side_type"        varchar(1)   DEFAULT '2':: varchar,
"web_head_type"        varchar(1)   DEFAULT '3':: varchar,
"web_theme"            varchar(10)  DEFAULT '#409eff':: varchar,
"web_layout"           varchar(1)   DEFAULT '3':: varchar,
"web_side_is_icon"     varchar(1)   DEFAULT '1':: varchar,
"web_side_is_open"     varchar(1)   DEFAULT '1':: varchar,
"web_is_tab"           varchar(1)   DEFAULT '1':: varchar,
"web_tab_type"         varchar(1)   DEFAULT '1':: varchar,
"mail_address"         varchar(255),
"pwd_last_update_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"dev"                  varchar(1)   DEFAULT '0':: varchar,
CONSTRAINT "sys_user_info_pkey" PRIMARY KEY ("id")
);
COMMENT
ON COLUMN "sys_user_info"."id" IS '自增列';
COMMENT
ON COLUMN "sys_user_info"."user_id" IS '权限平台用户ID';
COMMENT
ON COLUMN "sys_user_info"."login_name" IS '权限平台登录用户名';
COMMENT
ON COLUMN "sys_user_info"."true_name" IS '权限平台真实姓名';
COMMENT
ON COLUMN "sys_user_info"."company_code" IS '企业代码';
COMMENT
ON COLUMN "sys_user_info"."company_name" IS '企业名称';
COMMENT
ON COLUMN "sys_user_info"."cust_code" IS '关区代码';
COMMENT
ON COLUMN "sys_user_info"."cust_name" IS '关区名称';
COMMENT
ON COLUMN "sys_user_info"."user_nickname" IS '用户别名';
COMMENT
ON COLUMN "sys_user_info"."user_img" IS '头像';
COMMENT
ON COLUMN "sys_user_info"."user_sex" IS '性别(0-保密/1-男/2-女)';
COMMENT
ON COLUMN "sys_user_info"."login_count" IS '登录次数';
COMMENT
ON COLUMN "sys_user_info"."login_time" IS '本次登录时间';
COMMENT
ON COLUMN "sys_user_info"."login_last_time" IS '上次登录时间';
COMMENT
ON COLUMN "sys_user_info"."client_ip" IS '客户端IP';
COMMENT
ON COLUMN "sys_user_info"."client_province" IS '客户端IP所在省份';
COMMENT
ON COLUMN "sys_user_info"."client_city" IS '客户端IP所在城市';
COMMENT
ON COLUMN "sys_user_info"."client_browser" IS '客户端浏览器';
COMMENT
ON COLUMN "sys_user_info"."client_os" IS '客户端操作系统';
COMMENT
ON COLUMN "sys_user_info"."user_token" IS 'USER_TOKEN';
COMMENT
ON COLUMN "sys_user_info"."bind_phone_no" IS '绑定手机号';
COMMENT
ON COLUMN "sys_user_info"."web_side_type" IS '侧边栏类型(1-栏式1/2-栏式2)';
COMMENT
ON COLUMN "sys_user_info"."web_head_type" IS '顶部模式(1-白/2-黑/3-主题色)';
COMMENT
ON COLUMN "sys_user_info"."web_theme" IS '主题颜色';
COMMENT
ON COLUMN "sys_user_info"."web_layout" IS '布局模式(1-侧边/2-顶部/3-混合)';
COMMENT
ON COLUMN "sys_user_info"."web_side_is_icon" IS '侧边栏彩色图标';
COMMENT
ON COLUMN "sys_user_info"."web_side_is_open" IS '侧栏排它展开';
COMMENT
ON COLUMN "sys_user_info"."web_is_tab" IS '启用标签页';
COMMENT
ON COLUMN "sys_user_info"."web_tab_type" IS '标签显示风格(1-默认/2-圆点/3-卡片)';
COMMENT
ON COLUMN "sys_user_info"."mail_address" IS '用户邮箱地址';
COMMENT
ON COLUMN "sys_user_info"."pwd_last_update_time" IS '密码最后修改时间';
COMMENT
ON COLUMN "sys_user_info"."dev" IS '是否运维|0否1是';
COMMENT
ON TABLE "sys_user_info" IS '用户信息';

CREATE TABLE "sys_user_login_log"
(
"id"                int8 NOT NULL,
"user_id"           varchar(50),
"login_name"        varchar(30),
"sys_code"          varchar(30),
"client_ip"         varchar(30),
"client_province"   varchar(30),
"client_city"       varchar(30),
"client_browser"    varchar(30),
"client_os"         varchar(30),
"login_time"        timestamp(6),
"login_status"      int4,
"login_description" varchar(255),
"action_params"     text,
CONSTRAINT "sys_user_login_log_pkey" PRIMARY KEY ("id")
);
COMMENT
ON COLUMN "sys_user_login_log"."id" IS '自增列(业务无关)';
COMMENT
ON COLUMN "sys_user_login_log"."user_id" IS '权限平台用户ID';
COMMENT
ON COLUMN "sys_user_login_log"."login_name" IS '权限平台登录用户名';
COMMENT
ON COLUMN "sys_user_login_log"."sys_code" IS '系统代码';
COMMENT
ON COLUMN "sys_user_login_log"."client_ip" IS '客户端IP';
COMMENT
ON COLUMN "sys_user_login_log"."client_province" IS '客户端IP所在省份';
COMMENT
ON COLUMN "sys_user_login_log"."client_city" IS '客户端IP所在城市';
COMMENT
ON COLUMN "sys_user_login_log"."client_browser" IS '客户端浏览器';
COMMENT
ON COLUMN "sys_user_login_log"."client_os" IS '客户端操作系统';
COMMENT
ON COLUMN "sys_user_login_log"."login_time" IS '登录时间';
COMMENT
ON COLUMN "sys_user_login_log"."login_status" IS '登录状态(1-成功/0-失败)';
COMMENT
ON COLUMN "sys_user_login_log"."login_description" IS '登录失败原因';
COMMENT
ON COLUMN "sys_user_login_log"."action_params" IS '请求参数';
COMMENT
ON TABLE "sys_user_login_log" IS '用户登录日志';

CREATE TABLE "sys_enterprise_info"
(
"id"           int8         NOT NULL,
"company_code" varchar(10)  NOT NULL,
"company_name" varchar(255) NOT NULL,
"ep_sccd"      varchar(18),
"cust_code"    varchar(4),
"cust_name"    varchar(20),
"contacts"     varchar(100),
"contacts_tel" varchar(100),
"mail_address" varchar(255),
"ep_address"   varchar(255),
"ep_logo_url"  varchar(255),
"ep_sys_name"  varchar(255),
"remark"       varchar(255),
"create_time"  timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"update_time"  timestamp(6) DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "sys_enterprise_info_pkey" PRIMARY KEY ("id")
);
COMMENT
ON COLUMN "sys_enterprise_info"."id" IS '自增列(业务无关)';
COMMENT
ON COLUMN "sys_enterprise_info"."company_code" IS '企业编码';
COMMENT
ON COLUMN "sys_enterprise_info"."company_name" IS '企业名称';
COMMENT
ON COLUMN "sys_enterprise_info"."ep_sccd" IS '企业18位社会信用代码';
COMMENT
ON COLUMN "sys_enterprise_info"."cust_code" IS '关区代码';
COMMENT
ON COLUMN "sys_enterprise_info"."cust_name" IS '关区名称';
COMMENT
ON COLUMN "sys_enterprise_info"."contacts" IS '联系人';
COMMENT
ON COLUMN "sys_enterprise_info"."contacts_tel" IS '联系电话';
COMMENT
ON COLUMN "sys_enterprise_info"."mail_address" IS '邮件地址';
COMMENT
ON COLUMN "sys_enterprise_info"."ep_address" IS '企业地址';
COMMENT
ON COLUMN "sys_enterprise_info"."ep_logo_url" IS '企业专属logoURL';
COMMENT
ON COLUMN "sys_enterprise_info"."ep_sys_name" IS '企业专属系统名称';
COMMENT
ON COLUMN "sys_enterprise_info"."remark" IS '备注';
COMMENT
ON COLUMN "sys_enterprise_info"."create_time" IS '创建时间';
COMMENT
ON COLUMN "sys_enterprise_info"."update_time" IS '修改时间';
COMMENT
ON TABLE "sys_enterprise_info" IS '企业信息表';

CREATE TABLE "sys_table_setting"
(
"id"           int8 NOT NULL,
"user_id"      varchar(36),
"setting_type" varchar(1),
"table_code"   varchar(255),
"json_detail"  text,
"create_time"  timestamp(6),
CONSTRAINT "sys_table_setting_pkey" PRIMARY KEY ("id")
);
COMMENT
ON COLUMN "sys_table_setting"."id" IS '主键';
COMMENT
ON COLUMN "sys_table_setting"."user_id" IS '用户id';
COMMENT
ON COLUMN "sys_table_setting"."setting_type" IS '设置类型|1筛选项2表单项';
COMMENT
ON COLUMN "sys_table_setting"."table_code" IS '表名';
COMMENT
ON COLUMN "sys_table_setting"."json_detail" IS 'json明细';
COMMENT
ON COLUMN "sys_table_setting"."create_time" IS '创建时间';
COMMENT
ON TABLE "sys_table_setting" IS '页面列表设置信息';

CREATE TABLE "sys_quick_my_collection"
(
"id"          int8 NOT NULL,
"user_id"     varchar(50),
"login_name"  varchar(30),
"true_name"   varchar(50),
"menu_id"     varchar(50),
"menu_name"   varchar(100),
"menu_route"  varchar(100),
"remark"      varchar(255),
"create_user" varchar(50),
"create_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"update_user" varchar(50),
"update_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "sys_quick_my_collection_pkey" PRIMARY KEY ("id")
);
COMMENT
ON COLUMN "sys_quick_my_collection"."id" IS '自增主键';
COMMENT
ON COLUMN "sys_quick_my_collection"."user_id" IS '权限平台用户ID';
COMMENT
ON COLUMN "sys_quick_my_collection"."login_name" IS '用户名(权限平台登录用户名)';
COMMENT
ON COLUMN "sys_quick_my_collection"."true_name" IS '真实姓名';
COMMENT
ON COLUMN "sys_quick_my_collection"."menu_id" IS '菜单编号';
COMMENT
ON COLUMN "sys_quick_my_collection"."menu_name" IS '菜单名称';
COMMENT
ON COLUMN "sys_quick_my_collection"."menu_route" IS '菜单路由地址';
COMMENT
ON COLUMN "sys_quick_my_collection"."remark" IS '备注(图标)';
COMMENT
ON COLUMN "sys_quick_my_collection"."create_user" IS '创建人';
COMMENT
ON COLUMN "sys_quick_my_collection"."create_time" IS '创建时间';
COMMENT
ON COLUMN "sys_quick_my_collection"."update_user" IS '修改人';
COMMENT
ON COLUMN "sys_quick_my_collection"."update_time" IS '修改时间';

CREATE TABLE "SYS_CACHE_HELP"
(
"ID"            NUMBER(20),
"QUERY_KEY"     VARCHAR2(100) DEFAULT NULL,
"STATUS"        VARCHAR2(2) DEFAULT NULL,
"SQL_COMMAND"   VARCHAR2(2000) DEFAULT NULL,
"BASE_COMMENT"  VARCHAR2(255) DEFAULT NULL,
"MEMO"          VARCHAR2(400) DEFAULT NULL,
"MEMO_DETAIL"   VARCHAR2(400) DEFAULT NULL,
"SYS"           VARCHAR2(30) DEFAULT NULL,
"LANGUAGE_TYPE" VARCHAR2(10) DEFAULT NULL,
"CREATE_TIME"   date DEFAULT CURRENT_TIMESTAMP,
"UPDATE_TIME"   date DEFAULT CURRENT_TIMESTAMP,
"CREATE_USER"   VARCHAR2(50) DEFAULT NULL,
"UPDATE_USER"   VARCHAR2(50) DEFAULT NULL,
"PL_VERSION"    VARCHAR2(100) DEFAULT NULL,
"DB_VERSION"    VARCHAR2(100) DEFAULT NULL,
PRIMARY KEY ("ID")
);
COMMENT
ON TABLE SYS_CACHE_HELP is '缓存参数维护';
COMMENT
ON COLUMN SYS_CACHE_HELP.ID is '自增主键';
COMMENT
ON COLUMN SYS_CACHE_HELP.QUERY_KEY is '查询key';
COMMENT
ON COLUMN SYS_CACHE_HELP.STATUS is '状态-----保留';
COMMENT
ON COLUMN SYS_CACHE_HELP.SQL_COMMAND is 'SQL';
COMMENT
ON COLUMN SYS_CACHE_HELP.BASE_COMMENT is '备注';
COMMENT
ON COLUMN SYS_CACHE_HELP.MEMO is '备注';
COMMENT
ON COLUMN SYS_CACHE_HELP.MEMO_DETAIL is '备注2';
COMMENT
ON COLUMN SYS_CACHE_HELP.SYS is '使用系统';
COMMENT
ON COLUMN SYS_CACHE_HELP.LANGUAGE_TYPE is '语言类型';
COMMENT
ON COLUMN SYS_CACHE_HELP.CREATE_TIME is '创建时间';
COMMENT
ON COLUMN SYS_CACHE_HELP.UPDATE_TIME is '修改时间';
COMMENT
ON COLUMN SYS_CACHE_HELP.CREATE_USER is '创建人';
COMMENT
ON COLUMN SYS_CACHE_HELP.UPDATE_USER is '修改人';
COMMENT
ON COLUMN SYS_CACHE_HELP.PL_VERSION is '当前缓存版本';
COMMENT
ON COLUMN SYS_CACHE_HELP.DB_VERSION is '当前DB库版本';


-- 创建表 ECI_NOTICE_INFO，邮件通知消息
CREATE TABLE ECI_NOTICE_INFO
(
ID          VARCHAR2(50) NOT NULL,
BIZ_ID      VARCHAR2(50),
TYPE_CODE   VARCHAR2(50),
STATUS      VARCHAR2(10),
SEND_DATE   DATE,
NOTICE_TO   VARCHAR2(1000),
CREATE_DATE DATE,
CREATE_USER VARCHAR2(50),
UPDATE_DATE DATE,
UPDATE_USER VARCHAR2(50),
BIZ_TYPE    VARCHAR2(50),
MESSAGE     TEXT,
STACK_TRACE TEXT,
FLOW_NO     VARCHAR2(50),
NOTICE_CC   VARCHAR2(100),
NOTICE_DATE DATE,
BIZ_NO      VARCHAR2(200),
CONSTRAINT PK_ECI_NOTICE_INFO PRIMARY KEY (ID)
);
-- 添加表注释
COMMENT
ON TABLE ECI_NOTICE_INFO is '邮件通知消息';
-- 添加列注释
COMMENT
ON COLUMN ECI_NOTICE_INFO.ID is '主键';
COMMENT
ON COLUMN ECI_NOTICE_INFO.BIZ_ID is '业务主键';
COMMENT
ON COLUMN ECI_NOTICE_INFO.TYPE_CODE is '类型';
COMMENT
ON COLUMN ECI_NOTICE_INFO.STATUS is '状态';
COMMENT
ON COLUMN ECI_NOTICE_INFO.SEND_DATE is '执行日期';
COMMENT
ON COLUMN ECI_NOTICE_INFO.NOTICE_TO is '收件人';
COMMENT
ON COLUMN ECI_NOTICE_INFO.CREATE_DATE is '创建日期';
COMMENT
ON COLUMN ECI_NOTICE_INFO.CREATE_USER is '创建用户';
COMMENT
ON COLUMN ECI_NOTICE_INFO.UPDATE_DATE is '更新日期';
COMMENT
ON COLUMN ECI_NOTICE_INFO.UPDATE_USER is '更新用户';
COMMENT
ON COLUMN ECI_NOTICE_INFO.BIZ_TYPE is '业务类型';
COMMENT
ON COLUMN ECI_NOTICE_INFO.MESSAGE is '异常描述';
COMMENT
ON COLUMN ECI_NOTICE_INFO.STACK_TRACE is '代码报错信息';
COMMENT
ON COLUMN ECI_NOTICE_INFO.FLOW_NO is '环节';
COMMENT
ON COLUMN ECI_NOTICE_INFO.NOTICE_CC is '抄送人';
COMMENT
ON COLUMN ECI_NOTICE_INFO.NOTICE_DATE is '计划发送日期';
COMMENT
ON COLUMN ECI_NOTICE_INFO.BIZ_NO is '业务单号';


-- 创建表 ECI_NOTICE_TYPE，邮件通知类型
CREATE TABLE ECI_NOTICE_TYPE
(
ID          VARCHAR2(50) NOT NULL, -- 主键
CODE        VARCHAR2(50),          -- 编码
NAME        VARCHAR2(200),         -- 名称
SUBJECT     VARCHAR2(200),         -- 主题
BODY        TEXT,                  -- 内容
SQL_NAME    VARCHAR2(500),         -- SQL语句
CREATE_DATE DATE,                  -- 创建日期
CREATE_USER VARCHAR2(50),          -- 创建用户
UPDATE_DATE DATE,                  -- 更新日期
UPDATE_USER VARCHAR2(50),          -- 更新用户
IS_DELETE   VARCHAR2(10),          -- 是否删除
STATUS      CHAR(1),               -- 状态
FLOW_NO     VARCHAR2(50),          -- 环节
UNIQUE_CODE VARCHAR2(50),          -- 唯一代码
ONE_EXCEL   CHAR(1),               -- 导出到一个EXCEL
EXCEL_NAME  VARCHAR2(200),         -- 导出EXCEL名称
FILE_API    VARCHAR2(200),         -- 下载文件API
ON_EXCEL    CHAR(1),               -- 在一个EXCEL中
CONSTRAINT PK_ECI_NOTICE_TYPE PRIMARY KEY (ID)
);
-- 添加表注释
COMMENT
ON TABLE ECI_NOTICE_TYPE IS '邮件通知类型';
-- 添加列注释
COMMENT
ON COLUMN ECI_NOTICE_TYPE.ID IS '主键';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.CODE IS '编码';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.NAME IS '名称';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.SUBJECT IS '主题';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.BODY IS '内容';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.SQL_NAME IS 'SQL语句';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.CREATE_DATE IS '创建日期';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.CREATE_USER IS '创建用户';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.UPDATE_DATE IS '更新日期';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.UPDATE_USER IS '更新用户';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.IS_DELETE IS '是否删除';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.STATUS IS '状态';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.FLOW_NO IS '环节';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.UNIQUE_CODE IS '唯一代码';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.ONE_EXCEL IS '导出到一个EXCEL';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.EXCEL_NAME IS '导出EXCEL名称';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.FILE_API IS '下载文件API';
COMMENT
ON COLUMN ECI_NOTICE_TYPE.ON_EXCEL IS '在一个EXCEL中';


-- 创建表 ECI_NOTICE_TYPE_ATTACH，邮件通知附件信息
CREATE TABLE ECI_NOTICE_TYPE_ATTACH
(
ID                    VARCHAR2(50) NOT NULL, -- 主键
HEAD_ID               VARCHAR2(50),          -- 头表数据ID
SQL_NAME              VARCHAR2(500),         -- SQL语句
NAME                  VARCHAR2(100),         -- 名称
CREATE_DATE           DATE,                  -- 创建日期
CREATE_USER           VARCHAR2(100),         -- 创建用户
UPDATE_DATE           DATE,                  -- 更新日期
UPDATE_USER           VARCHAR2(100),         -- 更新用户
IS_DELETE             VARCHAR2(10),          -- 是否删除
USE_TEMPLATE_FILE     CHAR(1),               -- 使用模板
TEMPLATE_FILE         VARCHAR2(255),         -- 模板文件名称
STATUS                VARCHAR2(1),           -- 状态
TEMPLATE_FILE_CONTENT TEXT,                  -- 模板文件内容
START_ROW             VARCHAR2(11),          -- 起始行
HEAD_SQL              VARCHAR2(500),         -- 头查询SQL语句
PIC_MIN_ROW           VARCHAR2(100),         -- 图片开始行位置
PIC_MAX_ROW           VARCHAR2(100),         -- 图片结束行位置
PIC_MIN_COL           VARCHAR2(100),         -- 图片开始列位置
PIC_MAX_COL           VARCHAR2(100),         -- 图片结束列位置
TEMPLATE_PIC_CONTENT  TEXT,                  -- 图片文件内容
TEMPLATE_PIC          VARCHAR2(100),         -- 模板图片名称
CONSTRAINT PK_ECI_NOTICE_TYPE_ATTACH PRIMARY KEY (ID)
);
-- 添加表注释
COMMENT
ON TABLE ECI_NOTICE_TYPE_ATTACH IS '邮件通知附件信息';
-- 添加列注释
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.ID IS '主键';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.HEAD_ID IS '头表数据ID';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.SQL_NAME IS 'SQL语句';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.NAME IS '名称';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.CREATE_DATE IS '创建日期';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.CREATE_USER IS '创建用户';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.UPDATE_DATE IS '更新日期';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.UPDATE_USER IS '更新用户';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.IS_DELETE IS '是否删除';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.USE_TEMPLATE_FILE IS '使用模板';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.TEMPLATE_FILE IS '模板文件名称';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.STATUS IS '状态';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.TEMPLATE_FILE_CONTENT IS '模板文件内容';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.START_ROW IS '起始行';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.HEAD_SQL IS '头查询SQL语句';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.PIC_MIN_ROW IS '图片开始行位置';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.PIC_MAX_ROW IS '图片结束行位置';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.PIC_MIN_COL IS '图片开始列位置';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.PIC_MAX_COL IS '图片结束列位置';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.TEMPLATE_PIC_CONTENT IS '图片文件内容';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_ATTACH.TEMPLATE_PIC IS '模板图片名称';

-- 创建表 ECI_NOTICE_TYPE_REF，邮件通知引用信息
CREATE TABLE ECI_NOTICE_TYPE_REF
(
ID             VARCHAR2(36) NOT NULL, -- 主键
HEAD_ID        VARCHAR2(36),          -- 头表数据
CODE           VARCHAR2(20),          -- 代码
NAME           VARCHAR2(100),         -- 名称
SQL_NAME       VARCHAR2(100),         -- SQL语句
BODY           TEXT,                  -- 内容
CREATE_DATE    DATE,                  -- 创建日期
CREATE_USER    VARCHAR2(100),         -- 创建用户
UPDATE_DATE    DATE,                  -- 修改日期
UPDATE_USER    VARCHAR2(100),         -- 修改用户
STATUS         VARCHAR2(1),           -- 状态
DETAIL_DATA    VARCHAR2(1),           -- 明细数据
DATA_ROW_INDEX NUMBER(11),            -- 数据开始行
CONSTRAINT PK_ECI_NOTICE_TYPE_REF PRIMARY KEY (ID)
);
-- 添加表注释
COMMENT
ON TABLE ECI_NOTICE_TYPE_REF IS '邮件通知引用信息';
-- 添加列注释
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.ID IS '主键';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.HEAD_ID IS '头表数据';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.CODE IS '代码';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.NAME IS '名称';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.SQL_NAME IS 'SQL语句';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.BODY IS '内容';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.CREATE_DATE IS '创建日期';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.CREATE_USER IS '创建用户';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.UPDATE_DATE IS '修改日期';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.UPDATE_USER IS '修改用户';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.STATUS IS '状态';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.DETAIL_DATA IS '明细数据';
COMMENT
ON COLUMN ECI_NOTICE_TYPE_REF.DATA_ROW_INDEX IS '数据开始行';

CREATE TABLE SYS_TASK_INFO
(
ID                int8,
TASK_NAME         varchar(255),
TASK_NO           varchar(50),
TASK_TYPE         varchar(50),
TASK_STATUS       varchar(1),
LINK_URL          varchar(255),
TASK_PROCESS      int,
TASK_PROCESS_DESC varchar(255),
CREATE_USER       varchar(36),
CREATE_TIME       timestamp,
UPDATE_TIME       timestamp,
REMARK            text,
CONSTRAINT "SYS_TASK_INFO_pkey" 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) NOT NULL,
CODE        varchar(100)  DEFAULT NULL,
NAME        varchar(50)   DEFAULT NULL,
CONFIG      varchar(1000) DEFAULT NULL,
STATUS      char(1)       DEFAULT NULL,
CREATE_DATE datetime      DEFAULT NULL,
CREATE_USER varchar(50)   DEFAULT NULL,
IS_DELETE   char(1)       DEFAULT NULL,
SAVE_DB     varchar(1)    DEFAULT NULL,
CATALOG     varchar(100)  DEFAULT NULL,
MEMO        varchar(200)  DEFAULT NULL,
FILE_TYPE   varchar(200)  DEFAULT NULL,
MAX_NUM     int           DEFAULT NULL,
MAX_SIZE    int           DEFAULT NULL,
PRIMARY KEY (GUID)
);


-- ECI_TG.ECI_FILE_CONTENT definition
DROP TABLE IF EXISTS ECI_FILE_CONTENT;

CREATE TABLE ECI_FILE_CONTENT
(
GUID         varchar(36) NOT NULL,
FILE_ID      varchar(36) NOT NULL,
DATA_CONTENT text,
CREATE_DATE  datetime    DEFAULT NULL,
CREATE_USER  varchar(50) DEFAULT NULL,
UPDATE_DATE  datetime    DEFAULT NULL,
UPDATE_USER  varchar(50) DEFAULT NULL,
PRIMARY KEY (GUID)
);


-- ECI_TG.ECI_FILE_INFO definition
DROP TABLE IF EXISTS ECI_FILE_INFO;

CREATE TABLE ECI_FILE_INFO
(
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(255) DEFAULT NULL,
FILE_NAME_ORI varchar(255) DEFAULT NULL,
PATH          varchar(500) DEFAULT NULL,
CREATE_DATE   datetime     DEFAULT NULL,
CREATE_USER   varchar(50)  DEFAULT NULL,
SEQ           int          DEFAULT NULL,
SAVE_DB       varchar(1)   DEFAULT NULL,
DATA_CONTENT  text,
STATUS        varchar(1)   DEFAULT NULL,
CATALOG       varchar(20)  DEFAULT NULL,
EXTENSION     varchar(20)  DEFAULT NULL,
FILE_LENGTH   int          DEFAULT NULL,
P_NO          varchar(100) DEFAULT NULL,
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) NOT NULL,
CODE          varchar(20)  DEFAULT NULL,
NAME          varchar(100) DEFAULT NULL,
STATUS        varchar(1)   DEFAULT NULL,
SEQ           int          DEFAULT NULL,
MEMO          varchar(500) DEFAULT NULL,
CREATE_DATE   datetime     DEFAULT NULL,
CREATE_USER   varchar(36)  DEFAULT NULL,
UPDATE_DATE   datetime     DEFAULT NULL,
UPDATE_USER   varchar(36)  DEFAULT NULL,
ASSEMBLY_NAME varchar(500) DEFAULT NULL,
VIEW_URL      varchar(500) DEFAULT NULL,
ACTION1_NAME  varchar(50)  DEFAULT NULL,
ACTION2_NAME  varchar(50)  DEFAULT NULL,
ACTION3_NAME  varchar(50)  DEFAULT NULL,
SUB_URL       varchar(500) DEFAULT NULL,
CATELOG       varchar(50)  DEFAULT NULL,
PRINT_URL     varchar(255) DEFAULT NULL,
APPLY_CATELOG varchar(50)  DEFAULT NULL,
BIZ_ID        varchar(50)  DEFAULT NULL,
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) NOT NULL,
BIZ_TYPE   varchar(36)  DEFAULT NULL,
ATTR_NAME  varchar(100) DEFAULT NULL,
ATTR_CODE  varchar(20)  DEFAULT NULL,
SAVE_FIELD varchar(50)  DEFAULT NULL,
UI_TYPE    varchar(20)  DEFAULT NULL,
UI_CONFIG  varchar(50)  DEFAULT NULL,
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) NOT NULL,
COMPANY_CODE varchar(20)  DEFAULT NULL,
COMPANY_NAME varchar(100) DEFAULT NULL,
BIZ_TYPE     varchar(36)  DEFAULT NULL,
AUDIT_LEVEL  varchar(10)  DEFAULT NULL,
CREATE_DATE  datetime     DEFAULT NULL,
CREATE_USER  varchar(50)  DEFAULT NULL,
UPDATE_DATE  datetime     DEFAULT NULL,
UPDATE_USER  varchar(50)  DEFAULT NULL,
ATTR_MEMO    varchar(500) DEFAULT NULL,
TIP_APPLY_HG varchar(1)   DEFAULT 'N',
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) NOT NULL,
HEAD_ID         varchar(36)  DEFAULT NULL,
ATTR_CODE       varchar(20)  DEFAULT NULL,
ATTR_VALUE      varchar(100) DEFAULT NULL,
ATTR_VALUE_NAME varchar(100) DEFAULT NULL,
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) NOT NULL,
COMPANY_CODE varchar(20)  DEFAULT NULL,
COMPANY_NAME varchar(100) DEFAULT NULL,
BIZ_TYPE     varchar(36)  DEFAULT NULL,
STATUS       varchar(1)   DEFAULT NULL,
VIEW_URL     varchar(500) DEFAULT NULL,
CREATE_DATE  datetime     DEFAULT NULL,
CREATE_USER  varchar(50)  DEFAULT NULL,
UPDATE_DATE  datetime     DEFAULT NULL,
UPDATE_USER  varchar(50)  DEFAULT NULL,
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) NOT NULL,
BIZ_NO         varchar(200) DEFAULT NULL,
BIZ_TYPE       varchar(80)  DEFAULT NULL,
SUMMARY        varchar(800) DEFAULT NULL,
APPLY_DATE     datetime     DEFAULT NULL,
APPLY_USER     varchar(200) DEFAULT NULL,
CREATE_DATE    datetime     DEFAULT NULL,
CREATE_USER    varchar(200) DEFAULT NULL,
CREATE_USER_ID varchar(200) DEFAULT NULL,
STATUS         varchar(80)  DEFAULT NULL,
COMPANY_CODE   varchar(200) DEFAULT NULL,
COMPANY_NAME   varchar(800) DEFAULT NULL,
DCL_CODE       varchar(200) DEFAULT NULL,
DCL_NAME       varchar(800) DEFAULT NULL,
QW_CODE        varchar(200) DEFAULT NULL,
QW_NAME        varchar(800) DEFAULT NULL,
UDF1           varchar(200) DEFAULT NULL,
UDF2           varchar(200) DEFAULT NULL,
UDF3           varchar(200) DEFAULT NULL,
UDF4           varchar(200) DEFAULT NULL,
UDF5           varchar(200) DEFAULT NULL,
INPUT_USER     varchar(200) DEFAULT NULL,
INPUT_DATE     datetime     DEFAULT NULL,
UPDATE_DATE    datetime     DEFAULT NULL,
UPDATE_USER    varchar(200) DEFAULT NULL,
AUDIT_USER     varchar(200) DEFAULT NULL,
AUDIT_DATE     datetime     DEFAULT NULL,
STATUS_NAME    varchar(50)  DEFAULT NULL,
BIZ_ID         varchar(50)  DEFAULT NULL,
SUB_NO         varchar(50)  DEFAULT NULL,
TAG            varchar(200) DEFAULT NULL,
CUSTOMER_NO    varchar(100) DEFAULT NULL,
SUB_URL        varchar(500) DEFAULT NULL,
TRADE_CODE     varchar(50)  DEFAULT NULL,
TRADE_NAME     varchar(200) DEFAULT NULL,
TH_REASON      varchar(200) DEFAULT NULL,
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)  DEFAULT NULL,
BIZ_NO     varchar(200)  DEFAULT NULL,
BIZ_TYPE   varchar(200)  DEFAULT NULL,
OPER_USER  varchar(200)  DEFAULT NULL,
OPER_DATE  datetime      DEFAULT NULL,
AUDIT_MEMO varchar(4000) DEFAULT NULL,
OPER_NAME  varchar(200)  DEFAULT NULL,
OPER_CODE  varchar(20)   DEFAULT NULL,
PRIMARY KEY (ID)
);


-- ECI_TG.TG_JOB definition
DROP TABLE IF EXISTS TG_JOB;

CREATE TABLE TG_JOB
(
ID              bigint      NOT NULL AUTO_INCREMENT,
NAME            varchar(32) NOT NULL,
STATUS          varchar(10) NOT NULL,
HANDLER_NAME    varchar(64) NOT NULL,
HANDLER_PARAM   varchar(255)         DEFAULT NULL,
CRON_EXPRESSION varchar(32) NOT NULL,
RETRY_COUNT     int         NOT NULL DEFAULT '0',
RETRY_INTERVAL  int         NOT NULL DEFAULT '0',
MONITOR_TIMEOUT int         NOT NULL DEFAULT '0',
CREATOR         varchar(64)          DEFAULT '',
CREATE_TIME     datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP,
UPDATER         varchar(64)          DEFAULT '',
UPDATE_TIME     datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP,
DELETED         int         NOT NULL DEFAULT '0',
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,
JOB_ID        bigint      NOT NULL,
HANDLER_NAME  varchar(64) NOT NULL,
HANDLER_PARAM varchar(255)         DEFAULT NULL,
EXECUTE_INDEX bigint      NOT NULL DEFAULT '1',
BEGIN_TIME    datetime    NOT NULL,
END_TIME      datetime             DEFAULT NULL,
DURATION      int                  DEFAULT NULL,
STATUS        varchar(10) NOT NULL,
RESULT        varchar(4000)        DEFAULT '',
CREATOR       varchar(64)          DEFAULT '',
CREATE_TIME   datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP,
UPDATER       varchar(64)          DEFAULT '',
UPDATE_TIME   datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP,
DELETED       int         NOT NULL DEFAULT '0',
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)
);