class test_pdf(Base): """ 算法测试用: 需要下载的pdf """ __tablename__ = "test_pdf" isdelete = Column(Boolean, default=False, comment='是否删除') createtime = Column(DateTime, default=datetime.now, comment='创建时间') updatetime = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') test_id = Column(String(64), primary_key=True) pdf_url = Column(String(255), comment="pdf的url") pdf_path = Column(String(255), comment="pdf下载路径") page_list = Column(Text, comment="前端的json") test_status = Column(String(10), comment="300501待下载300502已下载") test_use = Column(String(10), comment="pdf用途") test_sheet = Column(LONGTEXT, comment="需要返回的json")
class j_role(Base): """ 用户组织关联 """ __tablename__ = "j_role" id = Column(String(32), primary_key=True) manager_id = Column(String(32), nullable=False, comment="用户id") org_id = Column(String(32), nullable=False, comment="组织id") role_type = Column(String(10), comment="角色类型") course = Column(String(11), comment="教师科目类型") create_time = Column(DateTime, comment="创建时间") update_time = Column(DateTime, comment="更新时间")
class j_answer_sheet(Base): """ 答题卡 """ __tablename__ = "j_answer_sheet" id = Column(String(32), primary_key=True) paper_id = Column(String(32), nullable=False, comment="试卷id") json = Column(Text, comment="答题卡json") create_time = Column(DateTime, comment="创建时间") update_time = Column(DateTime, comment="更新时间") name = Column(Text, comment="答题卡名") url = Column(Text, comment="答题卡链接")
class j_school_network(Base): """ 学校设备管理 """ __tablename__ = "j_school_network" isdelete = Column(Boolean, default=False, comment='是否删除') createtime = Column(DateTime, default=datetime.now, comment='创建时间') updatetime = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') net_id = Column(String(64), primary_key=True) net_ip = Column(String(20), nullable=False, comment="固定网段") school_name = Column(String(255), nullable=False, comment="学校名称") school_position = Column(String(255), comment="设备备注")
class j_answer_upload(Base): """ 上传记录 """ __tablename__ = "j_answer_upload" is_delete = Column(Boolean, default=False, comment='是否删除') create_time = Column(DateTime, default=datetime.now, comment='创建时间') update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') id = Column(String(64), primary_key=True) upload_by = Column(String(255), comment="上传人") status = Column(String(10), nullable=False, comment="上传中/待分配/已分配/分配中/文件错误") url = Column(String(255), comment="上传地址")
class j_paper(Base): """ 试卷 """ __tablename__ = "j_paper" id = Column(String(32), primary_key=True) name = Column(String(32), nullable=False, comment="试卷名") subject = Column(String(32), comment="学科") grade = Column(String(32), comment="总分") type = Column(String(1), comment="试卷类型") doc_url = Column(Text, comment="文档链接") answer_doc_url = Column(Text, comment="答案文档链接") encode_tag = Column(String(1), comment="解析标记") last_encode_time = Column(DateTime, comment="上次解析时间") sheet_id = Column(String(32), comment="答题卡id") create_time = Column(DateTime, comment="创建时间") update_time = Column(DateTime, comment="更新时间") upload_by = Column(String(32), comment="上传人id") year = Column(String(32), comment="年级") publish_name = Column(String(32), comment="出版社名称") edition_name = Column(String(32), comment="版册名") allocate_type = Column(String(1), comment="上传人是否是班主任或者教师")
class j_student(Base): """ 学生 """ __tablename__ = "j_student" id = Column(String(32), primary_key=True) name = Column(String(32), nullable=False, comment="姓名") student_number = Column(String(32), comment="学号") sex = Column(Integer, comment="性别") org_id = Column(String(32), nullable=False, comment="组织id") phone = Column(String(32), comment="预留手机号") free_number = Column(Integer, nullable=False, comment="免费次数") free_duration = Column(DateTime, nullable=False, comment="免费时长") head_image = Column(String(128), comment="头像") create_time = Column(DateTime, comment="创建时间") update_time = Column(DateTime, comment="更新时间") status = Column(Integer, comment="用户状态") qq_number = Column(String(13), comment="QQ号")
class j_question(Base): """ 题目 """ __tablename__ = "j_question" id = Column(String(32), primary_key=True) paper_id = Column(String(32), comment="试卷id") subject = Column(String(32), comment="学科") content = Column(Text, comment="题干") answer = Column(Text, comment="答案") explanation = Column(Text, comment="题目解析") question_number = Column(String(10), comment="题号") type = Column(String(10), comment="题型") score = Column(Integer, comment="总分") knowledge = Column(Text, comment="考点") create_time = Column(DateTime) update_time = Column(DateTime) url = Column(Text)
class j_answer_booklet(Base): """ 答卷 """ __tablename__ = "j_answer_booklet" id = Column(String(64), primary_key=True) paper_id = Column(String(32), nullable=False, comment="试卷id") student_id = Column(String(32), comment="学生id") status = Column(String(10), comment="批阅状态") score = Column(Integer, comment="总得分") grade_time = Column(DATE, comment="批阅完成时间") create_time = Column(DATE, comment="创建时间") update_time = Column(DATE, comment="更新时间") url = Column(Text, comment="oss链接") upload_by = Column(String(32), comment="上传人") grade_num = Column(Integer, comment="已批阅数目") upload_id = Column(String(64), comment="答卷上传记录id") is_miss = Column(String(10), comment="是否缺考301缺考302未缺考") upload_byid = Column(String(64), comment="上传人id") school_name = Column(String(128), comment="所属学校") school_id = Column(String(64), comment="学校id") grade_id = Column(String(64), comment="年级id") class_id = Column(String(64), comment="班级id") grade_name = Column(String(128), comment="年级名称") class_name = Column(String(128), comment="班级名称")
class j_answer_pdf(Base): """ 答卷pdf """ __tablename__ = "j_answer_pdf" isdelete = Column(Boolean, default=False, comment='是否删除') createtime = Column(DateTime, default=datetime.now, comment='创建时间') updatetime = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') pdf_id = Column(String(64), primary_key=True) zip_id = Column(String(64), comment="答卷zip,可空,存在大量的来自扫描仪文件") pdf_use = Column(String(10), nullable=False, comment="300201先批后扫300202先扫后批") paper_name = Column(String(255), nullable=False, comment="试卷名") sheet_dict = Column(Text, comment="答题卡json") pdf_status = Column(String(10), comment="300301未解析300302已解析300303解析失败300304解析中") pdf_url = Column(String(255), comment="pdf地址") pdf_address = Column(Text, comment="pdf原始地址") pdf_ip = Column(String(20), comment="pdf上传ip") pdf_school = Column(String(255), comment="pdf上传学校") upload_id = Column(String(64), comment="上传记录id") pdf_index = Column(Integer, comment="pdf页码") pdf_path = Column(String(255), comment="pdf暂存路径") jpg_dir = Column(LONGTEXT, comment="jpg路徑")
class j_manager(Base): """ 账号 """ __tablename__ = "j_manager" id = Column(String(32), primary_key=True) name = Column(String(128), nullable=False, comment="姓名") nick_name = Column(String(32), comment="昵称") teacher_number = Column(String(32), comment="工号") phone = Column(String(128), comment="手机号") password = Column(String(128), nullable=False, comment="密码") sort = Column(String(32), nullable=False, comment="排序") openid = Column(String(32), comment="微信openid") head_image = Column(String(32), comment="头像") create_time = Column(DateTime, comment="创建时间") update_time = Column(DateTime, comment="更新时间") status = Column(Boolean, comment="用户状态0冻结1正常") last_login_time = Column(DateTime) structures = Column(String(255))
class j_answer_png(Base): """ 答卷裁剪识别图 """ __tablename__ = "j_answer_png" isdelete = Column(Boolean, default=False, comment='是否删除') createtime = Column(DateTime, default=datetime.now, comment='创建时间') updatetime = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') png_id = Column(String(64), primary_key=True) png_url = Column(String(255), comment="图片url") pdf_id = Column(String(64), comment="扫描件id") jpg_id = Column(String(64), comment="扫描件单页id") png_result = Column(String(255), comment="解析结果") png_status = Column(String(10), comment="303待处理302已处理301已批阅304待批阅") png_type = Column( String(10), comment="21单选22多选23判断24填空all25填空ocr26简答all27简答ocr28sn29考号") question = Column(Text, comment="题目") booklet_id = Column(String(64), comment="答卷id") page_url = Column(String(255), comment="该页面url") student_no = Column(String(20), comment="学生考号") student_no_id = Column(String(255), comment="学生考号对应的图片id") student_name = Column(String(255), comment="学生姓名") school = Column(String(255), comment="学校名称") result_score = Column(Integer, comment="考卷分数", default=0) result_update = Column(Integer, comment="考卷分数订正", default=0) score_id = Column(String(64), comment="答题id")
class j_answer_jpg(Base): """ 答卷单页 """ __tablename__ = "j_answer_jpg" isdelete = Column(Boolean, default=False, comment='是否删除') createtime = Column(DateTime, default=datetime.now, comment='创建时间') updatetime = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') jpg_id = Column(String(64), primary_key=True) pdf_id = Column(String(64), comment="关联pdf的id") pdf_index = Column(Integer, comment="pdf总页码") jpg_status = Column(String(10), comment="300401未解析300402已解析300404解析失败") jpg_dict = Column(LONGTEXT, comment="算法返回的json") jpg_index = Column(Integer, comment="页码") jpg_url = Column(String(255), comment="jpg的url") jpg_log_path = Column(String(255), comment="算法返回的json存储地址") page_dict = Column(LONGTEXT, comment="传入算法的json") page_path = Column(Text, comment="传入算法的图片本地路径")
class j_answer_booklet(Base): """ 答卷 """ __tablename__ = "j_answer_booklet" id = Column(String(32), primary_key=True) paper_id = Column(String(32), nullable=False, comment="试卷id") student_id = Column(String(32), comment="学生id") status = Column(String(10), comment="批阅状态") score = Column(Integer, comment="总得分") grade_time = Column(DATE, comment="批阅完成时间") create_time = Column(DATE, comment="创建时间") update_time = Column(DATE, comment="更新时间") url = Column(Text, comment="oss链接") upload_by = Column(String(32), comment="上传人id") grade_num = Column(Integer, comment="已批阅数目")
class j_organization(Base): """ 组织表 """ __tablename__ = "j_organization" id = Column(String(32), primary_key=True) name = Column(String(32), nullable=False, comment="组织名称") sort = Column(Integer, nullable=False, comment="序号") parent_org_id = Column(String(32), nullable=False, comment="上级组织id") role_type = Column(String(10), nullable=False, comment="角色类型") description = Column(String(512), comment="描述") area_id = Column(Integer, comment="区域id") joint_name_one = Column(String(128), comment="冗余级联名称省市区学校") joint_name_two = Column(String(128), comment="冗余级联名称年级班") status = Column(Integer, comment="组织状态0删除1开启", nullable=False) parent_org = Column(String(255))
class j_score(Base): """ 答卷题目 """ __tablename__ = "j_score" id = Column(String(32), primary_key=True) student_id = Column(String(32), comment="学生id") booklet_id = Column(String(32), nullable=False, comment="答卷id") question_id = Column(String(32), comment="题目id") score = Column(Integer, comment="得分") question_url = Column(Text, comment="答题图片url") grade_by = Column(String(32), comment="批阅人id") create_time = Column(DateTime, comment="创建时间") update_time = Column(DateTime, comment="更新时间") question_number = Column(Integer, comment="所在试卷的编号") answer = Column(String(16), comment="学生答案")
class j_answer_zip(Base): """ 答卷zip """ __tablename__ = "j_answer_zip" isdelete = Column(Boolean, default=False, comment='是否删除') createtime = Column(DateTime, default=datetime.now, comment='创建时间') updatetime = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间') zip_id = Column(String(64), primary_key=True) zip_url = Column(String(255), comment="zip地址", nullable=False) zip_upload_user = Column(String(255), comment="上传人", default="system") zip_upload_userid = Column(String(64), comment="上传人id") zip_status = Column(String(10), comment="300101未解析300102已解析300103解析失败") zip_ip = Column(String(20), comment="上传ip") zip_paper = Column(String(255), comment="zip对应的考卷") zip_use = Column(String(10), nullable=False, comment="300201先批后扫300202先扫后批")