Using POSper/Developer guide/Database-Table descriptions/posper payment
posper_payment
[edit | edit source]
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 |