oauth
Tables (9)
authorization_code (Untitled3)
- authorization_code (Key) — varchar(100) — Primary key — NOT NULL
- expires_at (Field) — datetime
- redirect_uri (Field2) — varchar(200)
- client_seq (Key2) — int — Foreign key → client.client_seq — NOT NULL
- user_seq (Key3) — int — Foreign key → user.user_seq — NOT NULL
authorization_code_scope (Untitled6)
- authorization_code_scope (Key) — varchar(20) — Foreign key → authorization_code.authorization_code — NOT NULL
- authorization_code (Field) — varchar(100)
client (Untitled)
- client_seq (Key) — int — Primary key — NOT NULL
- client_id (Field2) — varchar(50)
- client_secret (Field3) — varchar(50)
client_grant (Untitled5)
- client_seq (Key) — int — Foreign key → client.client_seq — NOT NULL
- client_grant (Field) — varchar(50)
client_redirect_uri (Untitled4)
- client_seq (Key) — int — Foreign key → client.client_seq — NOT NULL
- redirect_uri (Field) — varchar(200)
client_scope (Untitled8)
- client_seq (Key) — int — Foreign key → client.client_seq — NOT NULL
- client_scope (Field) — varchar(20)
token (Untitled7)
- access_token (Key) — varchar(50) — Primary key — NOT NULL
- access_token_expires_at (Field) — datetime
- refresh_token (Field2) — varchar(50)
- refresh_token_expires_at (Field3) — datetime
- client_seq (Key2) — int — Foreign key → client.client_seq — NOT NULL
- user_seq (Key3) — int — Foreign key → user.user_seq — NOT NULL
token_scope (Untitled9)
- access_token (Key) — varchar(50) — Foreign key → token.access_token — NOT NULL
- token_scope (Field) — varchar(20)
user (Untitled2)
- user_seq (Key) — Primary key — NOT NULL
- user_id (Field)
- password (Field2)