R3 = Column(Integer, default=0) R4 = Column(Integer, default=0) R5 = Column(Integer, default=0) total = Column(Integer, default=0) toPar = Column(String(10), default="") pos = Column(String(10), default="0") class StatsModel(Base): __tablename__ = 'StatsTable' id = Column(Integer, autoincrement=True, unique=True) __table_args__ = (PrimaryKeyConstraint('playerId', 'compLevelId', 'roundsPlayed', 'year', 'masterStat', 'minorStat'), ) playerId = Column(Integer, ForeignKey("PlayerTable.id")) compLevelId = Column(Integer, ForeignKey("CompetitionLevelTable.id")) year = Column(Integer, nullable=False, autoincrement=False) roundsPlayed = Column(Integer, default=0) masterStat = Column(String(10), default="") minorStat = Column(String(10), default="") statValue = Column(String(10), default="") SportsModelSession = DatabaseConnection.CreateSportModelDBEngineSession(Base) # sportsModelSession.add_all( # [CompetitionLevel(name = "PGA Tour"), # CompetitionLevel(name = "Web.com Tour"), # CompetitionLevel(name = "Euro Tour")] # ) # sportsModelSession.commit()