k-solar
테이블 (7)
Clien토큰테이블 (OAUTH_CLIENT_TOKEN)
- token_id — VARCHAR(256)
- token — MEDIUMBLOB
- authentication_id — MEDIUMBLOB
- user_name — VARCHAR(256)
- client_id — VARCHAR(256)
Oauth2 사용자정보 (OAUTH_CLIENT_DETAILS)
- client_id — VARCHAR(256) — 기본 키 — NOT NULL
- resource_ids — MEDIUMBLOB
- client_secret — VARCHAR(256)
- scope — VARCHAR(256)
- authorized_grant_types — VARCHAR(256)
- web_server_redirect_uri — VARCHAR(256)
- authorities — VARCHAR(256)
- access_token_validity — INT(11)
- refresh_token_validity — INT(11)
- additional_information — VARCHAR(4096)
- autoapprove — VARCHAR(256)
Refresh토큰테이블 (OAUTH_REFRESH_TOKEN)
- token_id — VARCHAR(256) — Refresh토큰ID
- token — VARCHAR(256) — Refresh토큰
- authentication — VARCHAR(256)
oauth발급정보 (OAUTH_APPROVALS)
- userid — VARCHAR(256)
- clientid — VARCHAR(256)
- scope — VARCHAR(256)
- status — VARCHAR(10)
- expiresat — TIMESTAMP
- lastmodifiedat — TIMESTAMP
사용자정보 (CLIENTDETAILS)
- appid — VARCHAR(256) — 기본 키 — NOT NULL
- resourceids — VARCHAR(256)
- appsecret — VARCHAR(256)
- scope — VARCHAR(256)
- granttypes — VARCHAR(256)
- redirecturl — VARCHAR(256)
- authorities — VARCHAR(256)
- access_token_validify — INT(11)
- refresh_token_validify — INT(11)
- additionalinforamtion — VARCHAR(4096)
- autoapprovescopes — VARCHAR(256)
인증 (OAUTH_CODE)
- code — VARCHAR(256)
- authentication — MEDIUMBLOB
접근권한테이블 (ACCESS_TOKEN)
- authentication_id — VARCHAR(256) — 기본 키 — NOT NULL
- token — MEDIUMBLOB
- token_id — VARCHAR(256) — NOT NULL
- user_name — VARCHAR(256)
- client_id — VARCHAR(256)
- authentication — MEDIUMBLOB
- refresh_token — VARCHAR(256)