前提:
class Orderstate(enum.Enum):
UNSOLVED = 0 # 未解决
HANDING = 1 # 处理中
SOLVED = 2 # 已经解决
BACK = 4 # 待定
class Workorder(db.Model,BaseModel):
__tablename__ = 'workorder'
id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='工单id')
clientcoreinfo = db.Column(db.String(50), nullable=False, comment='客户核心信息')
clientbackinfo = db.Column(db.String(60), nullable=True, comment='客户备注信息')
problemdescrip = db.Column(db.String(60), nullable=False, comment='问题描述')
backinfo = db.Column(db.String(50), nullable=True, comment='工单备注')
product_id = db.Column(db.Integer, db.ForeignKey('product.id'), comment='对应产品')
category_id = db.Column(db.Integer, db.ForeignKey('productcategory.id'), comment='对应分类')
state = db.Column(db.Enum(Orderstate), default=Orderstate.UNSOLVED, comment='处理状态')
create_time = db.Column(db.DateTime, default=datetime.now, comment='创建时间')
update_time = db.Column(db.DateTime, default=datetime.now, comment='修改时间')
class Orderstate(enum.Enum):