411 REFERENCE · Wikibooks
Using POSper/Developer guide/Database-Table descriptions/posper payment
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
posper_payment
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