User Auth

• callback "signIn" => if not exist, create DB User & update DB user if exists
• one user-mysql instance for website/bot related things - points etc.
• one user-session instance with the encrypted access-token for interacting with the discord API

Guild Management

• api endpoints for pulling user-guilds and interacting with them

Index = The first page someone sees when opening the Page (both logged in and guests)

• animated background using utf-8 nut emoji (looks different on each platform and hopefully noice)

• login + logout

• I think it'd be nice if there would be a countdown towards the next November and a member count of how many are participating (based on opt-in through website or bot in server)

• a successful login forwards to the user dashboard

Logged Out

• basic information + login button

Logged In

• basic information about the user
• logout button
• guild picker (forwards to guild page, if guild is activated and setup)
• button with user-icon (forwards to user-dashboard)
• maybe change the layout to display the navbar if logged in?

This basically resembles a Discord User (with the discord ID being the primary key) with additional information added to it.

Basic Data

• snowflake : primary_key : integer
• created_at : date
• updated_at : date

Additional Data

• points : integer // used for the points system