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

posper_payment Edit

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