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

From Wikibooks, open books for an open world
< Using POSper‎ | Developer guide‎ | Database-Table descriptions
Jump to: navigation, search


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