Metadata Storage
- Bart Friederichs
Analytics
Introduction
Metadata is extra data that can be stored together with the warehouse objects in the database, but are not needed for day-to-day operation. Metadata can be used to extend StockControl’s features or provide users with extra data for external processes.
Examples
The color of an article might not be needed for order picking, but it can help the order picker to find an item more quickly. StockControl can store this information together with the article and show to the order picker when needed.
Serial numbers or LOT codes can be stored together with items.
How it works developer
(Almost) every table has a properties column, which is a PostgreSQL hstore typed column. Hstores are data structures that can store key-value pairs (all text). The data in these columns is completely free form and can be used to extend StockControl.
Note
Some built-in features also use the properties column as well. E.g. the pick-to-light uses the ptl key in the wms_zone.properties column.