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

posper_productlocation 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