class Attendance_Year(db.Model): __tablename__ = 'attendance_years' id = db.Column(db.Integer, primary_key=True) # month= db.Column(db.Integer, nullable= False) dbn = db.Column(db.String, nullable=False) year = db.Column(db.Integer, nullable=False) roster = db.Column(db.Integer, nullable=False) total_absent = db.Column(db.Integer, nullable=False) total_present = db.Column(db.Integer, nullable=False) school = db.relationship('School', back_populates='attendance_years') school_id = db.Column(db.Integer, db.ForeignKey('schools.id'), nullable=False) # grade_9 = db.relationship('Grade_9', back_populates= 'attendance_year') # grade_10 = db.relationship('Grade_10', back_populates= 'attendance_year') # grade_11 = db.relationship('Grade_11', back_populates= 'attendance_year') # grade_12 = db.relationship('Grade_12', back_populates= 'attendance_year') grade_9_absent = db.Column(db.Integer) grade_9_present = db.Column(db.Integer) grade_10_absent = db.Column(db.Integer) grade_10_present = db.Column(db.Integer) grade_11_absent = db.Column(db.Integer) grade_11_present = db.Column(db.Integer) grade_12_absent = db.Column(db.Integer) grade_12_present = db.Column(db.Integer)
class Culture(db.Model): __tablename__ = 'cultures' id = db.Column(db.Integer, primary_key=True) sc_1_4 = db.Column(db.Integer, nullable=False) sc_3_4 = db.Column(db.Integer, nullable=False) rating = db.relationship('Rating', back_populates='culture') rating_id = db.Column(db.Integer, db.ForeignKey('ratings.id'), nullable=False)
class Improvement(db.Model): __tablename__ = 'improvements' id = db.Column(db.Integer, primary_key=True) si_1_3 = db.Column(db.Integer, nullable=False) si_3_1 = db.Column(db.Integer, nullable=False) si_4_1 = db.Column(db.Integer, nullable=False) si_5_1 = db.Column(db.Integer, nullable=False) rating = db.relationship('Rating', back_populates='improvement') rating_id = db.Column(db.Integer, db.ForeignKey('ratings.id'), nullable=False)
class SchoolSAT(db.Model): __tablename__ = 'school_sats' id = db.Column(db.Integer, primary_key=True) year = db.Column(db.String, nullable=False) dbn = db.Column(db.String, nullable=False) math_avg = db.Column(db.Integer, nullable=False) reading_avg = db.Column(db.Integer, nullable=False) # overall_avg = db.Column(db.Integer, nullable=False) writing_avg = db.Column(db.Integer, nullable=False) takers = db.Column(db.Integer, nullable=False) #belongs to a school school_id = db.Column(db.Integer, db.ForeignKey('schools.id'), nullable=False) school = db.relationship('School', back_populates="sats")
class Rating(db.Model): __tablename__ = 'ratings' id = db.Column(db.Integer, primary_key=True) bn = db.Column(db.String, nullable=False) year = db.Column(db.Integer, nullable=False) overall = db.Column(db.Integer, nullable=False) school = db.relationship('School', back_populates='ratings') school_id = db.Column(db.Integer, db.ForeignKey('schools.id'), nullable=False) core = db.relationship('Core', uselist=False, back_populates='rating') culture = db.relationship('Culture', uselist=False, back_populates='rating') improvement = db.relationship('Improvement', uselist=False, back_populates='rating')