users.py

UserStatusType = create_named_tuple(
    'Active', 'Disabled')
    
    class Users(db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    login_id = db.Column(db.String(64), unique=True, nullable=False)
    account_id = db.Column(db.String(32), nullable=False)
    status = db.Column(db.Enum(*UserStatusType._asdict().values(), name='status_type'))
    project_id = db.Column(db.Integer, db.ForeignKey('projects.id', ondelete='RESTRICT'))