class Token(DB.Model): """Token data model""" uid = DB.Column(UUID, primary_key=True, default=uuid.uuid4) token_type = DB.Column(DB.Integer, nullable=False) created_at = DB.Column(DB.DateTime(), nullable=False) valid_until = DB.Column(DB.DateTime(), nullable=False) is_active = DB.Column(DB.Boolean(), nullable=False, server_default='1') user_uid = DB.Column(UUID, DB.ForeignKey('user.uid'), nullable=False) note = DB.Column(DB.String(20), nullable=False, server_default='') user = DB.relationship('User', back_populates='tokens', lazy='select')
class Player(DB.Model): """User data model""" uid = DB.Column(UUID, primary_key=True, default=uuid.uuid4) user_uid = DB.Column(UUID, DB.ForeignKey('user.uid'), nullable=False) steam_id = DB.Column(DB.Integer, nullable=False) name = DB.Column(DB.String(50), nullable=False, unique=True) avatar = DB.Column(DB.String(300), nullable=False, unique=True) avatar_medium = DB.Column(DB.String(300), nullable=False, unique=True) avatar_full = DB.Column(DB.String(300), nullable=False, unique=True) user = DB.relationship('User', back_populates='players', lazy='select')