test
Tables (4)
app_users
- id — BIGSERIAL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- enabled — BOOLEAN — NOT NULL
- approved — BOOLEAN — NOT NULL
oauth2_authorization
- id — varchar(100) — Primary key — NOT NULL
- registered_client_id — varchar(100) — NOT NULL
- principal_name — varchar(200) — NOT NULL
- authorization_grant_type — varchar(100) — NOT NULL
- authorized_scopes — varchar(1000)
- attributes — TEXT
- state — varchar(500)
- authorization_code_value — TEXT
- authorization_code_issued_at — timestamp
- authorization_code_expires_at — timestamp
- authorization_code_metadata — TEXT
- access_token_value — TEXT
- access_token_issued_at — timestamp
- access_token_expires_at — timestamp
- access_token_metadata — TEXT
- access_token_type — varchar(100)
- access_token_scopes — varchar(1000)
- oidc_id_token_value — TEXT
- oidc_id_token_issued_at — timestamp
- oidc_id_token_expires_at — timestamp
- oidc_id_token_metadata — TEXT
- oidc_id_token_claims — TEXT
- refresh_token_value — TEXT
- refresh_token_issued_at — timestamp
- refresh_token_expires_at — timestamp
- refresh_token_metadata — TEXT
- user_code_value — TEXT
- user_code_issued_at — timestamp
- user_code_expires_at — timestamp
- user_code_metadata — TEXT
- device_code_value — TEXT
- device_code_issued_at — timestamp
- device_code_expires_at — timestamp
- device_code_metadata — TEXT
oauth2_authorization_consent
- registered_client_id — varchar(100) — Primary key — NOT NULL
- principal_name — varchar(200) — Primary key — NOT NULL
- authorities — varchar(1000) — NOT NULL
oauth2_registered_client
- id — varchar(100) — Primary key — NOT NULL
- client_id — varchar(100) — NOT NULL
- client_id_issued_at — timestamp — NOT NULL
- client_secret — varchar(200)
- client_secret_expires_at — timestamp
- client_name — varchar(200) — NOT NULL
- client_authentication_methods — varchar(1000) — NOT NULL
- authorization_grant_types — varchar(1000) — NOT NULL
- redirect_uris — varchar(1000)
- post_logout_redirect_uris — varchar(1000)
- scopes — varchar(1000) — NOT NULL
- client_settings — varchar(2000) — NOT NULL
- token_settings — varchar(2000) — NOT NULL