View almasdd.COMPIERE.AD_USER_ROLES_V

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column	Type	Size	Nulls	Auto	Default	Children	Parents
NAME	nvarchar2	120
ROLENAME	nvarchar2	120

View SQL:

SELECT u.Name, r.Name AS RoleName FROM AD_User_Roles ur INNER JOIN AD_User u ON (ur.AD_User_ID=u.AD_User_ID) INNER JOIN AD_Role r ON (ur.AD_Role_ID=r.AD_Role_ID)

SELECT u.Name, r.Name AS RoleName
FROM AD_User_Roles ur
INNER JOIN AD_User u ON (ur.AD_User_ID=u.AD_User_ID)
INNER JOIN AD_Role r ON (ur.AD_Role_ID=r.AD_Role_ID)