title: SQLAlchemy ForeignKey can't find table
body: <p>Getting this error when I try to instantiate the <code>ConsumerAdvice</code> class.</p>
  
  <pre><code>Foreign key associated with column 'tbConsumerAdvice.ConsumerAdviceCategory_ID' 
  could not find table 'tbConsumerAdviceCategories' with which to generate a
  foreign key to target column 'ID_ConsumerAdviceCategories'
  </code></pre>
  
  
  
  <pre><code>class ConsumerAdviceCategory(Base):
      __tablename__ = 'tbConsumerAdviceCategories'
      __table_args__ = {'schema':'dbo'}
      ID_ConsumerAdviceCategories = Column(INTEGER, Sequence('idcac'),\
              primary_key=True)
      Name = Column(VARCHAR(50), nullable=False)
  
      def __init__(self,Name):
          self.Name = Name
  
      def __repr__(self):
          return "&lt; ConsumerAdviceCategory ('%s') &gt;" % self.Name
  
  class ConsumerAdvice(Base):
      __tablename__ = 'tbConsumerAdvice'
      __table_args__ = {'schema':'dbo'}
      ID_ConsumerAdvice = Column(INTEGER, Sequence('idconsumeradvice'),\
              primary_key=True)
      ConsumerAdviceCategory_ID = Column(INTEGER,\
              ForeignKey('tbConsumerAdviceCategories.ID_ConsumerAdviceCategories'))
      Name = Column(VARCHAR(50), nullable=False)
      Category_SubID = Column(INTEGER)
  
      ConsumerAdviceCategory = relationship("ConsumerAdviceCategory",\
              backref=backref('ConsumerAdvices'))
  
      def __init__(self,Name):
          self.Name = Name
  
      def __repr__(self):
          return "&lt; ConsumerAdvice ('%s') &gt;" % self.Name
  </code></pre>