Data Model

User Table

_id(uuid)

email

password

failed_logins

last_login

date_created

locked

number_times_locked

last_update

last_ip

number_of_logins

password_resets

IP Table

_id

User_uuid

ip_address

city

state

country

Profile Table

_id(uuid)

user_uuid

first_name

last_name

address1

address2

city

state

zip

phone_number

date_of_birth

created_date

last_update_date

Paid Tier

_id

user_uuid

tier_level

created_date

last_update_date

Game Table

_id

user_uuid

url_uuid

game_name

number_of_deployments

created_date

Last_update_date

URL

_id

url

digital_ocean

_id

settings_uuid

access_key

Settings Table

_id

user_uuid

game_uuid

platform(do/aws/gcp)

created_date

last_update_date

Scheduling

_id

game_uuid

game_date

game_time

notify_users(bool)

Email Invite Table

_id

game_uuid

email_address

first_name

last_name

timezone

number_of_emails

created_date

last_update_date

Character Table

_id

invitee_uuid

character_name

dndbeyond_charactersheet_url

Notifications

_id

invitees_uuid

notify_date

notify_time