DATABASE

Was müssen wir speichen?

users

• id
• username
• email
• num_credits
• first_name
• last_name
• birth_date
• password
• address
• organization (flag)
• region
• join_date
• email_confirmed (flag)
• totp_secret
• totp_confirmed (flag)
• banned (flag)
• last_security_change
• email_token
• token_requested_time

challenges

• id
• regions
• creator
• title
• description
• team_challenge (flag)
• global (flag)
• begin (timestamp)
• end (timestamp)

prizes

• challenge
• place
• amount

posts

• id
• text
• creator
• media
• awards
• timestamp

teams

• id
• team_name
• challenge

team_members

• user
• team

friends

• user1
• user2

friend_requests

• requester
• requestee

feedback

• post
• user
• type (like oder dislike)

post_comment

• id
• user
• post
• timestamp
• text

//TODO Chashback

Funktionen für die Api

getUser updateUser tryCreateUser createChallenge updateChallenge getChallenge getPost createTeam joinTeam addFreinds friendRequest addPostFeedback addPostComment

Routen zur Datenbank-API

getUser mit id => http://10.3.141.1/api/getUser:id get