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|