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])
