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

From Wikibooks, open books for an open world
< Using POSper‎ | Developer guide‎ | Database-Table descriptions
Jump to: navigation, search

ticket_payment[edit]


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?)