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