View source | Discuss this page | Page history | Printable version   

POS/2.30/Database Model/tickets

POS/2.30/Database Model

Index


Contents

TICKETS

Description

Columns

This table contains the following columns:

Name PK Nullable Data Type Default Description
ID Y N VARCHAR
TICKETTYPE N N INTEGER 0
TICKETID N N INTEGER
PERSON N N VARCHAR
CUSTOMER N Y VARCHAR
STATUS N N INTEGER 0

Foreign Keys

These are the foreign keys for this table:

Name Referencing column Referenced table Referenced column Description
TICKETS_FK_ID ID RECEIPTS ID
TICKETS_FK_2 PERSON PEOPLE ID
TICKETS_CUSTOMERS_FK CUSTOMER CUSTOMERS ID

Indexes

These are the indexes for this table (for each index there is a list of the columns included within it):

Name Unique Reference Description
TICKETS_TICKETID N TICKETTYPE - TICKETID -



POS/2.30/Database Model/ticketlines

Retrieved from "http://wiki.openbravo.com/wiki/POS/2.30/Database_Model/tickets"

This page has been accessed 4,885 times. This page was last modified on 30 August 2009, at 08:41. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.