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

posper_placeEdit


This table describes areas on a floor where customers will be located.

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
name VARCHAR(255) No descriptive name such as "comfy nook" or nondescriptive name like "#1"
x INT(11) No the x location of the place
y INT(11) No The y location of the place
floor_id VARCHAR(255) No Foreign Key Points to the floor this place is associated with
Last modified on 25 June 2009, at 19:50