Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

SH
Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

PRODUCTS

Description

dimension table

Columns

Column Datatype Nullable Default value Comment
PROD_ID NUMBER(6,0) N   primary key
PROD_NAME VARCHAR2(50) N   product name
PROD_DESC VARCHAR2(4000) N   product description
PROD_SUBCATEGORY VARCHAR2(50) N   product subcategory
PROD_SUBCAT_DESC VARCHAR2(2000) N   product subcategory description
PROD_CATEGORY VARCHAR2(50) N   product category
PROD_CAT_DESC VARCHAR2(2000) N   product category description
PROD_WEIGHT_CLASS NUMBER(2,0) Y   product weight class
PROD_UNIT_OF_MEASURE VARCHAR2(20) Y   product unit of measure
PROD_PACK_SIZE VARCHAR2(30) Y   product package size
SUPPLIER_ID NUMBER(6,0) Y   this column
PROD_STATUS VARCHAR2(20) N   product status
PROD_LIST_PRICE NUMBER(8,2) N   product list price
PROD_MIN_PRICE NUMBER(8,2) N   product minimum price
PROD_TOTAL VARCHAR2(13) Y 'Product total'  

Primary key

Primary key Columns
PRODUCTS_PK PROD_ID

Check constraints

Check constraint Check condition
PRODUCTS_PROD_CATD_NN "PROD_CAT_DESC" IS NOT NULL
PRODUCTS_PROD_CAT_NN "PROD_CATEGORY" IS NOT NULL
PRODUCTS_PROD_DESC_NN "PROD_DESC" IS NOT NULL
PRODUCTS_PROD_LIST_PRICE_NN "PROD_LIST_PRICE" IS NOT NULL
PRODUCTS_PROD_MIN_PRICE_NN "PROD_MIN_PRICE" IS NOT NULL
PRODUCTS_PROD_NAME_NN "PROD_NAME" IS NOT NULL
PRODUCTS_PROD_STAT_NN "PROD_STATUS" IS NOT NULL
PRODUCTS_PROD_SUBCATD_NN "PROD_SUBCAT_DESC" IS NOT NULL
PRODUCTS_PROD_SUBCAT_NN "PROD_SUBCATEGORY" IS NOT NULL

Indexes

Index Type Uniqueness Columns
PRODUCTS_PK NORMAL UNIQUE PROD_ID
PRODUCTS_PROD_CAT_IX NORMAL NONUNIQUE PROD_CATEGORY
PRODUCTS_PROD_STATUS_BIX BITMAP NONUNIQUE PROD_STATUS
PRODUCTS_PROD_SUBCAT_IX NORMAL NONUNIQUE PROD_SUBCATEGORY

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N

Referenced by

Referenced by Constraint
COSTS COSTS_PRODUCT_FK
SALES SALES_PRODUCT_FK

Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005