class ArtistGene(db.Model): __tablename__ = 'artists_genes' artist_id = db.Column(db.Integer, db.ForeignKey('artists.id'), primary_key=True) gene_id = db.Column(db.Integer, db.ForeignKey('genes.id'), primary_key=True)
class StrainCountry(db.Model): __tablename__ = 'straincountries' strain_id = db.Column(db.Integer, db.ForeignKey('strains.id'), primary_key=True) country_id = db.Column(db.Integer, db.ForeignKey('countries.id'), primary_key=True)
class StrainEffects(db.Model): __tablename__ = 'straineffects' strain_id = db.Column(db.Integer, db.ForeignKey('strains.id'), primary_key=True) effect_id = db.Column(db.Integer, db.ForeignKey('effects.id'), primary_key=True)
class StrainFlavor(db.Model): __tablename__ = 'strainflavors' strain_id = db.Column(db.Integer, db.ForeignKey('strains.id'), primary_key=True) flavor_id = db.Column(db.Integer, db.ForeignKey('flavors.id'), primary_key=True)
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 Cuisine(db.Model): __tablename__ = 'cuisines' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text) restaurant_id = db.Column(db.Integer, db.ForeignKey('nyc_restaurants.id')) restaurant = db.relationship('Restaurant', back_populates='cuisine')
class WS_Winners(db.Model): __tablename__ = "ws_winners" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text) year = db.Column(db.Integer) team_id = db.Column(db.Integer, db.ForeignKey('teams.id')) team = db.relationship('Team', backref=db.backref('ws_winners', lazy=True))
class Michelin(db.Model): __tablename__ = 'michelin_info' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text) stars = db.Column(db.Integer) restaurant_id = db.Column(db.Integer, db.ForeignKey('nyc_restaurants.id')) restaurant = db.relationship('Restaurant', back_populates='michelin_info')
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 Infatuation(db.Model): __tablename__ = 'infatuation_info' id = db.Column(db.Integer, primary_key=True) price = db.Column(db.Integer) rating = db.Column(db.Integer) restaurant_id = db.Column(db.Integer, db.ForeignKey('nyc_restaurants.id')) restaurant = db.relationship('Restaurant', back_populates='infatuation_info')
class Crime_Event(db.Model): #parent __tablename__ = 'crime_events' id = db.Column(db.Integer, primary_key=True) complaint_num = db.Column(db.Integer) date_of_occurance = db.Column(db.Date) time_of_occurance = db.Column(db.String) crime_completed_y_n = db.Column(db.Text) jurisdiction_code = db.Column(db.Text) jurisdiction_desc = db.Column(db.Text) report_date = db.Column(db.String) level_of_offense = db.Column(db.Text) offense_descr = db.Column(db.Text) location_id = db.Column(db.Integer, db.ForeignKey('locations.id')) victim_id = db.Column(db.Integer, db.ForeignKey('victims.id')) suspect_id = db.Column(db.Integer, db.ForeignKey('suspects.id')) locations = db.relationship("Location", back_populates="crimes") victims = db.relationship("Victim", back_populates="crimes") suspects = db.relationship("Suspect", back_populates="crimes")
class Year(db.Model): __tablename__ = 'years' id = db.Column(db.Integer, primary_key=True) year = db.Column(db.Integer) rank = db.Column(db.Integer) artist_id = db.Column(db.Integer, db.ForeignKey('artists.id')) artist = db.relationship('Artist', back_populates='years') totalsold = db.Column(db.Integer) totallots = db.Column(db.Integer) maxprice = db.Column(db.Integer)
class TripAdvisor(db.Model): __tablename__ = 'trip_advisor_info' id = db.Column(db.Integer, primary_key=True) price = db.Column(db.Integer) rating = db.Column(db.Integer) ranking = db.Column(db.Integer) number_reviews = db.Column(db.Integer) restaurant_id = db.Column(db.Integer, db.ForeignKey('nyc_restaurants.id')) restaurant = db.relationship('Restaurant', back_populates='trip_advisor_info')
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 Defensive_Stats(db.Model): __tablename__ = 'defensive_stats' id = db.Column(db.Integer, primary_key=True) team_id = db.Column(db.Integer, db.ForeignKey('teams.id')) year = db.Column(db.Integer) losses = db.Column(db.Integer) runs_allowed = db.Column(db.Integer) earned_runs = db.Column(db.Integer) era = db.Column(db.Float) strikeouts = db.Column(db.Integer) field_percent = db.Column(db.Float) team = db.relationship('Team', backref=db.backref('defensive_stats', lazy=True))
class Offensive_Stats(db.Model): __tablename__ = 'offensive_stats' id = db.Column(db.Integer, primary_key=True) team_id = db.Column(db.Integer, db.ForeignKey('teams.id')) league = db.Column(db.Text) division = db.Column(db.Text) year = db.Column(db.Integer) wins = db.Column(db.Integer) runs_scored = db.Column(db.Integer) home_runs = db.Column(db.Integer) batting_avg = db.Column(db.Float) ops = db.Column(db.Float) avg_age = db.Column(db.Float) team = db.relationship('Team', backref=db.backref('offensive_stats', lazy=True))
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 Restaurant(db.Model): __tablename__ = 'nyc_restaurants' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text) address = db.Column(db.Text) zip_code = db.Column(db.Integer) latitude = db.Column(db.Integer) longitude = db.Column(db.Integer) cuisine = db.relationship('Cuisine', back_populates='restaurant') trip_advisor_info = db.relationship('TripAdvisor', back_populates='restaurant') infatuation_info = db.relationship('Infatuation', back_populates='restaurant') michelin_info = db.relationship('Michelin', back_populates='restaurant') neighborhood_id = db.Column(db.Integer, db.ForeignKey('neighborhoods.id')) neighborhood = db.relationship('Neighborhood', back_populates='restaurants')
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')
from sqlalchemy import * class Coach(db.Model): #db.Model is the same as Base in original SQL Alchemy __tablename__ = 'coach' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text) years = db.Column(db.Integer) salary = db.Column(db.Float) sal_school = db.Column(db.Text) # schools = relationship('School', secondary = 'joinedtable') schools = db.relationship('School', secondary='JoinedTable') #back_populates=db.back_populates('coaches')) class School(db.Model): __tablename__ = 'school' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text) years = db.Column(db.Text) winloss = db.Column(Float) team_points = db.Column(Float) opp_points = db.Column(Float) # coaches = relationship('Coach', secondary = 'joinedtable') coaches = db.relationship('Coach', secondary='JoinedTable') #back_populates=db.back_populates('schools')) JoinedTable = db.Table('JoinedTable',\ db.Column('school_id', db.Integer, db.ForeignKey('school.id'), primary_key = True),\ db.Column('coach_id', db.Integer, db.ForeignKey('coach.id'), primary_key = True))