Authentication

StudyAP utilizes Mailgun for a simple user login system.

Overview

1. Login screen: a single email input box, inputting an email will prompt you to enter a verification code sent to the email given.
2. Pending verification row is inserted (verification code + token + userEmail)
3. When verification code is entered, search for pending verification row, if found return token and insert active token row (token + userEmail + expiresAt), if user with userEmail not found, insert new user.