View source | Discuss this page | Page history | Printable version   

POS/2.30/Database Model/products

POS/2.30/Database Model

Index


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 -



POS/2.30/Database Model/places | POS/2.30/Database Model/products cat 

Retrieved from "http://wiki.openbravo.com/wiki/POS/2.30/Database_Model/products"

This page has been accessed 5,798 times. This page was last modified on 12 August 2009, at 10:02. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.