title: SQL Alchemy Composite Key Order
body: <p>I want to create a composite primary key of the form (date,id). My code currently looks somewhat like this</p>
  
  <pre><code>class Gyroinfo(Base):
      __tablename__ = 'GYROINFO'
  
      id = Column(Integer, primary_key=True,autoincrement = True)
      date = Column(DateTime, primary_key = True)
  </code></pre>
  
  <p>but this defaults to a primary key of the form (id, date). How can I switch the primary key order?</p>