元数据六张表

DROP DATABASE IF exists datacenter_metadata_platform;
CREATE DATABASE datacenter_metadata_platform DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

USE datacenter_metadata_platform;
DROP TABLE IF EXISTS t_user_search_history;
CREATE TABLE t_user_search_history
(
id varchar(100) NOT NULL COMMENT ‘主键id’,
user varchar(100) NOT NULL COMMENT ‘用户’,
content text NOT NULL COMMENT ‘搜索内容’,
type varchar(100) DEFAULT NULL COMMENT ‘搜索类型’,
is_deleted boolean DEFAULT NULL COMMENT ‘是否删除’,
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘记录每次修改的时间’,
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘记录创建的时间’,
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_bin COMMENT =‘元数据平台用户搜索历史记录表’;
DROP TABLE IF EXISTS t_table_info;
CREATE TABLE t_table_info
(
id varchar(100) NOT NULL COMMENT ‘主键id’,
database_name varchar(100) NOT NULL COMMENT ‘数据库名称’,
table_name varchar(100) NOT NULL COMMENT ‘表名称’,
table_comment varchar(10) NOT NULL COMMENT ‘表中文名’,
table_desc varchar(100) NOT NULL COMMENT ‘表描述’,
table_topic varchar(100) NOT NULL COMMENT ‘表主题’,
table_status varchar(100) NOT NULL COMMENT ‘表状态’,
table_security varchar(100) NOT NULL COMMENT ‘表安全等级’,
partition_column varchar(100) NOT NULL COMMENT ‘分区字段’,
table_path varchar(100) NOT NULL COMMENT ‘表路径’,
sync_type varchar(100) NOT NULL COMMENT ‘同步类型’,
table_owner varchar(100) NOT NULL COMMENT ‘表负责人’,
table_creater varchar(100) NOT NULL COMMENT ‘表创建人’,
is_partition boolean DEFAULT NULL COMMENT ‘是否分区’,
is_deleted boolean DEFAULT NULL COMMENT ‘是否删除’,
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘记录每次修改的时间’,
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘记录创建的时间’,
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_bin COMMENT =‘象数平台元数据表信息表’;
DROP TABLE IF EXISTS t_column_info;
CREATE TABLE t_column_info
(
id varchar(100) NOT NULL COMMENT ‘主键id’,
table_id varchar(100) NOT NULL COMMENT ‘数据库名称’,
column_name varchar(100) NOT NULL COMMENT ‘字段名’,
column_comment varchar(100) NOT NULL COMMENT ‘字段中文名’,
column_desc varchar(100) NOT NULL COMMENT ‘字段描述’,
column_type varchar(100) NOT NULL COMMENT ‘字段数据类型’,
column_is_encrypt boolean NOT NULL COMMENT ‘是否加密’,
is_deleted boolean DEFAULT NULL COMMENT ‘是否删除’,
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘记录每次修改的时间’,
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘记录创建的时间’,
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_bin COMMENT =‘象数平台元数据表字段信息表’;

DROP TABLE IF EXISTS t_permission_apply;
CREATE TABLE t_permission_apply
(
id varchar(100) NOT NULL COMMENT ‘主键id’,
user varchar(100) NOT NULL COMMENT ‘用户’,
database_name varchar(100) NOT NULL COMMENT ‘数据库名’,
table_name varchar(100) NOT NULL COMMENT ‘数据库表名’,
apply_reason varchar(100) NOT NULL COMMENT ‘申请原因’,
approve_response varchar(100) NOT NULL COMMENT ‘审批回复’,
status varchar(100) NOT NULL COMMENT ‘申请状态’,
approve_time datetime NOT NULL COMMENT ‘审批时间’,
is_deleted boolean NULL COMMENT ‘是否删除’,
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘记录每次修改的时间’,
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘记录创建的时间’,
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_bin COMMENT =‘象数平台元数据表权限申请信息表’;

DROP TABLE IF EXISTS t_table_recommend;
CREATE TABLE t_table_recommend
(
id varchar(100) NOT NULL COMMENT ‘主键id’,
user varchar(100) NOT NULL COMMENT ‘用户’,
database_name varchar(100) NOT NULL COMMENT ‘数据库名’,
table_name varchar(100) NOT NULL COMMENT ‘数据库表名’,
recommend_reason varchar(100) NOT NULL COMMENT ‘推荐原因’,
order_num varchar(100) NOT NULL COMMENT ‘推荐序号’,
is_deleted boolean DEFAULT NULL COMMENT ‘是否删除’,
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘记录每次修改的时间’,
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘记录创建的时间’,
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4

COLLATE = utf8mb4_bin COMMENT =‘象数平台元数据推荐表信息’;
DROP TABLE IF EXISTS t_metadata_info;
CREATE TABLE t_metadata_info
(
id varchar(100) NOT NULL COMMENT ‘主键id’,
sync_date varchar(100) NOT NULL COMMENT ‘同步日期’,
table_num varchar(100) NOT NULL COMMENT ‘表数据量’,
job_num varchar(100) NOT NULL COMMENT ‘调度系统任务数’,
all_data_num varchar(100) NOT NULL COMMENT ‘全量数据量’,
add_data_num varchar(100) NOT NULL COMMENT ‘增量数据量’,
is_deleted boolean DEFAULT NULL COMMENT ‘是否删除’,
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘记录每次修改的时间’,
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT ‘记录创建的时间’,
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_bin COMMENT =‘象数平台元数据首页展示信息表’;