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 OAuth usage by client ID per day Table Definition CREATE VIEW vwoauthusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, oauthusagedata.organizationid, oauthusagedata.userid, ...
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.evalquestiondata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true score ...
public.participantattributesdynamic
Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true conversationenddate ...
public.hoursblockdata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...