Derivation Hierarchy

Subclasses:
No Subclasses
Siblings:
No Siblings

Table Details

Name:
sys_user_has_role
Label:
User Role (en)
Created On:
2022.03.18 02:58:34
Created By:
system
Updated On:
2022.12.28 11:16:15
Updated By:
system
Column Updated On:
2022.03.18 03:01:36
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

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