class CurrentStudentRoster(Base): __tablename__ = 'ss_current' __table_args__ = merge_dicts(base_table_args, {"schema": "matviews"}) site_id = foreignkey(Sites.site_id, primary_key=True) student_id = foreignkey(Students.student_id, primary_key=True) roster_site = relationship("Sites") roster_student = relationship("Students")
def section_id(self): return foreignkey(Sections.section_id)
def course_id(self): return foreignkey(Courses.course_id)
def user_id(self): return foreignkey(Users.user_id)
def room_id(self): return foreignkey(Rooms.room_id)
def site_id(self): return foreignkey(Sites.site_id)
class DailyRecords(Base): __table_args__ = merge_dicts(base_table_args, {'schema': 'attendance'}) student_id = foreignkey(Students.student_id, primary_key=True) attendance_flag_id = foreignkey(AttendanceFlags.attendance_flag_id, primary_key=True) date = Column(Date, primary_key=True)
def student_id(self): return foreignkey(Students.student_id)
def assignment_id(self): return foreignkey(Assignments.assignment_id)
def category_id(self): return foreignkey(Categories.category_id)
def gradebook_id(self): return foreignkey(Gradebooks.gradebook_id)
class Gradebooks(GradebookSchemaMixin, Base): created_by = foreignkey(Users.user_id) user = relationship("Users", backref='gradebook') scores = relationship("OverallScoreCache", backref='gradebook') assignments = relationship("Assignments", backref='gradebook')