Ranger 2.1.0 Database Schema

This document explains ranger 2.1.0 database schema information.It contains list of Tables its column details for databases supported.

1. x_db_version_h

   Description: This table contains entry of java patches and sql patches executed after creation of core schema.

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	version	varchar	64		NO
   3	inst_at	timestamp		CURRENT_TIMESTAMP	NO
   4	inst_by	varchar	256		NO
   5	updated_at	timestamp		CURRENT_TIMESTAMP	NO
   6	updated_by	varchar	256		NO
   7	active	enum	1	Y	YES

2. x_portal_user

   
   Description: This table contains user profile and credentials of Ranger Admin users. It also contains users synced from external sources but credentials are not stored and password field contains garbage value. Important attributes of this table are login_id, password, email, status and user_src. 'user_src' field value ‘0’ represents internal user while ‘1’ represents external user. External users are users synced from external sources i.e  (UNIX / LDAP / AD).
    

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	first_name	varchar	1,022		YES	MUL
   7	last_name	varchar	1,022		YES
   8	pub_scr_name	varchar	2,048		YES
   9	login_id	varchar	767		YES	UNI
   10	password	varchar	512		NO
   11	email	varchar	512		YES	UNI
   12	status	integer		0	NO
   13	user_src	integer		0	NO
   14	notes	varchar	4,000		YES
   15	other_attributes	varchar	4,000		YES

3. x_portal_user_role 

   
    Description: This table contains role details of users. User roles may be ‘ROLE_SYS_ADMIN’, ‘ROLE_USER’, ‘ROLE_KEY_ADMIN’, 'ROLE_ADMIN_AUDITOR', 'ROLE_KEY_ADMIN_AUDITOR' user_id of this table is a foreign key of x_portal_user(ID). 

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	user_id	bigint			NO	MUL	x_portal_user(id)
   7	user_role	varchar	128		YES
   8	status	integer		0	NO

4. xa_access_audit 

   Description:  This table contains entries of audit event done by users on resource of configured repositories.
   

    Note: This table has been kept just for backward compatibility. Audit to DB feature has been discontinued. 

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	audit_type	integer		0	NO
   7	access_result	integer		0	YES
   8	access_type	varchar	255		YES
   9	acl_enforcer	varchar	255		YES
   10	agent_id	varchar	255		YES
   11	client_ip	varchar	255		YES
   12	client_type	varchar	255		YES
   13	policy_id	bigint		0	YES		x_policy(id)
   14	repo_name	varchar	255		YES
   15	repo_type	integer		0	YES
   16	result_reason	varchar	255		YES
   17	session_id	varchar	255		YES
   18	event_time	datetime			YES	MUL
   19	request_user	varchar	255		YES
   20	action	varchar	2,000		YES
   21	request_data	varchar	2,000		YES
   22	resource_path	varchar	2,000		YES
   23	resource_type	varchar	255		YES
   24	seq_num	bigint		0	YES
   25	event_count	bigint		1	YES
   26	event_dur_ms	bigint		1	YES

5. x_asset

   Note: This table is not used anymore. It is available to support upgrade scenarios.

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	asset_name	varchar	1,024		NO
   7	descr	varchar	4,000		NO
   8	act_status	integer		0	NO
   9	asset_type	integer		0	NO
   10	config	mediumtext	1,67,77,215		YES
   11	sup_native	tinyint		0	NO

6. x_auth_sess

   Description: This table contains event details of authenticated and failed sessions. Important attributes are login_id, ext_sess_id, auth_time, auth_status, auth_type, auth_provider, req_ip. If user has Ranger installed for long duration, this table will get filled with large number of session entries. 

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	login_id	varchar	767		NO
   7	user_id	bigint			YES	MUL	x_portal_user(id)
   8	ext_sess_id	varchar	512		YES
   9	auth_time	datetime			NO
   10	auth_status	integer		0	NO
   11	auth_type	integer		0	NO
   12	auth_provider	integer		0	NO
   13	device_type	integer		0	NO
   14	req_ip	varchar	48		NO
   15	req_ua	varchar	1,024		YES

7. x_cred_store 

   Note: This table is not in use and might not be required in future. It is available to support upgrade scenarios.

   
   

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	store_name	varchar	1,024		NO
   7	descr	varchar	4,000		NO

8. x_db_base

   Note: This table is not in use and might not be required in future.It is available to support upgrade scenarios.

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)

9. x_group

    Description: This table contains group details. Important attributes of this table are group_name, status, group_type, group_src. Additional column is_visible is added to hide / unhide a group in Ranger UI.

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
   1	id	bigint			NO	PRI
   2	create_time	datetime			YES	MUL
   3	update_time	datetime			YES	MUL
   4	added_by_id	bigint			YES	MUL	x_portal_user(id)
   5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
   6	group_name	varchar	767		NO	UNI
   7	descr	varchar	4,000		NO
   8	status	integer		0	NO
   9	group_type	integer		0	NO
   10	cred_store_id	bigint			YES	MUL	x_cred_store(id)
   11	group_src	integer		0	NO
   12	is_visible	integer		1	NO
   13	other_attributes	varchar	4000		YES

