class UserToken(db.Model):
__tablename__ = 'user_tokens'
token_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
user_token = db.Column(db.String(100), nullable=False)
device_id = db.Column(db.String(200), nullable=False)
class Friendship(db.Model):
__tablename__ = 'friendships'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
friend_id = db.Column(db.Integer, nullable=False)
datetime_added = db.Column(db.DateTime, nullable=False)
class PrivacySettings(db.Model):
__tablename__ = 'privacy_settings'
user_id = db.Column(db.Integer, primary_key=True)
duels_invites_from = db.Column(db.String(1), nullable=False, default='f')
show_in_ratings = db.Column(db.Boolean, nullable=False, default=True)
profile_is_visible = db.Column(db.Boolean, nullable=False, default=True)
class FirebaseToken(db.Model):
__tablename__ = 'firebase_tokens'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
token = db.Column(db.String(200), nullable=False)
device_id = db.Column(db.String(200), nullable=False)
class Notification(db.Model):
__tablename__ = 'notifications'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
id_user_from = db.Column(db.Integer, nullable=True)
notification_type = db.Column(db.String(10), nullable=False)
datetime_sent = db.Column(db.DateTime, nullable=False)
class User(db.Model):
__tablename__ = 'users'
user_id = db.Column(db.Integer, primary_key=True)
user_email = db.Column(db.String(100), nullable=False)
user_password = db.Column(db.String(200), default=None)
user_type = db.Column(db.String(1), nullable=False)
datetime_added = db.Column(db.DateTime, nullable=False)
class InterestingLike(db.Model):
__tablename__ = 'interesting_likes'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=True)
interesting_number = db.Column(db.Integer, nullable=False)
like_it = db.Column(db.Boolean, nullable=False)
class ExerciseReport(db.Model):
EXERCISE_MISTAKE = 1
CANT_UNDERSTAND = 2
ANSWER_IS_CORRECT = 3
ANSWER_IS_INCORRECT = 4
__tablename__ = 'exercises_reports'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=True)
exercise_number = db.Column(db.Integer, nullable=False)
bug_type = db.Column(db.Integer, nullable=False)
class UserStatistics(db.Model):
__tablename__ = 'users_statistics'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
datetime = db.Column(db.DateTime, nullable=False)
obtained_XP = db.Column(db.Integer, nullable=False, default=0)
time_spent = db.Column(db.Integer, nullable=False, default=0)
completed_exercises = db.Column(db.Integer, nullable=False, default=0)
completed_trainings = db.Column(db.Integer, nullable=False, default=0)
obtained_achievements = db.Column(db.Integer, nullable=False, default=0)
completed_chapters = db.Column(db.Integer, nullable=False, default=0)
days_streak = db.Column(db.Integer, nullable=False, default=0)
class User(db.Model):
"""Create user database fields
Fields:
id -- provides each row entry with a unique id.
student_number -- store users 7 character student number (e.g 1342556).
email -- store users UOB email (e.g [email protected]).
faculty -- store users faculty (e.g Engineering).
password_hash -- store sha256 hash of users password.
"""
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(7), unique=True,
nullable=False) # eg: 'ab12345'
email = db.Column(db.String(21), unique=True,
nullable=False) # eg: '*****@*****.**'
faculty = db.Column(db.String(25), nullable=False) # eg: 'Engineering'
password_hash = db.Column(
db.String(128), nullable=False) # Hash of the users password
class Achievement(db.Model):
NO_LEVEL = 0
LEVEL_DONE = 1
LEVEL_BRONZE = 1
LEVEL_SILVER = 2
LEVEL_GOLD = 3
LEVEL_DIAMOND = 4
TYPE_STREAK = 1
TYPE_EXERCISES = 2
TYPE_TRAININGS = 3
TYPE_CHAPTERS = 4
TYPE_FRIEND_ADD = 5
TYPE_SET_AVATAR = 6
TYPE_SET_BIO = 7
TYPE_SET_NAME = 8
__tablename__ = 'achievements'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
type = db.Column(db.Integer, nullable=False)
level = db.Column(db.Integer, nullable=True)
class FriendshipRequest(db.Model):
__tablename__ = 'friendship_requests'
request_id = db.Column(db.Integer, primary_key=True)
requesting_id = db.Column(db.Integer, nullable=False)
recipient_id = db.Column(db.Integer, nullable=False)
class PrivacyDuelsException(db.Model):
__tablename__ = 'privacy_duels_exceptions'
record_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, nullable=False)
exception_id = db.Column(db.Integer, nullable=False)
class UserData(db.Model):
__tablename__ = 'users_data'
user_id = db.Column(db.Integer, primary_key=True)
user_public_id = db.Column(db.String(36), nullable=False)
user_name = db.Column(db.String(25), nullable=False)
bio = db.Column(db.String(150), default=None)
name = db.Column(db.String(30), nullable=False)
avatar_link = db.Column(db.String(100))
current_level = db.Column(db.Integer, default=1)
current_level_XP = db.Column(db.Integer, default=0)
streak_days = db.Column(db.Integer, default=0)
subscribed = db.Column(db.Boolean, default=0)
streak_datetime = db.Column(db.DateTime, default=datetime(1900, 1, 1))
completed_parts = db.Column(db.JSON, default=[0, 0, 0, 0])
notifications_are_checked = db.Column(db.Boolean, default=1)