POS/2.30/Database Model/ticketlines
Contents |
TICKETLINES
Description
Columns
This table contains the following columns:
Name | PK | Nullable | Data Type | Default | Description |
TICKET | N | N | VARCHAR | ||
LINE | N | N | INTEGER | ||
PRODUCT | N | Y | VARCHAR | ||
ATTRIBUTESETINSTANCE_ID | N | Y | VARCHAR | ||
UNITS | N | N | DOUBLE | ||
PRICE | N | N | DOUBLE | ||
TAXID | N | N | VARCHAR | ||
ATTRIBUTES | N | Y | BYTEA |
Foreign Keys
These are the foreign keys for this table:
Name | Referencing column | Referenced table | Referenced column | Description |
TICKETLINES_FK_TICKET | TICKET | TICKETS | ID | |
TICKETLINES_FK_2 | PRODUCT | PRODUCTS | ID | |
TICKETLINES_ATTSETINST | ATTRIBUTESETINSTANCE_ID | ATTRIBUTESETINSTANCE | ID | |
TICKETLINES_FK_3 | TAXID | TAXES | ID |
Indexes
Languages: |
POS/2.30/Database Model/thirdparties | POS/2.30/Database Model/tickets