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