CREATE VIEW vwoauthusagedetaileddata AS (
SELECT oauthusagedetaileddata.clientid,
oauthusagedetaileddata.rowdate,
oauthusagedetaileddata.clientname,
oauthusagedetaileddata.organizationid,
oauthusagedetaileddata.userid,
oauthusagedetaileddata.templateuri,
oauthusagedetaileddata.httpmethod,
oauthusagedetaileddata.status200,
oauthusagedetaileddata.status300,
oauthusagedetaileddata.status400,
oauthusagedetaileddata.status500,
oauthusagedetaileddata.status429,
oauthusagedetaileddata.requests,
oauthusagedetaileddata.updated
FROM oauthusagedetaileddata
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| clientid | varchar(50) | true | ||||
| rowdate | timestamp without time zone | true | ||||
| clientname | varchar(200) | true | ||||
| organizationid | varchar(50) | true | ||||
| userid | varchar(50) | true | ||||
| templateuri | varchar(500) | true | ||||
| httpmethod | varchar(50) | true | ||||
| status200 | integer | true | ||||
| status300 | integer | true | ||||
| status400 | integer | true | ||||
| status500 | integer | true | ||||
| status429 | integer | true | ||||
| requests | integer | true | ||||
| updated | timestamp without time zone | true |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.oauthusagedetaileddata | 15 | Detailed OAuth usage by client, endpoint and HTTP method per day | BASE TABLE |