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 Internal(DB.Model): """Scheme versions""" uid = DB.Column(UUID, primary_key=True, default=uuid.uuid4) db_version = DB.Column(DB.Integer, nullable=False) rights_version = DB.Column(DB.Integer, nullable=False) updated_at = DB.Column(DB.DateTime())
class User(DB.Model): """User data model""" __tablename__ = 'users' id = DB.Column(DB.Integer, primary_key=True) # pylint: disable=invalid-name steam_id = DB.Column(DB.String(50), nullable=False, unique=True) created_at = DB.Column(DB.DateTime())
class User(DB.Model): """User data model""" uid = DB.Column(UUID, primary_key=True, default=uuid.uuid4) email = DB.Column(DB.String(255), nullable=False, unique=True) password = DB.Column(DB.String(255), nullable=False, server_default='') confirmed_at = DB.Column(DB.DateTime()) gdpr_version = DB.Column(DB.Integer, nullable=False) is_active = DB.Column(DB.Boolean(), nullable=False, server_default='0')