411 REFERENCE · Wikibooks
Using POSper/Developer guide/Database-Table descriptions/posper reservation
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
posper_reservation
This describes a reservation for a number of customers to eat at a particular time.
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 customer VARCHAR(255) Yes Customer information, most typically just a name like "Dr Farnsworth" but it can be whatever text the user wants. chairs INT(11) No This is simply annotative information letting the restaurant staff know how many chairs are needed : it doesn't effect actual functionality in software. date DATETIME Yes The time of the reservation done BIT(1) No This is set to true when the reservation has been received at a specific table. description VARCHAR(255) Yes annotative information about the reservation, entered when the reservation is booked. It can be any sort of notes, like "they'd like wine when they arrive" or "need to have a chair ready for a toddler"