Open main menu

Wikibooks β

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

< Using POSper‎ | Developer guide‎ | Database-Table descriptions


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)