class Usage(db.Model): __tablename__ = 'Usage' id = db.Column(db.Integer, primary_key=True) # id(主键) user_name = db.Column(db.String(50), db.ForeignKey('User.username')) # 用户名 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 进程对应的课程 gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # gpu name submit_num = db.Column(db.Integer, default=0) # 总提交进程数 last_time = db.Column(db.DateTime, default=datetime.utcnow) # 最后一次提交进程的时间
class Process(db.Model): __tablename__ = 'Process' id = db.Column(db.Integer, primary_key=True) # id(主键) name = db.Column(db.String(50)) # 程序的名称 info = db.Column(db.String(300)) # 程序的信息 state = db.Column(db.String(50)) # 是否运行完成 result = db.Column(db.String(1000)) # 程序的结果 code = db.Column(db.String(10000)) # 存储代码,方便以后编辑代码 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 程序所属的课程 gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # 程序在哪个gpu上跑的
class Course(db.Model): __tablename__ = 'Course' id = db.Column(db.Integer, primary_key=True) # id(主键) name = db.Column(db.String(50)) # 课程名称 teacher = db.Column(db.String(50)) # 任课老师 time = db.Column(db.String(50)) # 授课时间(学年、学期) info = db.Column(db.String(300)) # 课程其他信息 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 用户对应的课程 gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # gpu name pic_path = db.Column(db.String(128), default="/static/pic/course_logo.png") # 课程头像
class Message(db.Model): __tablename__ = 'Message' id = db.Column(db.Integer, primary_key=True) # id(主键) course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 消息对应的课程 title = db.Column(db.String(50)) # 消息的标题 info = db.Column(db.String(1000)) # 消息的内容
class GPU(db.Model): __tablename__ = 'GPU' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) # gpu的名称 info = db.Column(db.String(1000)) # gpu是否空闲 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # gpu对应的课程
class Articles(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(20)) # 博文名称 content = db.Column(db.String(50000)) # 博文内容 author = db.Column(db.String(20)) # 作者 pubdate = db.Column(db.DateTime, default=datetime.datetime.now) # 创建时间 updated = db.Column(db.DateTime, default=datetime.datetime.now, onupdate=datetime.datetime.now) # 更新时间 user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class Ariticles(db.Model): id = db.Column(db.Integer, primary_key=True) # 主键 title = db.Column(db.String(60)) content = db.Column(db.Text, nullable=False) author_id = db.Column(db.Integer, db.ForeignKey(User.id), default=1, nullable=False) pubdate = db.Column(db.DateTime, default=datetime.now, nullable=False)
class arXivEmail(db.Model): # 表名将会是 email(自动生成,小写处理) id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 主键 email = db.Column(db.String(50), db.ForeignKey('user.email')) # 邮箱, 设置外键 keyword = db.Column(db.Text()) # 关键字 author = db.Column(db.Text()) # 作者 subjectcategory = db.Column(db.Text(), nullable=False) # 主题 period = db.Column(db.Integer(), nullable=False) # 检测时段 lastTracktime = db.Column(db.DateTime, default=datetime.datetime.now, nullable=False)
class Process(db.Model): __tablename__ = 'Process' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) # 程序的名称 info = db.Column(db.String(300)) # 程序的信息 result = db.Column(db.String(1000)) # 程序的结果 code = db.Column(db.String(10000)) # 存储代码,方便以后编辑代码 gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # 程序在哪个gpu上跑的
class Process_stu(db.Model): __tablename__ = 'Process_stu' id = db.Column(db.Integer, primary_key=True) # id(主键) user_name = db.Column(db.String(50), db.ForeignKey('User.username')) # 存储用户名 process_name = db.Column(db.String(50), db.ForeignKey('Process.name')) # 程序的名称
class GPU_course(db.Model): __tablename__ = 'GPU_course' id = db.Column(db.Integer, primary_key=True) # id(主键) gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # gpu name course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 用户对应的课程
class Relation(db.Model): __tablename__ = 'Relation' id = db.Column(db.Integer, primary_key=True) # id(主键) user_name = db.Column(db.String(50), db.ForeignKey('User.username')) # 存储用户名 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 用户对应的课程
class Article(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(60)) content = db.Column(db.String()) author_id = db.Column(db.Integer, db.ForeignKey(User.id)) user = db.relationship('User', back_populates='article')
class Movie(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(60)) year = db.Column(db.String(4)) user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class Articles(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50)) content = db.Column(db.Text) pubdate = db.Column(db.String(30)) author_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))