From dbscript Online Help
wikibot
| Table
|
SH.PRODUCTS
|
| Description
|
dimension table
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| PROD_ID
|
NUMBER(6, 0)
|
not null
|
|
primary key
|
| PROD_NAME
|
VARCHAR2(50)
|
not null
|
|
product name
|
| PROD_DESC
|
VARCHAR2(4000)
|
not null
|
|
product description
|
| PROD_SUBCATEGORY
|
VARCHAR2(50)
|
not null
|
|
product subcategory
|
| PROD_SUBCATEGORY_ID
|
NUMBER
|
not null
|
|
|
| PROD_SUBCATEGORY_DESC
|
VARCHAR2(2000)
|
not null
|
|
product subcategory description
|
| PROD_CATEGORY
|
VARCHAR2(50)
|
not null
|
|
product category
|
| PROD_CATEGORY_ID
|
NUMBER
|
not null
|
|
|
| PROD_CATEGORY_DESC
|
VARCHAR2(2000)
|
not null
|
|
product category description
|
| PROD_WEIGHT_CLASS
|
NUMBER(3, 0)
|
not null
|
|
product weight class
|
| PROD_UNIT_OF_MEASURE
|
VARCHAR2(20)
|
null
|
|
product unit of measure
|
| PROD_PACK_SIZE
|
VARCHAR2(30)
|
not null
|
|
product package size
|
| SUPPLIER_ID
|
NUMBER(6, 0)
|
not null
|
|
this column
|
| PROD_STATUS
|
VARCHAR2(20)
|
not null
|
|
product status
|
| PROD_LIST_PRICE
|
NUMBER(8, 2)
|
not null
|
|
product list price
|
| PROD_MIN_PRICE
|
NUMBER(8, 2)
|
not null
|
|
product minimum price
|
| 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
|
|
|
Primary Key
| Primary Key
|
Columns
|
| PRODUCTS_PK
|
PROD_ID
|
Indexes
| Index
|
Type
|
Columns
|
| PRODUCTS_PROD_CAT_IX
|
|
PROD_CATEGORY
|
| PRODUCTS_PROD_STATUS_BIX
|
|
PROD_STATUS
|
| PRODUCTS_PROD_SUBCAT_IX
|
|
PROD_SUBCATEGORY
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| SYS_C005127
|
"PROD_ID" IS NOT NULL
|
|
| SYS_C005128
|
"PROD_NAME" IS NOT NULL
|
|
| SYS_C005129
|
"PROD_DESC" IS NOT NULL
|
|
| SYS_C005130
|
"PROD_SUBCATEGORY" IS NOT NULL
|
|
| SYS_C005131
|
"PROD_SUBCATEGORY_ID" IS NOT NULL
|
|
| SYS_C005132
|
"PROD_SUBCATEGORY_DESC" IS NOT NULL
|
|
| SYS_C005133
|
"PROD_CATEGORY" IS NOT NULL
|
|
| SYS_C005134
|
"PROD_CATEGORY_ID" IS NOT NULL
|
|
| SYS_C005135
|
"PROD_CATEGORY_DESC" IS NOT NULL
|
|
| SYS_C005136
|
"PROD_WEIGHT_CLASS" IS NOT NULL
|
|
| SYS_C005137
|
"PROD_PACK_SIZE" IS NOT NULL
|
|
| SYS_C005138
|
"SUPPLIER_ID" IS NOT NULL
|
|
| SYS_C005139
|
"PROD_STATUS" IS NOT NULL
|
|
| SYS_C005140
|
"PROD_LIST_PRICE" IS NOT NULL
|
|
| SYS_C005141
|
"PROD_MIN_PRICE" IS NOT NULL
|
|
| SYS_C005142
|
"PROD_TOTAL" IS NOT NULL
|
|
| SYS_C005143
|
"PROD_TOTAL_ID" IS NOT NULL
|
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| SH.COSTS
|
PROD_ID
|
PROD_ID
|
| SH.SALES
|
PROD_ID
|
PROD_ID
|