10. x_group_groups

    Note: This table is not in use and will not be required in future. It is available to support upgrade scenarios.
    
    

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	group_name	varchar	1,024		NO
    7	p_group_id	bigint			YES	MUL	x_group(id)
    8	group_id	bigint			YES	MUL	x_group(id)

11. x_user

    Description: This table contains Ranger Admin users, it also contains users synced from external sources. Important attributes of this table are username, status. Additional column is_visible is added to hide/unhide a user in Ranger UI.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	user_name	varchar	767		NO	UNI
    7	descr	varchar	4,000		NO
    8	status	integer		0	NO
    9	cred_store_id	bigint			YES	MUL	x_cred_store(id)
    10	is_visible	integer		1	NO
    11	other_attributes	varchar	4000		YES

12. x_group_users

    Description: This table contain mapping of users and groups. Important attributes of this table are group_name, p_group_id, user_id. `p_group_id` refers to `x_group.id` and `user_id` refers to `x_user.id`

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	group_name	varchar	740		NO
    7	p_group_id	bigint			YES	MUL	x_group(id)
    8	user_id	bigint			YES	MUL	x_user(id)

13. x_policy_export_audit 

    Description: This table contains logs of policy export request. Important attributes of this table are client_ip, agent_id, req_epoch, repository_name, exported_json, http_ret_code.

    
    

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	client_ip	varchar	255		NO
    7	agent_id	varchar	255		YES
    8	req_epoch	bigint			NO
    9	last_updated	datetime			YES
    10	repository_name	varchar	1,024		YES
    11	exported_json	text	65,535		YES
    12	http_ret_code	integer		0	NO
    13	cluster_name	varchar	255		YES
    14	zone_name	varchar	255		YES
    15	policy_version	bigint			YES

14. x_resource

    Description: This table contains policy information of repositories. A policy contains resources, different types of repositories may have resources in different format. Important attributes of this table are 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. 

    Note: This table is not in use anymore.  It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	res_name	varchar	4,000		YES
    7	descr	varchar	4,000		YES
    8	res_type	integer		0	NO
    9	asset_id	bigint			NO	MUL	x_asset(id)
    10	parent_id	bigint			YES	MUL	x_resource(id)
    11	parent_path	varchar	4,000		YES
    12	is_encrypt	integer		0	NO
    13	is_recursive	integer		0	NO
    14	res_group	varchar	1,024		YES
    15	res_dbs	text	65,535		YES
    16	res_tables	text	65,535		YES
    17	res_col_fams	text	65,535		YES
    18	res_cols	text	65,535		YES
    19	res_udfs	text	65,535		YES
    20	res_status	integer		1	NO
    21	table_type	integer		0	NO
    22	col_type	integer		0	NO
    23	policy_name	varchar	500		YES	UNI
    24	res_topologies	text	65,535		YES
    25	res_services	text	65,535		YES

15. x_trx_log

    Description: This table contains logs of all CRUD operation done by user. Admin audits are retrieved from this table. 
    Important attributes of this table are object_name, attr_name, prev_val, new_val, trx_id, action, sess_id.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	class_type	integer		0	NO
    7	object_id	bigint			YES
    8	parent_object_id	bigint			YES
    9	parent_object_class_type	integer		0	NO
    10	parent_object_name	varchar	1,024		YES
    11	object_name	varchar	1,024		YES
    12	attr_name	varchar	255		YES
    13	prev_val	mediumtext	1,67,77,215		YES
    14	new_val	mediumtext	1,67,77,215		YES
    15	trx_id	varchar	1,024		YES
    16	action	varchar	255		YES
    17	sess_id	varchar	512		YES
    18	req_id	varchar	30		YES
    19	sess_type	varchar	30		YES

16. x_perm_map

    Description:  This table contains users and groups permission mapping on resources. Important attributes are perm_group, res_id, group_id, user_id, perm_for, perm_type, is_recursive.

    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	perm_group	varchar	1,024		YES
    7	res_id	bigint			YES	MUL	x_resource(id)
    8	group_id	bigint			YES	MUL	x_group(id)
    9	user_id	bigint			YES	MUL	x_user(id)
    10	perm_for	integer		0	NO
    11	perm_type	integer		0	NO
    12	is_recursive	integer		0	NO
    13	is_wild_card	tinyint		1	NO
    14	grant_revoke	tinyint		1	NO
    15	ip_address	text	65,535		YES

17. x_audit_map 

    Description:  This table contains users and groups audit rights mapping on resources. Important attributes are res_id, group_id, user_id, audit_type. 

    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES	MUL
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    6	res_id	bigint			YES	MUL	x_resource(id)
    7	group_id	bigint			YES	MUL	x_group(id)
    8	user_id	bigint			YES	MUL	x_user(id)
    9	audit_type	integer		0	NO

18. x_service_def

    Description: (This table added to Enable Pluggable service model in Ranger). This table contains metadata of services. Service definition of different Hadoop components can be stored as a template for defining services of specific hadoop component. Important attributes of this table are: version, name, impl_class_name, label, is_enabled.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES	MUL
    4	update_time	datetime			YES	MUL
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	version	bigint			YES
    8	name	varchar	1,024		YES
    9	display_name	varchar	1024		YES
    10	impl_class_name	varchar	1,024		YES
    11	label	varchar	1,024		YES
    12	description	varchar	1,024		YES
    13	rb_key_label	varchar	1,024		YES
    14	rb_key_description	varchar	1,024		YES
    15	is_enabled	tinyint		1	YES
    16	def_options	varchar	1024		YES

