otp2

Tables (3)

go_domain_admins

  • id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_logined_at — TIMESTAMP
  • page_base — INTEGER
  • company_id — BIGINT
  • user_id — BIGINT
  • otp_admin_id (Key) — Foreign key → go_otpadmins.id — NOT NULL

go_otp_devices

  • id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • cert_time — BIGINT
  • auth_code — VARCHAR(20)
  • auth_code_generated_at — TIMESTAMP
  • device_id — VARCHAR(50)
  • os_type — VARCHAR(20)
  • device_model — VARCHAR(128)
  • regist_code — VARCHAR(20)
  • registered_at — TIMESTAMP
  • company_id — BIGINT
  • user_id — BIGINT
  • auth_type — VARCHAR(32) — NOT NULL

go_otpadmins

  • id (Key) — Primary key — NOT NULL
  • mail_user_id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • external_email — VARCHAR(255)
  • email_auth_key — VARCHAR(255)
  • reset_auth_key — VARCHAR(255)
  • certification_validity_time — TIMESTAMP
  • verification_time — TIMESTAMP
  • last_otp_auth_time — TIMESTAMP
  • is_email_verified — BOOLEAN — NOT NULL
  • auth_type — VARCHAR(32)
  • used — BOOLEAN — NOT NULL