public.groupdetails

public.groupdetails

Description

Agent Group Lookup Data

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary Key / Agent Group GUID
name varchar(255) true Agent Group Name
description varchar(255) true Agent Group Description
membercount integer true Agent Group Member Count (Includes all members and Owners if flag set in GC)
state varchar(50) true Agent Group State
type varchar(50) true Agent Group Type
selfuri varchar(150) true Agent Group URI
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
groupdetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
groupdetails_pkey CREATE UNIQUE INDEX groupdetails_pkey ON public.groupdetails USING btree (id)