Last modified on 25 June 2009, at 19:50

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

posper_paymentEdit


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