table - sys_user_has_role «User Role» - erm4sn

Derivation Hierarchy

sys_user_has_role
«User Role»

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: sys_user_has_role
Label:: User Role (en)

Created On:: 2022.09.17 01:44:11
Created By:: system

Updated On:: 2022.09.17 02:55:37
Updated By:: system

Column Updated On:: 2022.09.17 01:48:35
Column Updated By:: system

Scope Name:: Global
Scope:: global

Listing:: open
Dictionary:: open

Columns

+	Status	Name	Label	Datatype	Length	Scope	Reference	Included By
		granted_by	Granted by	reference	32	Global	sys_user_group	sys_user_has_role
		included_in_role	Included in role	reference	32	Global	sys_user_has_role	sys_user_has_role
		included_in_role_instance	Included in role instance	reference	32	Global	sys_user_role_contains	sys_user_has_role
		inherited	Inherited	boolean	40	Global		sys_user_has_role
		inh_count	Inheritance Count	integer	40	Global		sys_user_has_role
		inh_map	Inheritance Map	glide_action_list	255	Global		sys_user_has_role
		role	Role	reference	32	Global	sys_user_role	sys_user_has_role
		state	State	string[choice]	40	Global		sys_user_has_role
		sys_created_by	Created by	string	40	Global		sys_user_has_role
		sys_created_on	Created	glide_date_time	40	Global		sys_user_has_role
	K	sys_id	Sys ID	GUID	32	Global		sys_user_has_role
		sys_mod_count	Updates	integer	40	Global		sys_user_has_role
		sys_updated_by	Updated by	string	40	Global		sys_user_has_role
		sys_updated_on	Updated	glide_date_time	40	Global		sys_user_has_role
	M	user	User	reference	32	Global	sys_user	sys_user_has_role

P

Passive

M

Mandatory

D

Display Value

K

Key

U

Unique

X

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Referenced

sys_user_has_role referenced from table:: service_category_user_role, sys_user_has_role

Diagram sys_user_has_role «User Role» / Global (global)

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out