id = Column(Integer, primary_key=True, autoincrement=True) stock_change_id = Column(Integer, ForeignKey(stock_changes.c.id)) stock_change = relationship(StockChange, backref=backref('stock_change_lines', cascade='save-update,merge,delete')) product_id = Column(Integer, ForeignKey(products.c.id)) product = relationship(Product) quantity = Column(Float) a_price = Column(Float) amount = Column(Float) stock_change_lines = StockChangeLine.__table__ class StockChangeAction(Base): __tablename__ = 'stock_change_actions' id = Column(Integer, primary_key=True, autoincrement=True) name = Column(Unicode(50)) user_id = Column(Integer, ForeignKey(users.c.id)) user = relationship(User) created_at = Column(DateTime, default=datetime.now) action_type = Column(Integer, default=0) stock_change_id = Column(Integer, ForeignKey(stock_changes.c.id)) stock_change = relationship(StockChange, backref=backref('stock_change_actions', cascade='save-update,merge,delete')) memo = Column(Unicode(50)) __mapper_args__ = { 'order_by': id.asc() } stock_change_actions = StockChangeAction.__table__ add_models([StockChangeType, StockChange, StockChangeLine, StockChangeAction])
quantity = Column(Float) a_price = Column(Float) amount = Column(Float) un_return_quantity = Column(Float, default=0) form_code = Column(Unicode(50)) form_id = Column(Integer) form_line_id = Column(Integer) form_name = Column(Unicode(50), default='lend') lend_return_lines = LendReturnLine.__table__ class LendReturnAction(Base): __tablename__ = 'lend_return_actions' id = Column(Integer, primary_key=True, autoincrement=True) name = Column(Unicode(50)) user_id = Column(Integer, ForeignKey(users.c.id)) user = relationship(User) created_at = Column(DateTime, default=datetime.now) action_type = Column(Integer, default=0) lend_return_id = Column(Integer, ForeignKey(lend_returns.c.id)) lend_return = relationship(LendReturn, backref=backref('lend_return_actions', cascade='save-update,merge,delete')) memo = Column(Unicode(50)) __mapper_args__ = { 'order_by': id.asc() } lend_return_actions = LendReturnAction.__table__ add_models([Lend, LendLine, LendAction, LendReturn, LendReturnLine, LendReturnAction])