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

posper_place Edit

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