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|