class TeamSeason(db.Model): id = db.Column(db.Integer, primary_key=True) # ATTRIBUTES team_id = db.Column(db.Integer, db.ForeignKey('team.id')) year = db.Column(db.Integer) # RELATIONSHIPS team = db.relationship('Team', foreign_keys=[team_id])
class Team(db.Model): id = db.Column(db.Integer, primary_key=True) # ATTRIBUTES abbrev = db.Column(db.String) city = db.Column(db.String) code = db.Column(db.String) division = db.Column(db.String) file_code = db.Column(db.String) league = db.Column(db.String) name = db.Column(db.String)
class Scoreboard(db.Model): id = db.Column(db.Integer, primary_key=True) #ATTRIBUTES away_runs = db.Column(db.Integer) away_hits = db.Column(db.Integer) away_errs = db.Column(db.Integer) home_runs = db.Column(db.Integer) home_hits = db.Column(db.Integer) home_errs = db.Column(db.Integer)
class Meta(db.Model): id = db.Column(db.Integer, primary_key=True) # ATTRIBUTES last_updated = db.Column(db.Date)
class Inning(db.Model): id = db.Column(db.Integer, primary_key=True) # ATTRIBUTES away_runs = db.Column(db.Integer) home_runs = db.Column(db.Integer) inning_number = db.Column(db.Integer)
class Game(db.Model): id = db.Column(db.Integer, primary_key=True) # ATTRIBUTES away_games_back = db.Column(db.Float) away_games_back_wc = db.Column(db.Float) away_loss = db.Column(db.Integer) away_team_id = db.Column(db.Integer, db.ForeignKey('team.id')) away_win = db.Column(db.Integer) date = db.Column(db.Date) game_id = db.Column(db.String) game_number = db.Column(db.Integer) game_type = db.Column(db.String) gameday_id = db.Column(db.String) home_games_back = db.Column(db.Float) home_games_back_wc = db.Column(db.Float) home_loss = db.Column(db.Integer) home_team_id = db.Column(db.Integer, db.ForeignKey('team.id')) home_win = db.Column(db.Integer) location = db.Column(db.String) scoreboard_id = db.Column(db.Integer, db.ForeignKey('scoreboard.id')) venue = db.Column(db.String) # RELATIONSHIPS away_team = db.relationship('Team', foreign_keys=[away_team_id]) home_team = db.relationship('Team', foreign_keys=[home_team_id]) scoreboard = db.relationship('Scoreboard', foreign_keys=[scoreboard_id])