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  

PROMOTIONS

Description

dimension table without a PK-FK relationship with the facts table, to show outer join functionality

Columns

Column Datatype Nullable Default value Comment
PROMO_ID NUMBER(6,0) N   primary key column
PROMO_NAME VARCHAR2(20) N   promotion description
PROMO_SUBCATEGORY VARCHAR2(30) N   enables to investigate promotion hierarchies
PROMO_CATEGORY VARCHAR2(30) N   promotion category
PROMO_COST NUMBER(10,2) N   promotion cost, to do promotion effect calculations
PROMO_BEGIN_DATE DATE N   promotion begin day
PROMO_END_DATE DATE N   promotion end day
PROMO_TOTAL VARCHAR2(15) Y 'Promotion total'  

Primary key

Primary key Columns
PROMO_PK PROMO_ID

Check constraints

Check constraint Check condition
PROMO_BEGIN_DATE_NN "PROMO_BEGIN_DATE" IS NOT NULL
PROMO_CAT_NN "PROMO_CATEGORY" IS NOT NULL
PROMO_COST_NN "PROMO_COST" IS NOT NULL
PROMO_END_DATE_NN "PROMO_END_DATE" IS NOT NULL
PROMO_NAME_NN "PROMO_NAME" IS NOT NULL
PROMO_SUBCAT_NN "PROMO_SUBCATEGORY" IS NOT NULL

Indexes

Index Type Uniqueness Columns
PROMO_PK NORMAL UNIQUE PROMO_ID

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
SALES SALES_PROMO_FK

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