Ranger1.2版本MySQL数据库架构

@TangXin

1901人浏览 · 2019-10-16 16:52:33

@TangXin · 2019-10-16 16:52:33 发布

文章目录

x_portal_user
x_portal_user_role
x_asset
x_auth_sess
x_cred_store
x_db_base
x_group
x_group_groups
x_user
x_group_users
x_policy_export_audit
x_resource
x_trx_log
x_perm_map
x_audit_map
x_db_version_h
xa_access_audit
vx_trx_log

参考：https://cwiki.apache.org/confluence/display/RANGER/Ranger+0.4.0+Database+Schema

x_portal_user

说明：此表包含用户配置文件和管理员用户的凭据。它还包含从外部源同步的用户，但凭证不存储，密码字段包含垃圾值。该表的重要属性是，login_id, password, email, status and user_src。user_src字段值‘0’表示内部用户，‘1’表示外部用户。外部用户是同步自外部源的用户。(UNIX / LDAP / AD)

CREATE TABLE `x_portal_user` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`first_name`  varchar(1022) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`last_name`  varchar(1022) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`pub_scr_name`  varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`login_id`  varchar(767) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`password`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`email`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(11) NOT NULL DEFAULT 0 ,
`user_src`  int(11) NOT NULL DEFAULT 0 ,
`notes`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `x_portal_user_UK_login_id` (`login_id`) USING BTREE ,
UNIQUE INDEX `x_portal_user_UK_email` (`email`) USING BTREE ,
INDEX `x_portal_user_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_portal_user_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_portal_user_cr_time` (`create_time`) USING BTREE ,
INDEX `x_portal_user_up_time` (`update_time`) USING BTREE ,
INDEX `x_portal_user_name` (`first_name`(767)) USING BTREE ,
INDEX `x_portal_user_email` (`email`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=29
ROW_FORMAT=DYNAMIC
;

SELECT login_id, password, email, status and user_src FROM `x_portal_user`;

在这里插入图片描述

x_portal_user_role

说明：此表包含用户的角色详细信息。用户角色可以是ROLE_SYS_ADMIN、ROLE_KEY_ADMIN 或 ROLE_USER。该表的user_id是x_portal_user(ID)的外键。

CREATE TABLE `x_portal_user_role` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`user_id`  bigint(20) NOT NULL ,
`user_role`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(11) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_portal_user_role_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_portal_user_role_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_portal_user_role_FK_user_id` (`user_id`) USING BTREE ,
INDEX `x_portal_user_role_cr_time` (`create_time`) USING BTREE ,
INDEX `x_portal_user_role_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=29
ROW_FORMAT=DYNAMIC
;

x_asset

说明：此表包含存储库的详细信息。该表的重要属性是，asset_name, asset_type, act_status, config。配置字段包含用于回购配置的json字符串。

CREATE TABLE `x_asset` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`asset_name`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`descr`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`act_status`  int(11) NOT NULL DEFAULT 0 ,
`asset_type`  int(11) NOT NULL DEFAULT 0 ,
`config`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`sup_native`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_asset_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_asset_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_asset_cr_time` (`create_time`) USING BTREE ,
INDEX `x_asset_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_auth_sess

说明：此表包含已验证和失败会话的事件详细信息。重要的属性，login_id, ext_sess_id, auth_time, auth_status, auth_type, auth_provider, req_ip。

SELECT login_id, ext_sess_id, auth_time, auth_status, auth_type, auth_provider, req_ip FROM `x_auth_sess`;

CREATE TABLE `x_auth_sess` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`login_id`  varchar(767) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  bigint(20) NULL DEFAULT NULL ,
`ext_sess_id`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`auth_time`  datetime NOT NULL ,
`auth_status`  int(11) NOT NULL DEFAULT 0 ,
`auth_type`  int(11) NOT NULL DEFAULT 0 ,
`auth_provider`  int(11) NOT NULL DEFAULT 0 ,
`device_type`  int(11) NOT NULL DEFAULT 0 ,
`req_ip`  varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`req_ua`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_auth_sess_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_auth_sess_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_auth_sess_FK_user_id` (`user_id`) USING BTREE ,
INDEX `x_auth_sess_cr_time` (`create_time`) USING BTREE ,
INDEX `x_auth_sess_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=670
ROW_FORMAT=DYNAMIC
;

x_cred_store

说明：该表目前没有使用，将来可能需要使用。

CREATE TABLE `x_cred_store` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`store_name`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`descr`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_cred_store_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_cred_store_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_cred_store_cr_time` (`create_time`) USING BTREE ,
INDEX `x_cred_store_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_db_base

说明：该表目前没有使用，将来可能需要使用。

CREATE TABLE `x_db_base` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_db_base_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_db_base_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_db_base_cr_time` (`create_time`) USING BTREE ,
INDEX `x_db_base_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_group

说明：该表包含组详细信息。该表的重要属性是，group_name, status, group_type, group_src。

CREATE TABLE `x_group` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`group_name`  varchar(767) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`descr`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`status`  int(11) NOT NULL DEFAULT 0 ,
`group_type`  int(11) NOT NULL DEFAULT 0 ,
`cred_store_id`  bigint(20) NULL DEFAULT NULL ,
`group_src`  int(11) NOT NULL DEFAULT 0 ,
`is_visible`  int(11) NOT NULL DEFAULT 1 ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`cred_store_id`) REFERENCES `x_cred_store` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `x_group_UK_group_name` (`group_name`) USING BTREE ,
INDEX `x_group_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_group_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_group_FK_cred_store_id` (`cred_store_id`) USING BTREE ,
INDEX `x_group_cr_time` (`create_time`) USING BTREE ,
INDEX `x_group_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=13
ROW_FORMAT=DYNAMIC
;

SELECT group_name, status, group_type, group_src FROM `x_group`;

在这里插入图片描述

x_group_groups

说明：该表目前没有使用，将来可能需要使用。

CREATE TABLE `x_group_groups` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`group_name`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`p_group_id`  bigint(20) NULL DEFAULT NULL ,
`group_id`  bigint(20) NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`p_group_id`) REFERENCES `x_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_group_groups_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_group_groups_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_group_groups_FK_p_group_id` (`p_group_id`) USING BTREE ,
INDEX `x_group_groups_FK_group_id` (`group_id`) USING BTREE ,
INDEX `x_group_groups_cr_time` (`create_time`) USING BTREE ,
INDEX `x_group_groups_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_user

