411 REFERENCE · Wikibooks
Using POSper/Developer guide/Database-Miscellaneous Details
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
The two tables that store the sales are:
TICKETS (TICKETID, DATENEW, HOST, PERSON, PAYMENT, MONEY INTEGER)
PRODUCTSOUT (TICKETID, TICKETLINE, PRODUCT, UNITS, PRICE)
One sale is one record in the table TICKETS and one or more records in the table PRODUCTSOUT.