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

From Wikibooks, open books for an open world
Jump to navigation Jump to search

posper_productlocation[edit | edit source]


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