19. x_service

    Description: (Table added to Enable Pluggable service model in Ranger). This table contains services information. Important attributes of this table are: version, type, name, policy_version, is_enabled. 'type' column is reference of 'x_service_def.id' column.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES	MUL
    4	update_time	datetime			YES	MUL
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	version	bigint			YES
    8	type	bigint			YES	MUL	x_service_def(id)
    9	name	varchar	255		YES	UNI
    10	display_name	varchar	255		YES
    11	policy_version	bigint			YES
    12	policy_update_time	datetime			YES
    13	description	varchar	1,024		YES
    14	is_enabled	tinyint		0	NO
    15	tag_service	bigint			YES	MUL	x_service(id)
    16	tag_version	bigint		0	NO
    17	tag_update_time	datetime			YES

20. x_security_zone

    Description: This table contains Ranger security zone details. Important attributes of this table are version, name, jsonData, description.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	version	bigint	20		YES
    7	name	varchar	255		NO	UNI
    8	jsonData	mediumtext			YES
    9	description	varchar	1024		YES

    
    

21. x_ranger_global_state
    

    Description: This table contains ranger newly added elements ranger state related information like Ranger Role, Ranger User Store, Ranger Security Zone. Important Attributes are : version, state_name, app_data. state_name contains actual elements name, app_data contains version count after addition of new state in ranger.
    

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	version	bigint	20		YES
    7	state_name	varchar	255		NO	UNI
    8	app_data	varchar	255		YES

22. x_security_zone_ref_service

    Description: This table contains entries of service details assigned under Ranger security zone. Important attributes are : zone_id, service_id, service_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'service_id' is foreign key column of 'x_service.id' and the service_name contains the name of the service.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	zone_id	bigint	20		YES	MUL	x_security_zone(id)
    7	service_id	bigint	20		YES	MUL	x_service(id)
    8	service_name	varchar	255		YES	MUL	x_service(name)

23. x_security_zone_ref_tag_srvc

    Description: This table contains entries of tag services details assigned under Ranger security zone. Important attributes are : zone_id, tag_srvc_id, tag_srvc_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'tag_srvc_id' is foreign key column of 'x_service.id',  'tag_srvc_name' is foreign key column of 'x_service.name'.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	zone_id	bigint	20		YES	MUL	x_security_zone(id)
    7	tag_srvc_id	bigint	20		YES	MUL	x_service(id)
    8	tag_srvc_name	varchar	255		YES	MUL	x_service(name)

24. x_security_zone_ref_user

    Description: This table contains entries of user details assigned under Ranger security zone. Important attributes are : zone_id, user_id, user_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'user_id' is foreign key column of 'x_user.id' and the user_name contains the name of the user.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	zone_id	bigint	20		YES	MUL	x_security_zone(id)
    7	user_id	bigint	20		YES	MUL	x_user(id)
    8	user_name	varchar	255		YES	MUL	x_user(user_name)
    9	user_type	tinyint	3		YES

25. x_security_zone_ref_group

    Description: This table contains entries of group details assigned under Ranger security zone. Important attributes are : zone_id, group_id, group_name, group_type. 'zone_id' is foreign key column of 'x_security_zone.id', 'group_id' is foreign key column of 'x_group.id' and the group_name contains the name of the group.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	zone_id	bigint	20		YES	MUL	x_security_zone(id)
    7	group_id	bigint	20		YES	MUL	x_group(id)
    8	group_name	varchar	255		YES
    9	group_type	tinyint	3		YES

26. x_policy 

    Description: (Table added to Enable Pluggable service model in Ranger). 

    This table contains policies details of policies. Important attributes are service, name, policy_type, resource_signature, is_enabled,policy_text. 'service' column is foreign key of 'x_service.id' column.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES	MUL
    4	update_time	datetime			YES	MUL
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	version	bigint			YES
    8	service	bigint			NO	MUL	x_service(id)
    9	name	varchar	512		NO	MUL
    10	policy_type	integer		0	YES
    11	description	varchar	1,024		YES
    12	resource_signature	varchar	128		YES	MUL
    13	is_enabled	tinyint		0	NO
    14	is_audit_enabled	tinyint		0	NO
    15	policy_options	varchar	4000		YES
    16	policy_priority	int		0	NO
    17	policy_text	medium_text			YES
    18	zone_id	bigint			NO		x_security_zone(id)

27. x_service_config_def
    

    Description : 

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	def_id	bigint			NO	MUL	x_service_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	type	varchar	1,024		YES
    11	sub_type	varchar	1,024		YES
    12	is_mandatory	tinyint		0	NO
    13	default_value	varchar	1,024		YES
    14	validation_reg_ex	varchar	1,024		YES
    15	validation_message	varchar	1,024		YES
    16	ui_hint	varchar	1,024		YES
    17	label	varchar	1,024		YES
    18	description	varchar	1,024		YES
    19	rb_key_label	varchar	1,024		YES
    20	rb_key_description	varchar	1,024		YES
    21	rb_key_validation_message	varchar	1,024		YES
    22	sort_order	int		0	YES

