public.oauthusagedetaileddata

public.oauthusagedetaileddata

Description

Detailed OAuth usage by client, endpoint and HTTP method per day

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(200) 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 (user) GUID
templateuri varchar(500) true The API resource or template URI
httpmethod varchar(50) true HTTP verb used for the request
status200 integer true Count of 200 response codes
status300 integer true Count of 3xx response codes
status400 integer true Count of 4xx response codes
status500 integer true Count of 5xx response codes
status429 integer true Count of 429 rate-limit responses
requests integer true Total number of requests
updated timestamp without time zone true UTC timestamp when row was written

Constraints

Name Type Definition
oauthusagedetaileddata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
oauthusagedetaileddata_pkey CREATE UNIQUE INDEX oauthusagedetaileddata_pkey ON public.oauthusagedetaileddata USING btree (keyid)