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