说明：此表包含管理员用户。它还包含来自外部源的用户同步。该表的重要属性是，username, status.

CREATE TABLE `x_user` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`user_name`  varchar(767) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`descr`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`status`  int(11) NOT NULL DEFAULT 0 ,
`cred_store_id`  bigint(20) NULL DEFAULT NULL ,
`is_visible`  int(11) NOT NULL DEFAULT 1 ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`cred_store_id`) REFERENCES `x_cred_store` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `x_user_UK_user_name` (`user_name`) USING BTREE ,
INDEX `x_user_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_user_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_user_FK_cred_store_id` (`cred_store_id`) USING BTREE ,
INDEX `x_user_cr_time` (`create_time`) USING BTREE ,
INDEX `x_user_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=31
ROW_FORMAT=DYNAMIC
;

x_group_users

说明：此表包含用户和组的映射。该表的重要属性是，group_name, p_group_id, user_id

CREATE TABLE `x_group_users` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`group_name`  varchar(740) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`p_group_id`  bigint(20) NULL DEFAULT NULL ,
`user_id`  bigint(20) NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`p_group_id`) REFERENCES `x_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `x_group_users_UK_uid_gname` (`user_id`, `group_name`) USING BTREE ,
INDEX `x_group_users_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_group_users_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_group_users_FK_p_group_id` (`p_group_id`) USING BTREE ,
INDEX `x_group_users_FK_user_id` (`user_id`) USING BTREE ,
INDEX `x_group_users_cr_time` (`create_time`) USING BTREE ,
INDEX `x_group_users_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=28
ROW_FORMAT=DYNAMIC
;

x_policy_export_audit

说明：此表包含策略导出请求的日志。该表的重要属性是，client_ip, agent_id, req_epoch, repository_name, exported_json, http_ret_code。

CREATE TABLE `x_policy_export_audit` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`client_ip`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`agent_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`req_epoch`  bigint(20) NOT NULL ,
`last_updated`  datetime NULL DEFAULT NULL ,
`repository_name`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`exported_json`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`http_ret_code`  int(11) NOT NULL DEFAULT 0 ,
`cluster_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_policy_export_audit_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_policy_export_audit_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_policy_export_audit_cr_time` (`create_time`) USING BTREE ,
INDEX `x_policy_export_audit_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=11
ROW_FORMAT=DYNAMIC
;

x_resource

说明：此表包含存储库的策略信息。策略包含资源。不同类型的存储库可能具有不同格式的资源。该表的重要属性是，res_name, res_type, asset_id, parent_id, parent_path, is_encrypt, is_recursive, res_group, res_dbs, res_tables, res_col_fams, res_cols, res_udfs, res_status, table_type, col_type, policy_name, res_topologies, res_services。

CREATE TABLE `x_resource` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`res_name`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`descr`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`res_type`  int(11) NOT NULL DEFAULT 0 ,
`asset_id`  bigint(20) NOT NULL ,
`parent_id`  bigint(20) NULL DEFAULT NULL ,
`parent_path`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`is_encrypt`  int(11) NOT NULL DEFAULT 0 ,
`is_recursive`  int(11) NOT NULL DEFAULT 0 ,
`res_group`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`res_dbs`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`res_tables`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`res_col_fams`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`res_cols`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`res_udfs`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`res_status`  int(11) NOT NULL DEFAULT 1 ,
`table_type`  int(11) NOT NULL DEFAULT 0 ,
`col_type`  int(11) NOT NULL DEFAULT 0 ,
`policy_name`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`res_topologies`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`res_services`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`asset_id`) REFERENCES `x_asset` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`parent_id`) REFERENCES `x_resource` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `x_resource_UK_policy_name` (`policy_name`) USING BTREE ,
INDEX `x_resource_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_resource_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_resource_FK_asset_id` (`asset_id`) USING BTREE ,
INDEX `x_resource_FK_parent_id` (`parent_id`) USING BTREE ,
INDEX `x_resource_cr_time` (`create_time`) USING BTREE ,
INDEX `x_resource_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_trx_log

