engine = create_engine(URL(**DATABASE), echo=True)
Base = declarative_base()
metadata = MetaData()

User = Table(
    'users', metadata,
    Column('tg_id', Integer, primary_key=True)
    )

metadata.create_all(engine)

class Wishlist(Base):
    __tablename__ = 'wishlists'
    id = Column(Integer, primary_key=True)
    card_eng_name = Column(String)
    card_rus_name = Column(String)
    card_price = Column(String)
    tg_id = Column(Integer, ForeignKey('User.tg_id'))
    user = relationship('User', back_populates='wishlist')

    def __init__(self, card_eng_name, card_rus_name, card_price):
        self.card_eng_name = card_eng_name
        self.card_rus_name = card_rus_name
        self.card_price = card_price

class Tradelist(Base):
    __tablename__ = 'tradelists'
    id = Column(Integer, primary_key=True)
    card_eng_name = Column(String)
    card_rus_name = Column(String)
    card_price = Column(String)
    tg_id = Column(Integer, ForeignKey('User.tg_id'))
    user = relationship('User', back_populates='tradelist')

    def __init__(self, card_eng_name, card_rus_name, card_price):
        self.card_eng_name = card_eng_name
        self.card_rus_name = card_rus_name
        self.card_price = card_price

Base.metadata.create_all(engine)