28. x_resource_def

    Description: (Table added to Enable Pluggable service model in Ranger)

    This table contains definitions of resources of each type of services. Important attributes are : def_id, item_id, name, type, res_level, parent, mandatory, look_up_supported, recursive_supported, excludes_supported, matcher, matcher_options, validation_reg_ex, validation_message, ui_hint, label, description, sort_order. 'def_id' is foreign key reference of 'x_service_def.id' column, 'item_id' is the sequence number of each items created under each service definitions. 'name' column contains resource def name (i.e path, column, table, topology). 'type' column is data-type of name (i.e path type for path). 'parent' is foreign key of 'id' column i.e if 'name' is of type ‘column’ then its parent would be table. 'matcher' contains matcher class name, 'matcher_options' contains key-value pair for matchers. i.e {"wildCard":"true", "ignoreCase":"YES"}.  'label' contains label value to be displayed in UI for name column.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	def_id	bigint			NO	MUL	x_service_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	type	varchar	1,024		YES
    11	res_level	bigint			YES
    12	parent	bigint			YES	MUL	x_resource_def(id)
    13	mandatory	tinyint		0	NO
    14	look_up_supported	tinyint		0	NO
    15	recursive_supported	tinyint		0	NO
    16	excludes_supported	tinyint		0	NO
    17	matcher	varchar	1,024		YES
    18	matcher_options	varchar	1,024		YES
    19	validation_reg_ex	varchar	1,024		YES
    20	validation_message	varchar	1,024		YES
    21	ui_hint	varchar	1,024		YES
    22	label	varchar	1,024		YES
    23	description	varchar	1,024		YES
    24	rb_key_label	varchar	1,024		YES
    25	rb_key_description	varchar	1,024		YES
    26	rb_key_validation_message	varchar	1,024		YES
    27	sort_order	int		0	YES
    28	datamask_options	varchar	1024		YES
    29	rowfilter_options	varchar	1024		YES

29. x_access_type_def

     Description: (Table added to Enable Pluggable service model in Ranger). This table contains definitions of access types(i.e read, write). Important attributes are def_id, item_id, name, label, rb_key_label, sort_order.def_id is foreign key of x_service_def.id table. item_id is sequence number of access_type entries under each service def. name fields denotes access type names(i.e read, write, execute). 'label' field contains label value that needs to be displayed in UI for name column.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	def_id	bigint			NO	MUL	x_service_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	label	varchar	1,024		YES
    11	rb_key_label	varchar	1,024		YES
    12	sort_order	int		0	YES
    13	datamask_options	varchar	1024		YES
    14	rowfilter_options	varchar	1024		YES

30. x_access_type_def_grants

    Description: (Table added to Enable Pluggable service model in Ranger). This table contains entries of access types which can have grants. Important attributes are atd_id, implied_grant. atd_id is foreign key of x_access_type_def.id

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	atd_id	bigint			NO	MUL	x_access_type_def(id)
    8	implied_grant	varchar	1,024		YES

31.  x_policy_condition_def 

    Description: This table contains conditions which need to be applied in policy (i.e IP address range). Important attributes of this table are def_id, item_id, name, evaluator, evaluator_options, validation_reg_ex, validation_message, ui_hint, label, description, sort_order.'def_id' is foreign key of 'x_service_def.id' column. 'item_id' contains policy condition sequence number under each service def. 'name' denotes condition name. 'evaluator' contains condition evaluator class name. 

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	def_id	bigint			NO	MUL	x_service_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	evaluator	varchar	1,024		YES
    11	evaluator_options	varchar	1,024		YES
    12	validation_reg_ex	varchar	1,024		YES
    13	validation_message	varchar	1,024		YES
    14	ui_hint	varchar	1,024		YES
    15	label	varchar	1,024		YES
    16	description	varchar	1,024		YES
    17	rb_key_label	varchar	1,024		YES
    18	rb_key_description	varchar	1,024		YES
    19	rb_key_validation_message	varchar	1,024		YES
    20	sort_order	int		0	YES

32. x_context_enricher_def  

    Description: Same as policy-condition but enrichers will enrich policies by taking input from outside the system and user don’t need to provide any condition in policy. Important fields are 'name' and 'enricher'. Name field holds the name of enricher i.e `COUNTRY` and 'enricher' field holds the class name which will be enriching policy for this particular context-enricher.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	def_id	bigint			NO	MUL	x_service_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	enricher	varchar	1,024		YES
    11	enricher_options	varchar	1,024		YES
    12	sort_order	int		0	YES

33. x_enum_def

    Description: This table contains enum definitions. Important attributes are def_id, item_id, name. 'def_id' is foreign key of 'x_service_def.id' column. 'name' column denoted the enum name (i.e authnType, rpcProtection). 

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	def_id	bigint			NO	MUL	x_service_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	default_index	bigint			YES