说明：此表包含用户执行的所有CRUD操作的日志。该表的重要属性是，object_name, attr_name, prev_val, new_val, trx_id, action, sess_id。

CREATE TABLE `x_trx_log` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`class_type`  int(11) NOT NULL DEFAULT 0 ,
`object_id`  bigint(20) NULL DEFAULT NULL ,
`parent_object_id`  bigint(20) NULL DEFAULT NULL ,
`parent_object_class_type`  int(11) NOT NULL DEFAULT 0 ,
`parent_object_name`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`object_name`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`attr_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`prev_val`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`new_val`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`trx_id`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`action`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`sess_id`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`req_id`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`sess_type`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_trx_log_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_trx_log_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_trx_log_cr_time` (`create_time`) USING BTREE ,
INDEX `x_trx_log_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=311
ROW_FORMAT=DYNAMIC
;

x_perm_map

说明：此表包含对资源的用户和组权限映射。重要的属性，perm_group, res_id, group_id, user_id, perm_for, perm_type, is_recursive。

CREATE TABLE `x_perm_map` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`perm_group`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`res_id`  bigint(20) NULL DEFAULT NULL ,
`group_id`  bigint(20) NULL DEFAULT NULL ,
`user_id`  bigint(20) NULL DEFAULT NULL ,
`perm_for`  int(11) NOT NULL DEFAULT 0 ,
`perm_type`  int(11) NOT NULL DEFAULT 0 ,
`is_recursive`  int(11) NOT NULL DEFAULT 0 ,
`is_wild_card`  tinyint(1) NOT NULL DEFAULT 1 ,
`grant_revoke`  tinyint(1) NOT NULL DEFAULT 1 ,
`ip_address`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`res_id`) REFERENCES `x_resource` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_perm_map_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_perm_map_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_perm_map_FK_res_id` (`res_id`) USING BTREE ,
INDEX `x_perm_map_FK_group_id` (`group_id`) USING BTREE ,
INDEX `x_perm_map_FK_user_id` (`user_id`) USING BTREE ,
INDEX `x_perm_map_cr_time` (`create_time`) USING BTREE ,
INDEX `x_perm_map_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_audit_map

说明：此表包含用户和组审计资源上的权限映射。重要的属性，res_id, group_id, user_id, audit_type。

CREATE TABLE `NewTable` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`res_id`  bigint(20) NULL DEFAULT NULL ,
`group_id`  bigint(20) NULL DEFAULT NULL ,
`user_id`  bigint(20) NULL DEFAULT NULL ,
`audit_type`  int(11) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`res_id`) REFERENCES `x_resource` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `x_audit_map_FK_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `x_audit_map_FK_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `x_audit_map_FK_res_id` (`res_id`) USING BTREE ,
INDEX `x_audit_map_FK_group_id` (`group_id`) USING BTREE ,
INDEX `x_audit_map_FK_user_id` (`user_id`) USING BTREE ,
INDEX `x_audit_map_cr_time` (`create_time`) USING BTREE ,
INDEX `x_audit_map_up_time` (`update_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

