Using POSper/Developer guide/Database-Table descriptions/posper floor
posper_floor
[edit | edit source]
This table has information for a restaurant "floor" where customers sit and eat (and need to have food brought to them)
| 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 | |
| visibleId | INT(11) | Yes | Uni | This is the user visible (user-friendly) Id |
| name | VARCHAR(255) | No | This is the floor name | |
| image_id | VARCHAR(255) | Yes | Foreign Key | If an image is associated with this floor, this points to it (foreign key) |