From dbscript Online Help
wikibot
| Table
|
SH.PROMOTIONS
|
| Description
|
dimension table without a PK-FK relationship with the facts table, to show outer join functionality
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| PROMO_ID
|
NUMBER(6, 0)
|
not null
|
|
primary key column
|
| PROMO_NAME
|
VARCHAR2(30)
|
not null
|
|
promotion description
|
| PROMO_SUBCATEGORY
|
VARCHAR2(30)
|
not null
|
|
enables to investigate promotion hierarchies
|
| PROMO_SUBCATEGORY_ID
|
NUMBER
|
not null
|
|
|
| PROMO_CATEGORY
|
VARCHAR2(30)
|
not null
|
|
promotion category
|
| PROMO_CATEGORY_ID
|
NUMBER
|
not null
|
|
|
| PROMO_COST
|
NUMBER(10, 2)
|
not null
|
|
promotion cost, to do promotion effect calculations
|
| PROMO_BEGIN_DATE
|
DATE(7)
|
not null
|
|
promotion begin day
|
| PROMO_END_DATE
|
DATE(7)
|
not null
|
|
promotion end day
|
| PROMO_TOTAL
|
VARCHAR2(15)
|
not null
|
|
|
| PROMO_TOTAL_ID
|
NUMBER
|
not null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| PROMO_PK
|
PROMO_ID
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| SYS_C005152
|
"PROMO_ID" IS NOT NULL
|
|
| SYS_C005153
|
"PROMO_NAME" IS NOT NULL
|
|
| SYS_C005154
|
"PROMO_SUBCATEGORY" IS NOT NULL
|
|
| SYS_C005155
|
"PROMO_SUBCATEGORY_ID" IS NOT NULL
|
|
| SYS_C005156
|
"PROMO_CATEGORY" IS NOT NULL
|
|
| SYS_C005157
|
"PROMO_CATEGORY_ID" IS NOT NULL
|
|
| SYS_C005158
|
"PROMO_COST" IS NOT NULL
|
|
| SYS_C005159
|
"PROMO_BEGIN_DATE" IS NOT NULL
|
|
| SYS_C005160
|
"PROMO_END_DATE" IS NOT NULL
|
|
| SYS_C005161
|
"PROMO_TOTAL" IS NOT NULL
|
|
| SYS_C005162
|
"PROMO_TOTAL_ID" IS NOT NULL
|
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| SH.COSTS
|
PROMO_ID
|
PROMO_ID
|
| SH.SALES
|
PROMO_ID
|
PROMO_ID
|
