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 |