From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| PROD_ID
|
NUMBER(6, 0)
|
not null
|
|
PRODUCTS_PK
|
|
| PROD_NAME
|
VARCHAR2(50)
|
not null
|
|
|
|
| PROD_DESC
|
VARCHAR2(4000)
|
not null
|
|
|
|
| PROD_SUBCATEGORY
|
VARCHAR2(50)
|
not null
|
|
|
PRODUCTS_PROD_SUBCAT_IX
|
| PROD_SUBCATEGORY_ID
|
NUMBER
|
not null
|
|
|
|
| PROD_SUBCATEGORY_DESC
|
VARCHAR2(2000)
|
not null
|
|
|
|
| PROD_CATEGORY
|
VARCHAR2(50)
|
not null
|
|
|
PRODUCTS_PROD_CAT_IX
|
| PROD_CATEGORY_ID
|
NUMBER
|
not null
|
|
|
|
| PROD_CATEGORY_DESC
|
VARCHAR2(2000)
|
not null
|
|
|
|
| PROD_WEIGHT_CLASS
|
NUMBER(3, 0)
|
not null
|
|
|
|
| PROD_UNIT_OF_MEASURE
|
VARCHAR2(20)
|
null
|
|
|
|
| PROD_PACK_SIZE
|
VARCHAR2(30)
|
not null
|
|
|
|
| SUPPLIER_ID
|
NUMBER(6, 0)
|
not null
|
|
|
|
| PROD_STATUS
|
VARCHAR2(20)
|
not null
|
|
|
PRODUCTS_PROD_STATUS_BIX
|
| PROD_LIST_PRICE
|
NUMBER(8, 2)
|
not null
|
|
|
|
| PROD_MIN_PRICE
|
NUMBER(8, 2)
|
not null
|
|
|
|
| PROD_TOTAL
|
VARCHAR2(13)
|
not null
|
|
|
|
| PROD_TOTAL_ID
|
NUMBER
|
not null
|
|
|
|
| PROD_SRC_ID
|
NUMBER
|
null
|
|
|
|
| PROD_EFF_FROM
|
DATE(7)
|
null
|
|
|
|
| PROD_EFF_TO
|
DATE(7)
|
null
|
|
|
|
| PROD_VALID
|
VARCHAR2(1)
|
null
|
|
|
|
| Detail Table
|
Column
|
Referencing Column
|
| SH.COSTS
|
PROD_ID
|
PROD_ID
|
| SH.SALES
|
PROD_ID
|
PROD_ID
|