34. x_enum_element_def

    Description: This table contains element details of enum defined in x_enum_def table. Important attributes are enum_def_id, item_id, name, label, sort_order. enum_def_id is foreign key column of x_enum_def.id. 'name' contains enum element name (i.e simple, kerberos).

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	enum_def_id	bigint			NO	MUL	x_enum_def(id)
    8	item_id	bigint			NO
    9	name	varchar	1,024		YES
    10	label	varchar	1,024		YES
    11	rb_key_label	varchar	1,024		YES
    12	sort_order	int		0	YES

35. x_service_config_map

    Description: This table contains x_service_config_map. Important attributes are service, config_key, config_value. 'service' column is foreign key of 'x_service.id'. 'config_key' contains config attribute name and 'config_value' contains the value of config key field.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	service	bigint			NO	MUL	x_service(id)
    8	config_key	varchar	1,024		YES
    9	config_value	varchar	4,000		YES

36. x_policy_resource

    Description: This table contains entries of resources assigned under policy. Important attributes are : policy_id, res_def_id, is_excludes, is_recursive. 'policy_id' is foreign key column of 'x_policy.id' and 'res_def_id' is foreign key column of 'x_resource_def.id' column. 'is_excludes' flag denotes whether policy should be enforced on the mapped resources or all other resources except mapped one. 'is_recursive' flag denotes whether policy need to be enforced in child resources also or not.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	policy_id	bigint			NO	MUL	x_policy(id)
    8	res_def_id	bigint			NO	MUL	x_resource_def(id)
    9	is_excludes	tinyint		0	NO
    10	is_recursive	tinyint		0	NO

37. x_policy_resource_map

    Description: This table contains entries of resources values assigned under policy. Important attributes are : resource_id, value. 'resource_id' is foreign key column of 'x_policy_resource.id' and value contains resource entries.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	resource_id	bigint			NO	MUL	x_policy_resource(id)
    8	value	varchar	1,024		YES
    9	sort_order	int		0	YES

38. x_policy_item

    Description: This table contains delegated admin flag of a policy. Important attributes are policy_id, delegate_admin, sort_order. 'policy_id' is foreign key column of 'x_policy.id'. delegate_admin contains flag for whether delegated admin rights are given in policy or not.
    Note: It is not used anymore. It is available to support upgrade scenarios.
    

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	policy_id	bigint			NO	MUL	x_policy(id)
    8	delegate_admin	tinyint		0	NO
    9	sort_order	int		0	YES
    10	item_type	int		0	NO
    11	is_enabled	tinyint		1	NO
    12	comments	varchar	255		YES

39. x_policy_item_access

    Description: This table contains whether specific access is allowed or not in specific policy item. Important attributes are policy_item_id, type, is_allowed. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'type' is foreign key column of 'x_access_type_def.id'
    Note: It is not used anymore. It is available to support upgrade scenarios.
    

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	policy_item_id	bigint			NO	MUL	x_policy_item(id)
    8	type	bigint			NO	MUL	x_access_type_def(id)
    9	is_allowed	tinyint		0	NO
    10	sort_order	int		0	YES

40. x_policy_item_condition

    Description: This table contains whether specific access is allowed or not in specific policy item. Important attributes are policy_item_id, type, is_allowed. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'type' is foreign key column of 'x_policy_condition_def.id'
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES	MUL
    4	update_time	datetime			YES	MUL
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_item_id	bigint	20		NO	MUL	x_policy_item(id)
    8	type	bigint			NO	MUL	x_policy_condition_def(id)
    9	value	varchar	1,024		YES
    10	sort_order	int		0	YES

41. x_policy_item_user_perm

    Description: This table contains mapping of policy item and user. If any user is having access to any specific policy item then corresponding entry needs to be done in the this table. Important attributes are policy_item_id, user_id. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'user_id' is foreign key of 'x_user.id'.
    
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	policy_item_id	bigint			NO	MUL	x_policy_item(id)
    8	user_id	bigint			YES	MUL	x_user(id)
    9	sort_order	int		0	YES

42. x_policy_item_group_perm

    Description: This table contains mapping of policy item and groups. If any group is given access to any specific policy item then corresponding entry need to be done in this  table. Important attributes are policy_item_id, group_id. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'group_id' is foreign key of 'x_group.id'
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	guid	varchar	1,024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint			YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint			YES	MUL	x_portal_user(id)
    7	policy_item_id	bigint			NO	MUL	x_policy_item(id)
    8	group_id	bigint			YES	MUL	x_group(id)
    9	sort_order	int		0	YES

43. x_data_hist

    Description: This table contains history of create, update and delete of objects service-defs, services and policies.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	obj_guid	varchar	1,024		NO
    5	obj_class_type	integer			NO
    6	obj_id	bigint			NO	MUL
    7	obj_name	varchar	1,024		NO
    8	version	bigint			YES
    9	action	varchar	512		NO
    10	from_time	datetime			NO
    11	to_time	datetime			YES
    12	content	text	65,535		NO

44. x_modules_master

    Description: (Table added to enable Permission model in Ranger). 
    This table contain all module details available in Ranger Admin. 'module' column contain name of module. Example of modules are 1) Resource Based Policies, 2) Users/Groups, 3) Audits Module.. etc.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint			YES		x_portal_user(id)
    5	upd_by_id	bigint			YES		x_portal_user(id)
    6	module	varchar	1,024		NO
    7	url	varchar	1,024		YES

