models.py 1.6 KB

1234567891011121314151617181920212223242526272829
  1. from datetime import datetime
  2. from ..extentions import db
  3. class AnalysisTask(db.Model):
  4. __tablename__ = 'analysis_task'
  5. id = db.Column(db.Integer, primary_key=True, autoincrement=True)
  6. file_key = db.Column(db.Text, comment="文件唯一哈希")
  7. file_name = db.Column(db.Text, comment="文件名称")
  8. task_type = db.Column(db.String(128), comment="任务类型")
  9. is_ocr = db.Column(db.Boolean, default=False, comment="是否ocr")
  10. status = db.Column(db.Integer, default=0, comment="状态") # 0 running 1 finished 2 pending
  11. analysis_pdf_id = db.Column(db.Integer, comment="analysis_pdf的id")
  12. create_date = db.Column(db.DateTime(), nullable=False, default=datetime.now)
  13. update_date = db.Column(db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now)
  14. class AnalysisPdf(db.Model):
  15. __tablename__ = 'analysis_pdf'
  16. id = db.Column(db.Integer, primary_key=True, autoincrement=True)
  17. file_name = db.Column(db.Text, comment="文件名称")
  18. file_url = db.Column(db.Text, comment="文件原路径")
  19. file_path = db.Column(db.Text, comment="文件路径")
  20. status = db.Column(db.Integer, default=3, comment="状态") # 0 转换中 1 已完成 2 转换失败 3 init
  21. bbox_info = db.Column(db.Text, comment="坐标数据")
  22. md_link_list = db.Column(db.Text, comment="markdown分页链接")
  23. full_md_link = db.Column(db.Text, comment="markdown全文链接")
  24. create_date = db.Column(db.DateTime(), nullable=False, default=datetime.now)
  25. update_date = db.Column(db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now)