POS/2.30/Database Model/products
Contents |
PRODUCTS
Description
Columns
This table contains the following columns:
| Name | PK | Nullable | Data Type | Default | Description |
| ID | Y | N | VARCHAR | ||
| REFERENCE | N | N | VARCHAR | ||
| CODE | N | N | VARCHAR | ||
| CODETYPE | N | Y | VARCHAR | ||
| NAME | N | N | VARCHAR | ||
| PRICEBUY | N | N | DOUBLE | ||
| PRICESELL | N | N | DOUBLE | ||
| CATEGORY | N | N | VARCHAR | ||
| TAXCAT | N | N | VARCHAR | ||
| ATTRIBUTESET_ID | N | Y | VARCHAR | ||
| STOCKCOST | N | Y | DOUBLE | ||
| STOCKVOLUME | N | Y | DOUBLE | ||
| IMAGE | N | Y | BYTEA | ||
| ISCOM | N | N | BOOLEAN | FALSE | |
| ISSCALE | N | N | BOOLEAN | FALSE | |
| ATTRIBUTES | N | Y | BYTEA |
Foreign Keys
These are the foreign keys for this table:
| Name | Referencing column | Referenced table | Referenced column | Description |
| PRODUCTS_FK_1 | CATEGORY | CATEGORIES | ID | |
| PRODUCTS_TAXCAT_FK | TAXCAT | TAXCATEGORIES | ID | |
| PRODUCTS_ATTRSET_FK | ATTRIBUTESET_ID | ATTRIBUTESET | 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 |
| PRODUCTS_INX_0 | Y | REFERENCE - | |
| PRODUCTS_INX_1 | Y | CODE - | |
| PRODUCTS_NAME_INX | Y | NAME - |
| Languages: |
POS/2.30/Database Model/places | POS/2.30/Database Model/products cat