45. x_user_module_perm 

    Description:(Table added to enable Permission model in Ranger). This table contains mapping of user and module. Important attributes are user_id, module_id, is_allowed. 'user_id' is foreign key of 'x_portal_user.id' and 'module_id' is foreign key of 'x_modules_master.id' column. 'is_allowed' column value denotes whether a user has access to mapped user or not.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	user_id	bigint			YES	MUL	x_portal_user(id)
    3	module_id	bigint			YES	MUL	x_modules_master(id)
    4	create_time	datetime			YES
    5	update_time	datetime			YES
    6	added_by_id	bigint			YES		x_portal_user(id)
    7	upd_by_id	bigint			YES		x_portal_user(id)
    8	is_allowed	integer		1	NO

46. x_group_module_perm 

    Description: (Table added to enable Permission model in Ranger).This table contains mapping of group and module. Important attributes are group_id, module_id, is_allowed. 'group_id' is foreign key of 'x_group.id' and 'module_id' is foreign key of 'x_modules_master.id' column. 'is_allowed' flag denotes whether a group has access to mapped group or not.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint			NO	PRI
    2	group_id	bigint			YES	MUL	x_group(id)
    3	module_id	bigint			YES	MUL	x_modules_master(id)
    4	create_time	datetime			YES
    5	update_time	datetime			YES
    6	added_by_id	bigint			YES		x_portal_user(id)
    7	upd_by_id	bigint			YES		x_portal_user(id)
    8	is_allowed	integer		1	NO

47. x_tag_def
    

    Description: This table contains tag def details. Important attributes are : version, name, source, is_enabled, tag_attrs_def_text.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		NO	UNI
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	version	bigint	20		YES
    8	name	varchar	255		NO	UNI
    9	source	varchar	128		YES
    10	is_enabled	tinyint	1	0	NO
    11	tag_attrs_def_text	mediumtext			YES

48. x_tag

    Description: This table contains Ranger tag details. Important attributes are: version, type, owned_by, policy_options, tag_attrs_text. ‘type’ is foreign key of table ‘x_tag_def.type’.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		NO	UNI
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	version	bigint	20		YES
    8	type	bigint	20		NO	MUL	x_tag_def(id)
    9	owned by	smallint	6	0	NO
    10	policy_options	varchar	4000		YES
    11	tag_attrs_text	mediumtext			YES

49. x_service_resource

    Description: This table contains resources details assigned under service. Important attributes are : version, service_id, resource_signature, is _enabled, service_resource_elements_text, tags_text. 'service_id' is foreign key column of 'x_service.id'. is_enabled is the value selected under ‘Active Status’.’service_resource_elements_text’ contains actual value assigned resources details in json format, this is a very important attribute. ‘tags_text’ contains tag details service in json format. ‘resource_signatire’ is saved as a hashcode of resources.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		NO	UNI
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	version	bigint	20		YES
    8	service_id	bigint	20		NO	MUL	x_service(id)
    9	resource_signature	varchar	128		YES	UNI
    10	is_enabled	tinyint	1	1	NO
    11	service_resource_elements_text	mediumtext			YES
    12	tags_text	mediumtext			YES

50. x_tag_resource_map

    Description: This table contains resource mapping details under tag. Important attributes are : tag_id, res_id. ‘tag_id’ is a foreign key column of ‘x_tag.id’. ‘res_id’ is foreign key column of ‘x_service_resource.id’.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		NO	UNI
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	tag_id	bigint	20		NO	MUL	x_tag(id)
    8	res_id	bigint	20		NO	MUL	x_service_resource(id)

51. x_datamask_type_def

    Description: This table contains data masking type definition details assigned under ranger service. Important attributes are : def_id, item_id, name, transformer, datamask_options, rb_key_label, rb_key_description. ‘def_id’ is foreign key of column ‘x_service_def.id’.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	def_id	bigint	20		NO	MUL	x_service_def(id)
    8	item_id	bigint	20		NO
    9	name	varchar	1024		NO
    10	label	varchar	1024		NO
    11	description	varchar	1024		YES
    12	transformer	varchar	1024		YES
    13	datamask_options	varchar	1024		YES
    14	rb_key_label	varchar	1024		YES
    15	rb_key_description	varchar	1024		YES
    16	sort_order	int	11	0	YES

52. x_policy_item_datamask

    
    

    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		YES
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	policy_item_id	bigint	20		NO	MUL	x_policy_item(id)
    7	type	bigint	20		NO	MUL	x_datamask_type_def(id)
    8	condition_expr	varchar	1024		YES
    9	value_expr	varchar	1024		YES

53. x_policy_item_rowfilter

    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	64		YES
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	policy_item_id	bigint	20		NO	MUL	x_policy_item(id)
    7	filter_expr	varchar	1024		YES

