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