public.vwusergroupmappings

Description

Table Definition

CREATE VIEW vwusergroupmappings AS (
 SELECT ugm.id,
    ugm.name,
    ud.id AS user_id,
    ud.name AS user_name,
    ugm.groupid AS group_id,
    ugm.updated
   FROM (usergroupmappings ugm
     JOIN userdetails ud ON (((ugm.userid)::text = (ud.id)::text)))
)

Columns

Name	Type	Nullable	Comment
id	varchar(100)	true	Primary Key / Unique Identifier for User-Group Mapping
name	varchar(100)	true	Name of the Group
user_id	varchar(50)	true	Unique Identifier for the User (Does not include owners)
user_name	varchar(200)	true	Name of the User
group_id	varchar(100)	true	Unique Identifier for the Group
updated	timestamp without time zone	true	Timestamp of the Last Update for the User-Group Mapping

Referenced Tables

Name	Columns	Comment	Type
public.usergroupmappings	5		BASE TABLE
public.userdetails	14		BASE TABLE