SH.PROMOTIONS (table) - Revision history

Bot at 05:16, 24 June 2010

2010-06-24T05:16:47Z

Bot at 07:29, 11 February 2010

2010-02-11T07:29:45Z

Bot at 19:01, 24 August 2009

2009-08-24T19:01:47Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.PROMOTIONS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...

2009-05-02T17:06:42Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.PROMOTIONS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| SH.PROMOTIONS
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column
| '''Data Type
| '''Nullable
| '''Default
| '''PK
| '''Index

|-
| PROMO_ID
| NUMBER
| not null
|
| PROMO_PK
|
|-
| PROMO_NAME
| VARCHAR2
| not null
|
|
|
|-
| PROMO_SUBCATEGORY
| VARCHAR2
| not null
|
|
|
|-
| PROMO_SUBCATEGORY_ID
| NUMBER
| not null
|
|
|
|-
| PROMO_CATEGORY
| VARCHAR2
| not null
|
|
|
|-
| PROMO_CATEGORY_ID
| NUMBER
| not null
|
|
|
|-
| PROMO_COST
| NUMBER
| not null
|
|
|
|-
| PROMO_BEGIN_DATE
| DATE
| not null
|
|
|
|-
| PROMO_END_DATE
| DATE
| not null
|
|
|
|-
| PROMO_TOTAL
| VARCHAR2
| not null
|
|
|
|-
| PROMO_TOTAL_ID
| NUMBER
| not null
|
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[SH.COSTS_(table)|SH.COSTS]]
| PROMO_ID
| PROMO_ID
|-
| [[SH.SALES_(table)|SH.SALES]]
| PROMO_ID
| PROMO_ID
|}

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