28 lines
808 B
Python
28 lines
808 B
Python
from datetime import datetime
|
|
from .. import db
|
|
|
|
|
|
class Report(db.Model):
|
|
__tablename__ = 'Reports'
|
|
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
report = db.Column(db.JSON, nullable=True)
|
|
# # 外键字段（使用驼峰命名）
|
|
sessionId = db.Column(db.Integer, db.ForeignKey(
|
|
'Sessions.id'), nullable=False)
|
|
|
|
# 通用字段
|
|
createdAt = db.Column(db.DateTime, default=datetime.now) # 创建时间
|
|
updatedAt = db.Column(db.DateTime, default=datetime.now,
|
|
onupdate=datetime.now) # 更新时间
|
|
deleteAt = db.Column(db.DateTime, default=None) # 软删除标记
|
|
|
|
def to_dict(self):
|
|
return {
|
|
'id': self.id,
|
|
'report': self.report,
|
|
}
|
|
|
|
def __repr__(self):
|
|
return f'<Report {self.id}>'
|