Jump to content

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

From Wikibooks, open books for an open world

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