Difference between revisions of "SH.PROMOTIONS (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.PROMOTIONS
 
| SH.PROMOTIONS
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| dimension table without a PK-FK relationship with the facts table, to show outer join functionality
 
| dimension table without a PK-FK relationship with the facts table, to show outer join functionality
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| PROMO_ID
 
| PROMO_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 27: Line 25:
 
|  
 
|  
 
| primary key column
 
| primary key column
|-
+
|- valign="top"
 
| PROMO_NAME
 
| PROMO_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 33: Line 31:
 
|  
 
|  
 
| promotion description
 
| promotion description
|-
+
|- valign="top"
 
| PROMO_SUBCATEGORY
 
| PROMO_SUBCATEGORY
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 39: Line 37:
 
|  
 
|  
 
| enables to investigate promotion hierarchies
 
| enables to investigate promotion hierarchies
|-
+
|- valign="top"
 
| PROMO_SUBCATEGORY_ID
 
| PROMO_SUBCATEGORY_ID
 
| NUMBER
 
| NUMBER
Line 45: Line 43:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PROMO_CATEGORY
 
| PROMO_CATEGORY
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 51: Line 49:
 
|  
 
|  
 
| promotion category
 
| promotion category
|-
+
|- valign="top"
 
| PROMO_CATEGORY_ID
 
| PROMO_CATEGORY_ID
 
| NUMBER
 
| NUMBER
Line 57: Line 55:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PROMO_COST
 
| PROMO_COST
 
| NUMBER(10, 2)
 
| NUMBER(10, 2)
Line 63: Line 61:
 
|  
 
|  
 
| promotion cost, to do promotion effect calculations
 
| promotion cost, to do promotion effect calculations
|-
+
|- valign="top"
 
| PROMO_BEGIN_DATE
 
| PROMO_BEGIN_DATE
 
| DATE(7)
 
| DATE(7)
Line 69: Line 67:
 
|  
 
|  
 
| promotion begin day
 
| promotion begin day
|-
+
|- valign="top"
 
| PROMO_END_DATE
 
| PROMO_END_DATE
 
| DATE(7)
 
| DATE(7)
Line 75: Line 73:
 
|  
 
|  
 
| promotion end day
 
| promotion end day
|-
+
|- valign="top"
 
| PROMO_TOTAL
 
| PROMO_TOTAL
 
| VARCHAR2(15)
 
| VARCHAR2(15)
Line 81: Line 79:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| PROMO_TOTAL_ID
 
| PROMO_TOTAL_ID
 
| NUMBER
 
| NUMBER
Line 94: Line 92:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PROMO_PK
 
| PROMO_PK
 
| PROMO_ID
 
| PROMO_ID
Line 105: Line 103:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| SYS_C005152
 
| SYS_C005152
 
| "PROMO_ID" IS NOT NULL
 
| "PROMO_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005153
 
| SYS_C005153
 
| "PROMO_NAME" IS NOT NULL
 
| "PROMO_NAME" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005154
 
| SYS_C005154
 
| "PROMO_SUBCATEGORY" IS NOT NULL
 
| "PROMO_SUBCATEGORY" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005155
 
| SYS_C005155
 
| "PROMO_SUBCATEGORY_ID" IS NOT NULL
 
| "PROMO_SUBCATEGORY_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005156
 
| SYS_C005156
 
| "PROMO_CATEGORY" IS NOT NULL
 
| "PROMO_CATEGORY" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005157
 
| SYS_C005157
 
| "PROMO_CATEGORY_ID" IS NOT NULL
 
| "PROMO_CATEGORY_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005158
 
| SYS_C005158
 
| "PROMO_COST" IS NOT NULL
 
| "PROMO_COST" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005159
 
| SYS_C005159
 
| "PROMO_BEGIN_DATE" IS NOT NULL
 
| "PROMO_BEGIN_DATE" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005160
 
| SYS_C005160
 
| "PROMO_END_DATE" IS NOT NULL
 
| "PROMO_END_DATE" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005161
 
| SYS_C005161
 
| "PROMO_TOTAL" IS NOT NULL
 
| "PROMO_TOTAL" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005162
 
| SYS_C005162
 
| "PROMO_TOTAL_ID" IS NOT NULL
 
| "PROMO_TOTAL_ID" IS NOT NULL
Line 158: Line 156:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[SH.COSTS_(table)|SH.COSTS]]
 
| [[SH.COSTS_(table)|SH.COSTS]]
 
| PROMO_ID
 
| PROMO_ID
 
| PROMO_ID
 
| PROMO_ID
|-
+
|- valign="top"
 
| [[SH.SALES_(table)|SH.SALES]]
 
| [[SH.SALES_(table)|SH.SALES]]
 
| PROMO_ID
 
| PROMO_ID
 
| PROMO_ID
 
| PROMO_ID
 
|}
 
|}

Latest revision as of 06:16, 24 June 2010

wikibot[edit]

Table SH.PROMOTIONS
Description dimension table without a PK-FK relationship with the facts table, to show outer join functionality

Columns[edit]

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[edit]

Primary Key Columns
PROMO_PK PROMO_ID

Check Constraints[edit]

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[edit]

Detail Table Column Referencing Column
SH.COSTS PROMO_ID PROMO_ID
SH.SALES PROMO_ID PROMO_ID