YES-25.5-Authority

Tables (3)

TokenInfo

  • id — BIGINT — Primary key — NOT NULL — Auto_Increment
  • uuid — VARCHAR — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • role — VARCHAR — NOT NULL
  • login_state_name — VARCHAR — NOT NULL
  • refresh_token — VARCHAR — NOT NULL
  • create_at — TIMESTAMP — NOT NULL
  • update_at — TIMESTAMP

token_info (Token)

  • id — BIGINT — Primary key — NOT NULL — Auto_increment
  • uuid — VARCHAR — NOT NULL — FK
  • refresh_token — VARCHAR — NOT NULL
  • expiry_date — TIMESTAMP — NOT NULL

user_info (UserInfo)

  • uuid — VARCHAR — NOT NULL — FK
  • customer_id — BIGINT — NOT NULL
  • role — VARCHAR — NOT NULL
  • login_state_name — VARCHAR — NOT NULL