test

Tables (8)

OAUTH_ACCESS_TOKEN

  • ACCESSTOKEN_ID — VARCHAR2(256) — Primary key — NOT NULL
  • CLIENT_ID — VARCHAR2(128) — Foreign key → OAUTH_CLIENT_DETAILS.CLIENT_ID — NOT NULL
  • TOKEN_POLICY_ID — VARCHAR2(256) — Foreign key → OAUTH_CLIENT_DETAILS.TOKEN_POLICY_ID — NOT NULL
  • ACCESSTOKEN — BLOB
  • USER_ID — VARCHAR2(128)
  • CREATE_TIME — NUMBER

OAUTH_AUTHORIZATION_CODE

  • code — VARCHAR2(256) — Primary key — NOT NULL
  • CLIENT_ID — VARCHAR2(128) — Foreign key → OAUTH_CLIENT_DETAILS.CLIENT_ID — NOT NULL
  • USER_ID — VARCHAR2(128)

OAUTH_AUTHORIZATION_SERVER

  • AUTH_CODE_TIMEOUT — NUMBER — 단위 :second
  • AUTH_CODE_ENTROPY — NUMBER — 단위 : byte
  • REFRESHTOKEN_LENGTH — NUMBER
  • ALLOWED_GRANT_TYPE — VARCHAR2(128)
  • ROLL_REFRESHTOKEN_VALUE — BOOLEAN
  • MINIMUN_INTERVAL_REFRESHTOKEN — NUMBER
  • BYPASS_APPROVAL_PERSISTENT_GRANTS — BOOLEAN

OAUTH_CLIENT_DETAILS

  • CLIENT_ID — VARCHAR2(128) — Primary key — NOT NULL
  • TOKEN_POLICY_ID — VARCHAR2(256) — Foreign key → OAUTH_TOKEN_POLICY.TOKEN_POLICY_ID — NOT NULL
  • CLIENT_NAME — VARCHAR2(128)
  • DESC — VARCHAR2(256)
  • RESOURCE_IDS — VARCHAR2(256)
  • CLIENT_SECRET — VARCHAR2(128)
  • REDIRECT_URI — VARCHAR2(256)
  • RESTRICT_COMMON_SCOPES — VARHCAR2(128)
  • EXCLUSIVE_SCOPES — VARCHAR2(128)
  • ALLOWED_GRANT_TYPE — VARCHAR2(128)
  • GROUP_ID — VARCHAR2(128) — Foreign key → OAUTH_SCOPE_GROUP.GROUP_ID — NOT NULL

OAUTH_REFRESH_TOKEN

  • REFRESHTOKEN_ID — VARCHAR2(256) — Primary key — NOT NULL
  • ACCESSTOKEN_ID — VARCHAR2(256) — Foreign key → OAUTH_ACCESS_TOKEN.ACCESSTOKEN_ID — NOT NULL
  • REFRESHTOKEN — BLOB
  • CREATE_TIME — NUMBER
  • USER_ID — VARCHAR2(128)
  • Field — VARCHAR(255)

OAUTH_SCOPE

  • SEQ_SCOPE — NUMBER — Primary key — NOT NULL
  • SCOPE_VALUE — VARCHAR2(64)
  • SCOPE_DESC — VARCHAR2(256)

OAUTH_SCOPE_GROUP

  • GROUP_ID — VARCHAR2(128) — Primary key — NOT NULL
  • GROUP_NAME — VARCHAR2(128)
  • SEQ_SCOPE — NUMBER — Foreign key → OAUTH_SCOPE.SEQ_SCOPE — NOT NULL

OAUTH_TOKEN_POLICY

  • TOKEN_POLICY_ID — VARCHAR2(256) — Primary key — NOT NULL
  • ACCESSTOKEN_LENGTH — NUMBER
  • ACCESSTOKEN_LIFETIME — NUMBER
  • ACCESSTOKEN_LIFETIME_EXTENSION_POLICY — BOOLEAN — 토큰 검사시마다 토큰수명 재설정 여부
  • ACCESS_TOKEN_MAXIMUN_LIFETIME — NUMBER — 단위는 분
  • ACCESSTOKEN_LIFETIME_EXTENSION_THRESHOLD_PERCENTAGE — NUMBER — 토큰 수명값이 설정값 미만이 될때까지 토큰수명 연장 안함
  • TOKEN_HASH_ALGORITHM — NUMBER — 1: sha256 2: sha 512