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 School(db.Model):
__tablename__ = 'schools'
id = db.Column(db.Integer, primary_key=True)
dbn = db.Column(db.String, nullable=False)
bn = db.Column(db.String, nullable=False)
name = db.Column(db.String, nullable=False)
#has_many schoolSATs
sats = db.relationship('SchoolSAT', back_populates='school')
ratings = db.relationship('Rating', back_populates='school')
attendance_years = db.relationship('Attendance_Year',
back_populates='school')
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')
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 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 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)