Using POSper/Developer guide/Database-Table descriptions/ticket payment
Jump to navigation
Jump to search
ticket_payment[edit | edit source]
This associative table connects a payment to a ticket.
| Column Name | Data Type | Null Allowed? | Key? | Comments |
|---|---|---|---|---|
| payment | VARCHAR(255) | No | Foreign Key; Composite primary key | points to the associated payment |
| ticket | VARCHAR(255) | Yes | Foreign Key; Composite primary key | points to the associated ticket. (Note: What does it mean if the ticket IS null?) |