x_db_version_h

说明：该表包含创建核心模式后执行的sql补丁的条目。

CREATE TABLE `NewTable` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`version`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`inst_at`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`inst_by`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`updated_at`  timestamp NULL DEFAULT NULL ,
`updated_by`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`active`  enum('Y','N') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=60
ROW_FORMAT=DYNAMIC
;

xa_access_audit

说明：此表包含用户对已配置存储库资源执行的审计事件的项。资源可以是HDFS/HIVE/HDFS/Knox/Storm资源。该表的重要属性是，audit_type, access_result, access_type, acl_enforcer, agent_id, client_ip, client_type, policy_id, repo_name, repo_type, result_reason, session_id, event_time, request_user, action, request_data, resource_path, resource_type。

CREATE TABLE `NewTable` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
`added_by_id`  bigint(20) NULL DEFAULT NULL ,
`upd_by_id`  bigint(20) NULL DEFAULT NULL ,
`audit_type`  int(11) NOT NULL DEFAULT 0 ,
`access_result`  int(11) NULL DEFAULT 0 ,
`access_type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`acl_enforcer`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`agent_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`client_ip`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`client_type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`policy_id`  bigint(20) NULL DEFAULT 0 ,
`repo_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`repo_type`  int(11) NULL DEFAULT 0 ,
`result_reason`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`session_id`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`event_time`  datetime NULL DEFAULT NULL ,
`request_user`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`action`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`request_data`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`resource_path`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`resource_type`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
INDEX `xa_access_audit_added_by_id` (`added_by_id`) USING BTREE ,
INDEX `xa_access_audit_upd_by_id` (`upd_by_id`) USING BTREE ,
INDEX `xa_access_audit_cr_time` (`create_time`) USING BTREE ,
INDEX `xa_access_audit_up_time` (`update_time`) USING BTREE ,
INDEX `xa_access_audit_event_time` (`event_time`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=DYNAMIC
;

vx_trx_log

说明：这是从x_trx_log表创建的视图。视图的模式定义为:

CREATE VIEW vx_trx_log AS 
select x_trx_log.id AS id,x_trx_log.create_time AS create_time,
	x_trx_log.update_time AS update_time,x_trx_log.added_by_id AS added_by_id,
	x_trx_log.upd_by_id AS upd_by_id,x_trx_log.class_type AS class_type,
	x_trx_log.object_id AS object_id,x_trx_log.parent_object_id AS parent_object_id,
	x_trx_log.parent_object_class_type AS parent_object_class_type,
	x_trx_log.attr_name AS attr_name,x_trx_log.parent_object_name AS parent_object_name,
	x_trx_log.object_name AS object_name,x_trx_log.prev_val AS prev_val,
	x_trx_log.new_val AS new_val,x_trx_log.trx_id AS trx_id,x_trx_log.action AS action,
	x_trx_log.sess_id AS sess_id,x_trx_log.req_id AS req_id,x_trx_log.sess_type AS sess_type 
	from x_trx_log  where id in(select min(x_trx_log.id) from x_trx_log group by x_trx_log.trx_id);