public.usergroupmappings

public.usergroupmappings

Columns

Name Type Default Nullable Children Parents Comment
id varchar(100) false Primary Key / Unique Identifier for User-Group Mapping
name varchar(100) true Name of the User-Group Mapping
userid varchar(50) true Unique Identifier for the User (Does not include owners)
groupid varchar(100) true Unique Identifier for the Group
updated timestamp without time zone true Timestamp of the Last Update

Constraints

Name Type Definition
usergroupmappings_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
usergroupmappings_pkey CREATE UNIQUE INDEX usergroupmappings_pkey ON public.usergroupmappings USING btree (id)
usergroupmappings_userid_idx CREATE INDEX usergroupmappings_userid_idx ON public.usergroupmappings USING btree (userid)
usergroupmappings_groupid_idx CREATE INDEX usergroupmappings_groupid_idx ON public.usergroupmappings USING btree (groupid)
usergroupmappings_name_idx CREATE INDEX usergroupmappings_name_idx ON public.usergroupmappings USING btree (name)
idx_usergroupmappings_userid_name CREATE INDEX idx_usergroupmappings_userid_name ON public.usergroupmappings USING btree (userid, name)