Database

This service uses PostgreSQL for:

• Spring Authorization Server (required) tables:
  • oauth2_authorization
  • oauth2_registered_client
• Domain tables for users/roles/permissions/sessions/audit:
  • oauth2_authorization
  • oauth2_registered_client
  • users
  • roles
  • groups
  • permissions
  • role_permissions_alignment
  • user_role_assignments
  • user_permissions_assignments
  • session_tokens
  • audit_events

The application uses Flyway to manage database creation, versioning and schema migration. After a version upgrade any necessary database migrations will be automatically applied.