Using POSper/Developer guide/Stable/Database-Miscellaneous Details

From Wikibooks, open books for an open world
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.