class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String(50), unique=True)
    email = Column(String(120), unique=True)
    password = Column(String(12))
    balance = Column(Float())
    inventory = relationship("Inventory", primaryjoin="and_(User.id==Inventory.user_id, BaseGood.id==Inventory.basegood_id)", back_populates="user")


class Inventory(Base):
    __tablename__ = 'inventory'
    id = Column(Integer, primary_key=True)
    basegood_id = Column(Integer, ForeignKey('basegoods.id'))
    producables_id = Column(Integer, ForeignKey('producables.id'))
    user_id = Column(Integer, ForeignKey('users.id'))
    basegood = relationship('BaseGood', backref='basegoods', lazy="joined")
    user = relationship("User")

class Producable(Base):
    __tablename__ = 'producables'
    id = Column(Integer, primary_key=True)
    name = Column(String(50), unique=True)
    price = Column(Float)
    time = Column(Integer)
    blueprint = relationship('BaseGood', secondary='blueprints', backref='producables', lazy="joined")

class BaseGood(Base):
    __tablename__ = 'basegoods'
    id = Column(Integer, primary_key=True)
    name = Column(String(50), unique=True)
    initprice = Column(Float)
    price = Column(Float)
    producable = relationship('Producable', secondary='blueprints', backref='basegoods', lazy="joined")

inventory = relationship("Inventory", primaryjoin="and_(User.id==Inventory.user_id, BaseGood.id==Inventory.basegood_id)", back_populates="user")