Using POSper/Developer guide/Database-Table descriptions/posper productlocation

posper_productlocationEdit


This associative table describes a product stored at a location.

Column Name Data Type Null Allowed? Key? Comments
id VARCHAR(255) No Primary UUID instead of int
version INT(11) No This is used by hibernate to track table versions
stockMaximum DOUBLE Yes This is shown on inventory reports to allow the report reader to take action outside of the program (for instance, if current stock level is beyond the maximum maybe it's time to start selling it at a discount or move it to another store)
stockSecurity DOUBLE Yes Also known as "minimum", this is shown on inventory reports to allow the report reader to take action outside of the program (for instance, if stock level is below minimum presumably you want to order more units).
product_id VARCHAR(255) No Foreign Key This links to the product being described
location_id VARCHAR(255) No Foreign Key This links to the location being described
Last modified on 25 June 2009, at 19:51