gistfile1.txt

class CheckIn(db.Model):
    __tablename__ = 'checkins'
    
    id = db.Column(db.Integer, primary_key=True)
    location_id = db.Column(db.Integer)
    user_id = db.Column(db.Integer)
    date = db.Column(db.DateTime)

    def to_dict(self):
        return{
            'date':self.date,
            'location': Location.query.get(self.location_id),
            'user': User.query.get(self.user_id),
    
    }