View containing usage data for sub-users, including HTTP status code counts
CREATE VIEW vwsubuserusagedata AS (
SELECT oauthusagedata.clientid,
oauthusagedata.rowdate,
oauthusagedata.clientname,
oauthusagedata.organizationid,
oauthusagedata.userid,
oauthusagedata.status200,
oauthusagedata.status300,
oauthusagedata.status400,
oauthusagedata.status500,
oauthusagedata.status429,
oauthusagedata.updated
FROM oauthusagedata
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| clientid | varchar(50) | true | Client GUID | |||
| rowdate | timestamp without time zone | true | Date | |||
| clientname | varchar(200) | true | Client Name | |||
| organizationid | varchar(50) | true | Organization GUID | |||
| userid | varchar(50) | true | User GUID | |||
| status200 | integer | true | Count of HTTP status code 200 | |||
| status300 | integer | true | Count of HTTP status code 300 | |||
| status400 | integer | true | Count of HTTP status code 400 | |||
| status500 | integer | true | Count of HTTP status code 500 | |||
| status429 | integer | true | Count of HTTP status code 429 | |||
| updated | timestamp without time zone | true | Timestamp indicating when the data was last updated |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.oauthusagedata | 12 | Oauth Usage by Client ID per Day | BASE TABLE |