Skip to main content

  | मौसम…

411 समाचार
Public archive edition · Attributed source reporting with original dates · AI drafts are excluded

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"