class Mission(db.Model): id = db.Column(db.Integer, primary_key=True) created_at = db.Column(db.DateTime, default=datetime.utcnow, index=True) name = db.Column(db.String(30)) unit = db.Column(db.String(10)) total_missions = db.Column(db.Integer) start_at = db.Column(db.DateTime, index=True) end_at = db.Column(db.DateTime, index=True) total_days = db.Column(db.Integer) # daily plan mission daily_missions = db.Column(db.Integer) # daily plan minutes daily_times = db.Column(db.Integer) total_times = db.Column(db.Integer) total_used_times = db.Column(db.Integer, default=0) # current completed mission completed_missions = db.Column(db.Integer, default=0) # is_completed: 1 yes, 0 no is_completed = db.Column(db.Integer, default=0) # status = db.Column(db.Integer, default=1) # (1 show, 0 hide) in index.html is_show = db.Column(db.Integer, default=1) summary = db.Column(db.TEXT, default='') plan_id = db.Column(db.Integer, db.ForeignKey('plan.id')) plan = db.relationship('Plan', back_populates='missions') logs = db.relationship('MissionLog', back_populates='mission')
class Item(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.Text) done = db.Column(db.Boolean, default=False) author_id = db.Column(db.Integer, db.ForeignKey('user.id')) author = db.relationship('User', back_populates='items')
class Item(db.Model): # print('----', '测试断点2') id = db.Column(db.Integer, primary_key=True) # 主键字段 body = db.Column(db.Text) # 主体字段 done = db.Column(db.Boolean, default=False) # 完成字段 author_id = db.Column(db.Integer, db.ForeignKey('user.id')) # author_id字段 # 通过relationship()函数, 同时通过设置back_populates参数的值为关系另一侧的关系属性名来连接对方。 author = db.relationship('User', back_populates='items') # author字段
class Item(db.Model): id = db.Column(db.Integer, primary_key=True) author_id = db.Column(db.Integer, db.ForeignKey('user.id')) title = db.Column(db.Text) sdate = db.Column(db.String()) stime = db.Column(db.String()) edate = db.Column(db.String()) etime = db.Column(db.String()) author = db.relationship('User', back_populates='items')
class MissionLog(db.Model): id = db.Column(db.Integer, primary_key=True) timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True) log_id = db.Column(db.Integer) completed_mission = db.Column(db.Integer) used_time = db.Column(db.Integer) mission_id = db.Column(db.Integer, db.ForeignKey('mission.id')) mission = db.relationship('Mission', back_populates='logs')
class Plan(db.Model): id = db.Column(db.Integer, primary_key=True) created_at = db.Column(db.DateTime, default=datetime.utcnow, index=True) name = db.Column(db.String(30)) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) category = db.relationship('Category', back_populates='plans') missions = db.relationship('Mission', back_populates='plan')
class Item(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.Text) done = db.Column(db.Boolean, default=False) author_id = db.Column(db.Integer, db.ForeignKey('user.id'))