POS/2.30/Database Model/tickets
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 - |
| Languages: |
POS/2.30/Database Model/ticketlines