54. x_service_version_info

    Description: This table contains version details for service. Important attributes are: tag_version, tag_update_time, role_version, role_update_time. 'service_id' is foreign key column of 'x_service.id'. tag_version maintains version details of tag, tag_update_time maintains last updated time of tag, role_version maintains version details of role, role_update_time maintains last updated time of role

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	service_id	bigint	20		NO	MUL	x_service(id)
    3	policy_version	bigint	20	0	NO
    4	policy_update_time	datetime			YES
    5	tag_version	bigint	20	0	NO
    6	tag_update_time	datetime			YES
    7	role_version	bigint	20	0	NO
    8	role_update_time	datetime			YES
    9	version	bigint	20	1	NO

55. x_plugin_info

    Description: This table contains plugin details of any ranger service. Important attributes are : service_name, app_type, host_name, ip_address, info. service_name contains service name details, host_name contains host name details, ip_address contains ip address of user, info contains plugin information.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	service_name	varchar	255		NO	MUL
    5	app_type	varchar	128		NO
    6	host_name	varchar	255		NO	MUL
    7	ip_address	varchar	64		NO
    8	info	varchar	1024		NO

56. x_policy_label

    
    

    Description: This table mainly contains label details assigned under policy. Important attribute is label_name.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES	MUL
    4	update_time	datetime			YES	MUL
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	label_name	varchar	512		YES	UNI

57. x_policy_label_map

    Description: This table contains mapping of label values assigned under policy. Important attributes are : policy_id, policy_label_id. 'policy_id' is foreign key column of 'x_policy.id' and the value contains resource entries and 'policy_label_id' is foreign key column of 'x_policy_label.id'.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES	MUL
    4	update_time	datetime			YES	MUL
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		YES	MUL	x_policy(id)
    8	policy_label_id	bigint	20		YES	MUL	x_policy_label(id)

58. x_ugsync_audit_info

    Description: This table contains Ranger user sync audit information under Ranger Audit.  Important attributes are : event_time, user_name, sync_source, no_of_new_users, no_of_new_groups, no_of_modified_users, no_of_modified_group, sync_source_info, session_id.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES		x_portal_user(id)
    5	upd_by_id	bigint	20		YES		x_portal_user(id)
    6	event_time	datetime			YES	MUL
    7	user_name	varchar	255		NO	MUL
    8	sync_source	varchar	128		NO	MUL
    9	no_of_new_users	bigint	20		NO
    10	no_of_new_groups	bigint	20		NO
    11	no_of_modified_users	bigint	20		NO
    12	no_of_modified_groups	bigint	20		NO
    13	sync_source_info	mediumtext			NO
    14	session_id	varchar	255		YES

59. x_policy_ref_resource

    Description: This table contains mapping of unique resource ids  assigned under policy. Important attributes are : policy_id, resource_id, resource_name. policy_id is foreign key column of 'x_policy.id', resource_id is foreign key column of x_resource_def.id' and resource_name is the name of the resource details assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		NO	MUL	x_policy(id)
    8	resource_def_id	bigint	20		NO	MUL	x_resource_def(id)
    9	resource_name	varchar	4000		YES

60. x_policy_ref_access_type

    Description: This table contains access type information assigned under policy. Important attributes are : policy_id, access_def_id, access_type_name. policy_id is foreign key column of 'x_policy.id', access_def_id is foreign key column of ‘x_access_type_def.id' and access_type_name permission details assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		NO	MUL	x_policy(id)
    8	access_def_id	bigint	20		NO	MUL	x_access_type_def(id)
    9	access_type_name	varchar	4000		YES

61. x_policy_ref_condition

    Description: This table contains policy condition details values assigned under policy. Important attributes are : policy_id, condition_def_id, condition_type_name. policy_id is foreign key column of 'x_policy.id', condition_def_id is foreign key column of x_policy_condition_def.id' and condition_type_name is name of condition assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		NO	MUL	x_policy(id)
    8	condition_def_id	bigint	20		NO	MUL	x_policy_condition_def(id)
    9	condition_name	varchar	4000		YES

62. x_policy_ref_datamask_type

    Description: This table contains entries of data mask conditions assigned under policy. Important attributes are : policy_id, datamask_def_id, condition_type_name. policy_id is foreign key column of 'x_policy.id', datamask_def_id is foreign key column of x_datamask_type_def.id' and datamask_type_name is name of data masking condition assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		NO	MUL	x_policy(id)
    8	datamask_def_id	bigint	20		NO	MUL	x_datamask_type_def(id)
    9	datamask_type_name	varchar	4000		YES

63. x_policy_ref_user

    Description: This table contains user id and name assigned under policy. Important attributes are : policy_id, user_id, user_name. policy_id is foreign key column of 'x_policy.id', user_id is foreign key column of x_user.id' and user_name is the name of the user assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		NO	MUL	x_policy(id)
    8	user_id	bigint	20		NO	MUL	x_user(id)
    9	user_name	varchar	4000		YES

64. x_policy_ref_group

    Description: This table contains group values assigned under policy. Important attributes are : policy_id, group_id, group_name. policy_id is foreign key column of 'x_policy.id', group_id is foreign key column of x_group.id' and group_name is the name of the group assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	guid	varchar	1024		YES
    3	create_time	datetime			YES
    4	update_time	datetime			YES
    5	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    7	policy_id	bigint	20		NO	MUL	x_policy(id)
    8	group_id	bigint	20		NO	MUL	x_group(id)
    9	group_name	varchar	4000		YES

