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

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
This article is issued from Wikibooks. The text is available under Creative Commons Attribution-Share Alike 4.0 unless otherwise noted. Additional terms may apply for the media files.