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

From Wikibooks, open books for an open world
Jump to navigation Jump to search

posper_payment[edit | edit source]


This table contains payments : either a customer paying a ticket, or money coming out of the till.

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
amount DOUBLE No how much money
method VARCHAR(255) No The method by which payment was rendered, including "cash", "cheque", "ticket", "free" and "magcard"
ticket_id VARCHAR(255) Yes Foreign Key The ticket that this payment applies to