class Profile(db.Model):
__tablename__ = "profiles"
user_id = db.Column(db.BIGINT, primary_key=True)
friend_code = db.Column(db.Text, default="Not Set")
user_name = db.Column(db.Text, default="Not Set")
timezone = db.Column(db.Text)
class User(db.Model):
__tablename__ = "users"
id = db.Column(db.BIGINT, primary_key=True)
level = db.Column(db.Integer, default=0)
xp = db.Column(db.BIGINT, default=0)
times_hosted = db.Column(db.BIGINT, default=0)
class Raid(db.Model):
__tablename__ = "raids"
id = db.Column(db.BIGINT, primary_key=True)
guild_id = db.Column(db.BIGINT, db.ForeignKey("guilds.id"))
pokemon = db.Column(db.Text)
shiny = db.Column(db.Boolean)
gmax = db.Column(db.Boolean)
host_id = db.Column(db.BIGINT)
class Level(db.Model):
__tablename__ = "levels"
set_level = db.Column(db.BIGINT, primary_key=True)
set_xp = db.Column(db.BIGINT)
class Guild(db.Model):
__tablename__ = "guilds"
id = db.Column(db.BIGINT, primary_key=True)
prefix = db.Column(db.Text)