# LA 版本升级到 LA2 版本
⚠️文档中以MySQL数据安装为示例进行安装。
⚠️LA2 版本使用的AFCenter版本为8.2.2.2,对应的EOS Platform版本为8.2.2.2。
本文介绍从数据质量 7.1 LA 版本升级到 7.1 LA2 版本的升级过程。
# 介质准备
下载数据质量 7.1 LA2 介质,解压到安装服务器上。
微应用版本
微应用版本介质目录如下:
## 先解压Primeton_QualityCube_7.1_LA2_MicroApp.tar.gz
## 再解压Primeton_QualityCube_7.1_LA2_Server.tar.gz 、Primeton_QualityCube_7.1_LA2_Scheduler.tar.gz 、Primeton_QualityCube_7.1_LA2_Executor.tar.gz和Primeton_QualityCube_7.1_LA2_UI.tar.gz。
## Primeton_QualityCube_7.1_LA2_Server.tar.gz
├── bin
│ ├── shutdown.cmd
│ ├── shutdown.sh
│ ├── startup.cmd
│ └── startup.sh
├── config
│ ├── QUALITY
│ ├── application-afc.properties
│ ├── application-dqms.properties
│ ├── application.properties
│ ├── application-nacos.properties
│ ├── application-eureka.properties
│ ├── bootstrap.properties
│ └── logback-spring.xml
├── db-scripts
│ ├── DaMeng
│ ├── Mysql
│ ├── GaussDB
│ ├── Oracle
│ └── upgrade ## 7.1la-7.1la2升级脚本目录
├── lib ## 数据库驱动目录,mysql、oracle驱动需要自行下载
│ ├── DmJdbcDriver18-8.1.1.193.jar
│ ├── hive-jdbc-2.1.1.jar
│ └── opengauss-jdbc-3.0.0.jar
└── dqms-boot-7.1.0-exec.jar
## Primeton_QualityCube_7.1_LA2_Scheduler
├── config
│ ├── application.properties
│ ├── logback.xml
├── lib
│ ├── .gitkeep
├── README.md
├── startJob.bat
├── startJob.sh
├── stopJob.bat
├── stopJob.sh
└── xxl-job-admin-2.2.0-exec.jar
## Primeton_QualityCube_7.1_LA2_Executor
├── bin
│ ├── shutdown.cmd
│ ├── shutdown.sh
│ ├── startup.cmd
│ └── startup.sh
├── config
│ ├── legal-validator-tpl
│ ├── mapper
│ ├── spark
│ ├── templates
│ ├── account.properties
│ ├── application.properties
│ ├── banner.txt
│ ├── core-site.xml
│ ├── hdfs-site.xml
│ └── logback.xml
├── spark
│ └── hiveseq_check
├── lib ## 数据库驱动目录,mysql驱动需要自行下载
│ └── mysql-connector-java-8.0.19.jar
├── README.md
└── quality-executor-7.1.0-exec.jar
## Primeton_QualityCube_7.1_LA2_UI
├── dist
│ ├── assets
│ ├── static
│ ├── index.html
│ └── remoteEntry.js
└── quality.conf
独立部署版本
独立部署版本介质目录如下:
## 解压Primeton_QualityCube_7.1_LA_Standalone.tar.gz
├── standalone
│ ├── clearLog.cmd
│ ├── clearLog.sh
│ ├── readme.txt
│ ├── shutdown.cmd
│ ├── shutdown.sh
│ ├── startup.cmd
│ └── startup.sh
├── server
│ ├── primetonlicense.xml
│ ├── executor
│ │ ├── bin
│ │ │ ├── shutdown.cmd
│ │ │ ├── shutdown.sh
│ │ │ ├── startup.cmd
│ │ │ └── startup.sh
│ │ ├── config
│ │ │ ├── legal-validator-tpl
│ │ │ ├── mapper
│ │ │ ├── spark
│ │ │ ├── templates
│ │ │ ├── account.properties
│ │ │ ├── application.properties
│ │ │ ├── banner.txt
│ │ │ ├── core-site.xml
│ │ │ ├── hdfs-site.xml
│ │ │ └── logback.xml
│ │ ├── spark
│ │ │ └── hiveseq_check
│ │ ├── lib ## 数据库驱动目录,mysql驱动需要自行下载
│ │ │ └── mysql-connector-java-8.0.19.jar
│ │ ├── README.md
│ │ └── quality-executor-7.1.0-exec.jar
│ ├── scheduler
│ │ ├── config
│ │ │ ├── application.properties
│ │ │ ├── logback.xml
│ │ ├── lib
│ │ │ ├── .gitkeep
│ │ ├── README.md
│ │ ├── startJob.bat
│ │ ├── startJob.sh
│ │ ├── stopJob.bat
│ │ ├── stopJob.sh
│ │ └── xxl-job-admin-2.2.0-exec.jar
│ └── quality
│ ├── afc-embed-boot-7.1.0-exec.jar
│ ├── config
│ │ ├── QUALITY
│ │ ├── application-afc.properties
│ │ ├── application-dqms.properties
│ │ ├── application.properties
│ │ ├── application-eureka.properties
│ │ ├── application-nacos.properties
│ │ ├── bootstrap.properties
│ │ └── logback-spring.xml
│ ├── lib ## 数据库驱动目录,mysql、oracle驱动需要自行下载
│ │ ├── DmJdbcDriver18-8.1.1.193
│ │ ├── hive-jdbc-2.1.1.jar
│ │ └── opengauss-jdbc-3.0.0.jar
│ ├── bin
│ │ ├── shutdown.cmd
│ │ ├── shutdown.sh
│ │ ├── startup.cmd
│ │ └── startup.sh
│ └── db-scripts
│ ├── afcenter
│ ├── eos
│ ├── bfp
│ ├── full
│ ├── locode
│ └── dqms
│ ├── DaMeng
│ ├── Mysql
│ ├── GaussDB
│ ├── Oracle
│ └── upgrade ## 7.1la-7.1la2升级脚本目录
└── web
├── afcenter
│ ├── assets
│ ├── bfp
│ ├── components
│ ├── components-ext
│ ├── config
│ ├── formDesigner
│ ├── ide
│ ├── quality ## 数据质量前端资源文件
│ ├── static
│ ├── remoteEntry.js
│ ├── remoteEntry.js.gz
│ ├── version.properties
│ └── index.html
└── conf
└── quality.conf
# 执行升级脚本
⚠️升级前请先备份数据。
升级脚本从db-scripts/*/upgrade
目录中获取,文件列表如下:
├── DaMeng
├── Mysql
├── GaussDB
└── Oracle
微应用版本
使用微应用版本部署时,AFCenter、数据质量后端服务是独立进程,因此都是独立的数据库,需要分别执行升级脚本。
升级AFCenter数据库
mysql> source 00-quaity-afc-data.sql
升级数据质量后端服务数据库(默认quaity_pub)
mysql> source 10-quaity-ddl.sql
mysql> source 11-quaity-data.sql
mysql> source 12-quality-function.sql
独立部署版本
独立部署版本部署时,AFCenter、数据质量后端服务为同一数据库,直接执行升级脚本即可。
mysql> source 00-quaity-afc-data.sql
mysql> source 01-afc-template-data.sql
mysql> source 10-quaity-ddl.sql
mysql> source 11-quaity-data.sql
mysql> source 12-quality-function.sql
# 替换新版本介质
⚠️升级前请先替换文件。
更新数据质量后端服务
使用解压后的后端介质文件,替换原有文件。
对于微应用版本,使用Primeton_QualityCube_7.1_LA2_Server.tar.gz解压后进行替换。对于独立部署版本,可以使用server/quality目录替换原有文件。
更新调度器服务
对于微应用版本,使用Primeton_QualityCube_7.1_LA2_Scheduler.tar.gz解压后进行替换。对于独立部署版本,可以使用server/scheduler目录替换原有文件。
更新执行器服务
对于微应用版本,使用Primeton_QualityCube_7.1_LA2_Executor.tar.gz解压后进行替换。对于独立部署版本,可以使用server/executor目录替换原有文件。
更新数据质量前端资源
对于微应用版本,使用Primeton_QualityCube_7.1_LA2_UI.tar.gz解压后的dist目录进行替换。对于独立部署版本,使用web/afcenter/quality目录进行替换原有文件。更新后,无需修改nginx配置。
# 验证
验证后端服务
访问数据质量平台在线文档地址http://<ip>:<port>/swagger-ui.html
,确认后端服务是否正常。
验证调度器服务
访问调度器xxl-job地址http://<ip>:<port>/job-admin
,确认调度器服务是否正常。
验证执行器服务
查看调度器下的执行器是否存在,确认执行器服务是否正常。
验证前端服务
访问AFCenter,登录后切换到数据质量,检查菜单、数据是否正常展示。
# 附录
# 新增配置说明
后端配置说明
quality\config\application-dqms.properties配置文件说明
afc.system-variable.mdm-resGroupId=quality-11
afc.system-variable.afc-resGroupId=quality-12
check.result.save-mode=local
#check.result.host=10.15.15.136
#check.result.port=22
#check.result.username=test
#check.result.password=test
check.result.local-temp-dir=${common.base_dir}/dataCheck
check.result.upload-root-dir=${common.base_dir}/dataCheck
#
datasource.config.save-mode=local
#datasource.config.host=
#datasource.config.port=
#datasource.config.username=
#datasource.config.password=
#datasource.config.reply=
datasource.config.kerberos-path=${common.base_dir}/kerberos/
executor\config\application.properties配置文件说明
#告警邮件服务器配置
spring.mail.host=smtp.exmail.qq.com
spring.mail.protocol=smtp
spring.mail.username=lizw@primeton.com
spring.mail.password=i7cBHaDFzeWex539
#true means null-value-check will check blank values
datacheck.check-rules.null-value-check.include-blank-value=true
nginx配置修改
worker_processes 1;
events {
worker_connections 1024;
}
http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;
#监听afc后端端口,若以独立模式启动,该端口号与quality端口号相同
upstream afcenterapp {
server 127.0.0.1:28083;
}
#监听quality后端端口
upstream qualityapp {
server 127.0.0.1:28091;
}
server {
#基座地址组成
listen 80;
client_max_body_size 20M;
add_header X-Content-Type-Options nosniff;
add_header X-XSS-Protection "1";
add_header X-Frame-Options "SAMEORIGIN";
add_header X-Permitted-Cross-Domain-Policies "master-only";
add_header X-Download-Options noopen;
add_header Content-Security-Policy "script-src * 'unsafe-inline' 'unsafe-eval'";
add_header Strict-Transport-Security "max-age=SECONDS";
add_header Referrer-Policy "no-referrer" always;
location ~/QUALITY/ {
rewrite ^/(.*)/api/(.*)$ /api/$2 break;
#proxy_set_header X-EOS-SourceSysKey 359e22bf398043cb866a92dc1cbbd3f6;
proxy_pass http://qualityapp;
}
location ^~/api/ {
#proxy_set_header X-EOS-SourceSysKey 359e22bf398043cb866a92dc1cbbd3f6;
proxy_pass http://afcenterapp ;
}
location ~/(.*)/api/ {
rewrite ^/(.*)/api/(.*)$ /api/$2 break;
#proxy_set_header X-EOS-SourceSysKey 359e22bf398043cb866a92dc1cbbd3f6;
proxy_pass http://afcenterapp ;
}
#location ~ \.biz\.ext$ {
# proxy_pass http://afcenterapp;
#
}
location / {
root /介质解压到的目录;
index index.html index.htm;
try_files $uri /index.html;
}
升级脚本
升级脚本从db-scripts/upgrade
目录中获取
00-quaity-afc-data.sql升级脚本说明(mysql、oracle、dm、opengauss相同)
update afc_application set CODE='QUALITY' where ID='dqms-66';
DELETE FROM afc_res_group WHERE ID = 'quality-11';
DELETE FROM afc_res_group WHERE ID = 'quality-12';
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED)VALUES ('quality-11', '主数据平台变量', 'mdm_platform_vars', 'platform', 'systemVariable', null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, null, null, 1, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED)VALUES ('quality-12', 'AFC变量', 'afc_platform_vars', 'platform', 'systemVariable', null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, null, null, 1, null);
DELETE FROM afc_system_variable WHERE RES_GROUP_ID = 'quality-11';
DELETE FROM afc_system_variable WHERE RES_GROUP_ID = 'quality-12';
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES ('quality-11', 'mdm.server.url', 'mdm_server_url', 'http://10.15.15.130:29898', 'quality-11', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-12', 'mdm.server.token', 'mdm_server_token', '501143620fac471bb1ec2840e09f091d', 'quality-11', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-13', 'mdm.frequency.name', 'mdm_frequency_name', 'mdm_frequency', 'quality-11', '0', null, null, null, null, 'sys_tenant','2022-12-30 12:00:00' , null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-14', 'mdm.index.id', 'mdm_index_id', '775617973328220160', 'quality-11', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-15', 'mdm.datasource.id', 'mdm_datasource_id', '775620198016421888', 'quality-11', '0', null, null, null, null, 'sys_tenant','2022-12-30 12:00:00' , null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-16', 'mdm.output.datasource.id', 'mdm_output_datasource_id', '775874119687409664', 'quality-11', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-17', 'mdm.output.datasource.databaseName', 'mdm_output_datasource_databaseName', 'dqms_result_store', 'quality-11', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-18', 'afc.server.url', 'afc_server_url', 'http://10.15.15.136:28085', 'quality-12', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-19', 'afc.server.token', 'afc_server_token', 'fe98f2cbf76444169ef209d2f59a9967', 'quality-12', '0', null, null, null, null, 'sys_tenant', '2022-12-30 12:00:00', null, 'platform', null);
-- afc_res_group
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-457', '安全审计', 'securityAudit', null, null, null, 'dqms-66', null, 'sys_tenant', '2022-12-20 14:05:49', null, 'admin', null, 9, null);
-- afc_resource
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-221', '操作日志', 'logger', 'url', 'dqms-66', 'dqms-457', null, null, null, '{"openType":"microApp","mark":"securityAudit/logger","url":null,"params":null,"microUrl":null,"microMark":"quality","isLowOrHigh":"high","resourceCode":null,"formStatus":null,"resourceType":null,"viewType":null,"appCode":"quality","query":null,"processDefName":null,"biId":null,"biType":null,"bicode":null}', 'sys_tenant', '2022-12-20 14:09:21','2022-12-20 14:15:46', 'admin','admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-222', '质量评分', 'checkDataScore', 'url', 'dqms-66', 'dqms-455', null, null, null, '{"openType":"microApp","mark":"dqAnalysis/checkDataScore","url":null,"params":null,"microUrl":null,"microMark":"quality","isLowOrHigh":"high","resourceCode":null,"formStatus":null,"resourceType":null,"viewType":null,"appCode":"quality","query":null,"processDefName":null,"biId":null,"biType":null,"bicode":null}', 'sys_tenant', '2022-12-28 15:40:38', '2022-12-28 16:54:59', 'admin', 'admin', null);
-- afc_menu
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-43', '操作日志', 'logger', 'dqms-221', null, 3, '1', null, null, 'dqms-81', 'sys_tenant', '2022-12-20 14:18:06', null, 'admin', null, null, null, 'jiandu', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-44', '质量评分', 'checkDataScore', 'dqms-222', null, 4, '1', null, null, 'dqms-369', 'sys_tenant', '2022-12-28 15:47:43', null, 'admin', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-81', '安全审计', 'securityAudit', null, null, 10, '0', null, null, 'dqms-442', 'sys_tenant', '2023-01-12 17:27:26', null, 'admin', null, null, null, 'jiandu', null, null, null);
-- afc_r_res_role
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-424', 'dqms-221', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-423', 'dqms-222', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
##新增afc资源角色
10-quality-ddl.sql升级脚本说明(mysql、oracle、dm、opengauss相同)
drop table if exists DQMS_OPERATION_LOG;
create table DQMS_OPERATION_LOG
(
ID varchar(64) not null comment '操作日志ID',
OPERATOR_ID varchar(64) comment '操作者ID',
OPERATOR_NAME varchar(64) comment '操作者名称',
OPERATE_TYPE int comment '操作类型',
OPERATE_DATE datetime comment '时间',
TARGET_TYPE varchar(64) comment '目标类型',
TARGET_MODEL_ID varchar(64) comment '目标ID',
TARGET_MODEL_NAME varchar(64) comment '目标名称',
MESSAGE text comment '信息',
TENANT_ID varchar(64) comment '租户ID',
primary key (ID)
);
alter table DQMS_OPERATION_LOG comment '操作日志';
alter table DQMS_OPERATION_LOG add index DQMS_OPERATION_LOG_INDEX_OPERATOR(OPERATOR_NAME);
alter table DQMS_OPERATION_LOG add index DQMS_OPERATION_LOG_INDEX_OPERATE_TYPE(OPERATE_TYPE);
alter table DQMS_OPERATION_LOG add index DQMS_OPERATION_LOG_INDEX_TARGET(TARGET_TYPE, TARGET_MODEL_ID, TARGET_MODEL_NAME);
drop table if exists DQMS_OPERATION_LOG_DETAIL;
create table DQMS_OPERATION_LOG_DETAIL
(
ID varchar(64) not null comment '日志详情ID',
OLD_DATA_JSON text comment '旧值',
NEW_DATA_JSON text comment '新值',
primary key (ID)
);
alter table DQMS_OPERATION_LOG_DETAIL comment '操作日志详情';
-----------------------------
-- 组织机构评分
-----------------------------
DROP TABLE IF EXISTS DQMS_RATING_RESULT;
CREATE TABLE DQMS_RATING_RESULT(
ID BIGINT PRIMARY KEY AUTO_INCREMENT,
ORG_ID BIGINT COMMENT '组织ID',
ORG_NAME VARCHAR(50) COMMENT '组织名',
ORG_LEVEL VARCHAR(2) COMMENT '组织等级',
PARENT_ORG_ID BIGINT COMMENT '父组织ID',
SCORE DOUBLE COMMENT '得分',
START_DATE DATETIME COMMENT'评估开始日期',
END_DATE DATETIME COMMENT'评估截至日期',
RATING_CYCLE VARCHAR(50) COMMENT '评分周期 年(year)、季度(quarter)、月(month)、周(week),默认月',
RATING_POINT VARCHAR(50) COMMENT'评分点 例如:2023-01',
CREATE_TIME DATETIME,
CREATE_USER VARCHAR(25),
LAST_MODIFIER_TIME DATETIME,
LAST_MODIFIER_USER VARCHAR(25)
);
-- CK_METHOD_CONFIG 新增字段
ALTER TABLE CK_METHOD_CONFIG ADD COLUMN SINK_MODE VARCHAR(64);
ALTER TABLE CK_METHOD_CONFIG ADD COLUMN DATA_FROM VARCHAR(64);
alter table ck_check_result add CHECK_RESULT TEXT comment '检核结果上传路径';
← 配置说明 7.1 LA2升级到7.1 GA →