test

Tables (4)

ACCESS_TOKEN

  • id — bigint — Primary key — NOT NULL
  • access_token — varchar(2000) — NOT NULL
  • issued_at — datetime
  • expired_at — datetime

ID_TOKEN

  • id — bigint — Primary key — NOT NULL
  • id_token — varchar(2000)
  • issued_at — bigint
  • expired_at — bigint

OAUTH_TOKEN

  • id — bigint — Primary key — NOT NULL
  • client_id — varchar(256)
  • subject — varchar(256)
  • token_type — varchar(256)
  • access_token_id — bigint — Foreign key → ACCESS_TOKEN.id — NOT NULL
  • refresh_token_id — bigint — Foreign key → REFRESH_TOKEN.id — NOT NULL
  • id_token_id — bigint — Foreign key → ID_TOKEN.id — NOT NULL

REFRESH_TOKEN

  • id — bigint — Primary key — NOT NULL
  • refresh_token — varchar(256) — NOT NULL
  • issued_at — datetime
  • expired_at — datetime