public.oauthusagedata

public.oauthusagedata

Description

Oauth Usage by Client ID per Day

Columns

Name Type Default Nullable Children Parents 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)

Constraints

Name Type Definition
oauthusagedata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

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