sqlalchemy foreign key
Подскажите пожалуйста получаю такую ошибку:
sqlalchemy.exc.NoReferencedTableError: Foreign key associated with column 'setevik.category' could not find table 'category' with which to generate a foreign key to target column 'id'
и непосредственно код
class Category(Base):
def __init__(self, id=None, name=None):
self.name = name
self.id = id
__tablename__ = Table('category', Main().create_metadata(), autoload=True)
id = Column(Integer, primary_key=True, unique=True)
name = Column(unique=True)
class News(Base):
def __init__(
self, id=None, title=None, body=None,
date=None, time=None, category=None, tegs=None
):
self.id = id
self.title = title
self.body = body
self.date = date
self.time = time
self.category = category
self.tegs = tegs
__tablename__ = Table('setevik', Main().create_metadata(), autoload=True)
id = Column(primary_key=True)
title = Column()
body = Column()
date = Column()
time = Column()
category = Column(Integer, ForeignKey('category.id'))
tegs = Column(nullable=True)