65. x_security_zone_ref_resource

    Description: This table contains entries of resource details assigned under Ranger security zone. Important attributes are : zone_id, resource_def, resource_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'resource_def_id' is foreign key column of 'x_resource_def.id' and the resource_name contains the name of the resource.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	zone_id	bigint	20		NO	MUL	x_security_zone(id)
    7	resource_def_id	bigint	20		NO	MUL	x_resource_def(id)
    8	resource_name	varchar	255		YES

66. x_policy_change_log

    Description: This table contains entries of resources values assigned under policy. Important attributes are : resource_id, value. 'resource_id' is foreign key column of 'x_policy_resource.id' and value contains resource entries.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	service_id	bigint	20		NO	MUL	x_service(id)
    4	chnage_type	int	11		NO
    5	policy_version	bigint	20	0	NO	MUL
    6	service_type	varchar	256		YES
    7	policy_type	int	11		YES
    8	zone_name	varchar	256		YES
    9	policy_id	bigint	20		YES		x_policy(id)

67. x_role

    Description: This table contains Ranger Admin roles, it also contains roles synced from external sources. Important attributes of this table are version, name, description, role_options, role_text.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint			YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint			YES		x_portal_user(id)
    6	version	bigint	20		YES
    7	name	varchar	255		NO	UNI
    8	description	varchar	1024		YES
    9	role_options	varchar	4000		YES
    10	role_text	mediumtext			YES

68. x_role_ref_user

    Description: This table contains entries of user details assigned under role. Important attributes are : role_id, user_id, user_name, priv_type. 'role_id' is foreign key column of 'x_role.id', 'user_id' is foreign key column of 'x_user.id' and the user_name contains the name of the user.  priv_type is nothing but user type which default value is 0.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20				x_portal_user(id)
    6	role_id	bigint	20		No	MUL	x_role(id)
    7	user_id	bigint	20		YES	MUL	x_user(id)
    8	user_name	varchar	767		YES
    9	priv_type	int	10		YES

69. x_role_ref_group

    Description: This table contains entries of group details assigned under role. Important attributes are : role_id, group_id, group_name, priv_type. 'role_id' is foreign key column of 'x_role.id', 'group_id' is foreign key column of 'x_group.id' and the group_name contains a name of the group. priv_type is nothing but user type which default value is 0.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES	MUL
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	role_id	bigint	20		NO	MUL	x_role(id)
    7	group_id	varchar	20		YES		x_group(id)
    8	group_name	varchar	767		YES
    9	priv_type	int	10		YES

70. x_policy_ref_role

    Description: This table contains group values assigned under policy. Important attributes are : policy_id, role_id, role_name. policy_id is foreign key column of 'x_policy.id', role_id is foreign key column of x_role.id' and role_name is the name of the role assigned under policy.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	policy_id	bigint	20		NO	MUL	x_policy(id)
    7	role_id	bigint	20		NO	MUL	x_role(id)
    8	role_name	varchar	255		YES

71. x_role_ref_role

    Description: This table contains entries of role details assigned under role. Important attributes are : role_id, role_ref_id, group_name, priv_type. 'role_id' is foreign key column of 'x_role.id', 'role_ref_id' is foreign key column of 'x_role_ref_role.id' and the role_name contains a name of role. priv_type is nothing but user type which default value is 0.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint	20		YES	MUL	x_portal_user(id)
    5	upd_by_id	bigint	20		YES	MUL	x_portal_user(id)
    6	role_ref_id	bigint	20		YES	MUL	x_role(id)
    7	role_id	bigint	20		NO
    8	role_name	varchar	255		YES
    9	priv_type	int	10		YES

72. x_tag_change_log

    Description: This table maintains logs for any change in tag. Important  attributes are : service_id, change_type, service_tag_version, service_resource_id, tag_id.

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY	Foreign Key
    1	id	bigint	20		NO	PRI
    2	create_time	datetime			YES
    3	service_id	bigint	20		NO	MUL	x_service(id)
    4	change_type	int	11		NO
    5	service_tag_version	bigint	20	0	NO	MUL
    6	service_resource_id	bigint	20		YES
    7	tag_id	bigint	20		YES

73. vx_trx_log 

    Description: This is a view created from x_trx_log table. 

    Schema definition of view is:

    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);  

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_KEY
    1	id	bigint		0	NO
    2	create_time	datetime			YES
    3	update_time	datetime			YES
    4	added_by_id	bigint			YES
    5	upd_by_id	bigint			YES
    6	class_type	integer		0	NO
    7	object_id	bigint			YES
    8	parent_object_id	bigint			YES
    9	parent_object_class_type	integer		0	NO
    10	attr_name	varchar	255		YES
    11	parent_object_name	varchar	1,024		YES
    12	object_name	varchar	1,024		YES
    13	prev_val	mediumtext	1,67,77,215		YES
    14	new_val	mediumtext	1,67,77,215		YES
    15	trx_id	varchar	1,024		YES
    16	action	varchar	255		YES
    17	sess_id	varchar	512		YES
    18	req_id	varchar	30		YES
    19	sess_type	varchar	30		YES