old_contents: from sqlalchemy import Boolean, Column, Integer, DateTime, ForeignKey, String
  from sqlalchemy.orm import relationship
  from sqlalchemy.ext.declarative import declarative_base
  
  
  Base = declarative_base()
  
  
  class Route(Base):
      __tablename__ = 'route'
      id = Column(Integer, primary_key=True)
      created_on = Column(DateTime)
      current = Column(Boolean)
      route_number = Column(Integer)
      route_name = Column(String)
      service_type = Column(String)
  
  
  class DailyRidership(Base):
      __tablename__ = 'daily_ridership'
      id = Column(Integer, primary_key=True)
      created_on = Column(DateTime)
      current = Column(Boolean)
      day_of_week = Column(String)
      period = Column(String)
      ridership = Column(Integer)
      route_id = Column(Integer, ForeignKey('route.id'))
      route = relationship("Route", backref='daily_ridership')
  
  
  class HourlyRidership(Base):
      __tablename__ = 'hourly_ridership'
      id = Column(Integer, primary_key=True)
      created_on = Column(DateTime)
      current = Column(Boolean)
      day_of_week = Column(String)
      period = Column(String)
      ridership = Column(Integer)
      route_id = Column(Integer, ForeignKey('route.id'))
      route = relationship("Route", backref='hourly_ridership')
  
  
new_contents: from sqlalchemy import Boolean, Column, Integer, DateTime, ForeignKey, String
  from sqlalchemy.orm import relationship
  from sqlalchemy.ext.declarative import declarative_base
  
  
  Base = declarative_base()
  
  
  class Route(Base):
      __tablename__ = 'route'
      id = Column(Integer, primary_key=True)
      created_on = Column(DateTime)
      current = Column(Boolean)
      route_number = Column(Integer)
      route_name = Column(String)
      service_type = Column(String)
  
  
  class DailyRidership(Base):
      __tablename__ = 'daily_ridership'
      id = Column(Integer, primary_key=True)
      created_on = Column(DateTime)
      current = Column(Boolean)
      day_of_week = Column(String)
      period = Column(String)
      season = Column(String)
      year = Column(Integer)
      ridership = Column(Integer)
      route_id = Column(Integer, ForeignKey('route.id'))
      route = relationship("Route", backref='daily_ridership')
  
  
  class HourlyRidership(Base):
      __tablename__ = 'hourly_ridership'
      id = Column(Integer, primary_key=True)
      created_on = Column(DateTime)
      current = Column(Boolean)
      day_of_week = Column(String)
      period = Column(String)
      season = Column(String)
      year = Column(Integer)
      ridership = Column(Integer)
      route_id = Column(Integer, ForeignKey('route.id'))
      route = relationship("Route", backref='hourly_ridership')
  
  
subject: Add season and year fields to ridership models.