public.oauthusagedata

Description

Oauth Usage by Client ID per Day

Name	Type	Nullable	Comment
keyid	varchar(100)	false	Primary Key
clientid	varchar(50)	true	Oauth Client GUID
rowdate	timestamp without time zone	true	Date
clientname	varchar(200)	true	Oauth Client Name
organizationid	varchar(50)	true	Home Organization GUID
userid	varchar(50)	true	Oauth Agent GUID
status200	integer	true	Count of 200 Response Codes
status300	integer	true	Count of 200 Response Codes
status400	integer	true	Count of 200 Response Codes
status500	integer	true	Count of 200 Response Codes
status429	integer	true	Count of 429 Response Codes - Rate limiting Responses
updated	timestamp without time zone	true	Date Row Updated (UTC)

Name	Type	Definition
oauthusagedata_pkey	PRIMARY KEY	PRIMARY KEY (keyid)

Name	Definition
oauthusagedata_pkey	CREATE UNIQUE INDEX oauthusagedata_pkey ON public.oauthusagedata USING btree (keyid)

Related Articles
public.vwoauthusagedata
Description See OauthUsageData: Oauth Usage by Client ID per Day Table Definition CREATE VIEW vwoauthusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, oauthusagedata.organizationid, ...
public.vwsubuserusagedata
Description View containing usage data for sub-users, including HTTP status code counts Table Definition CREATE VIEW vwsubuserusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, ...
public.mvwconvvoiceoverviewdata
Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
public.mvwconvvoicesentimentdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...
public.vwteammemberdata
Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...