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)