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

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


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)