Openbravo POS/Developer guide/Database-Miscellaneous Details
From Wikibooks, open books for an open world
This page may need to be 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.
