SH.SALES (table) - Revision history

Bot at 09:36, 27 August 2011

2011-08-27T09:36:13Z

Bot at 05:16, 24 June 2010

2010-06-24T05:16:48Z

Bot at 07:29, 11 February 2010

2010-02-11T07:29:47Z

Bot at 19:01, 24 August 2009

2009-08-24T19:01:49Z

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

2009-05-02T17:06:43Z

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

New page

== wikibot ==

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

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

|-
| PROD_ID
| NUMBER
| not null
|
|
| SALES_PROD_BIX
|-
| CUST_ID
| NUMBER
| not null
|
|
| SALES_CUST_BIX
|-
| TIME_ID
| DATE
| not null
|
|
| SALES_TIME_BIX
|-
| CHANNEL_ID
| NUMBER
| not null
|
|
| SALES_CHANNEL_BIX
|-
| PROMO_ID
| NUMBER
| not null
|
|
| SALES_PROMO_BIX
|-
| QUANTITY_SOLD
| NUMBER
| not null
|
|
|
|-
| AMOUNT_SOLD
| NUMBER
| not null
|
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[SH.CHANNELS_(table)|SH.CHANNELS]]
| CHANNEL_ID
| CHANNEL_ID
|-
| [[SH.CUSTOMERS_(table)|SH.CUSTOMERS]]
| CUST_ID
| CUST_ID
|-
| [[SH.PRODUCTS_(table)|SH.PRODUCTS]]
| PROD_ID
| PROD_ID
|-
| [[SH.PROMOTIONS_(table)|SH.PROMOTIONS]]
| PROMO_ID
| PROMO_ID
|-
| [[SH.TIMES_(table)|SH.TIMES]]
| TIME_ID
| TIME_ID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | SH.SALES
@@ Line 8: / Line 8: @@
 | '''Description
 | facts table, without a primary key; all rows are uniquely identified by the combination of all foreign keys
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | PROD_ID
 | NUMBER
@@ Line 27: / Line 25: @@
+|
 | FK to the products dimension table
-|-
+|- valign="top"
 | CUST_ID
 | NUMBER
@@ Line 33: / Line 31: @@
+|
 | FK to the customers dimension table
-|-
+|- valign="top"
 | TIME_ID
 | DATE(7)
@@ Line 39: / Line 37: @@
+|
 | FK to the times dimension table
-|-
+|- valign="top"
 | CHANNEL_ID
 | NUMBER
@@ Line 45: / Line 43: @@
+|
 | FK to the channels dimension table
-|-
+|- valign="top"
 | PROMO_ID
 | NUMBER
@@ Line 51: / Line 49: @@
+|
 | promotion identifier, without FK constraint (intentionally) to show outer join optimization
-|-
+|- valign="top"
 | QUANTITY_SOLD
 | NUMBER(10, 2)
@@ Line 57: / Line 55: @@
+|
 | product quantity sold with the transaction
-|-
+|- valign="top"
 | AMOUNT_SOLD
 | NUMBER(10, 2)
@@ Line 71: / Line 69: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | SALES_CUST_BIX
+|
 | CUST_ID
-|-
+|- valign="top"
 | SALES_CHANNEL_BIX
+|
 | CHANNEL_ID
-|-
+|- valign="top"
 | SALES_TIME_BIX
+|
 | TIME_ID
-|-
+|- valign="top"
 | SALES_PROD_BIX
+|
 | PROD_ID
-|-
+|- valign="top"
 | SALES_PROMO_BIX
+|
@@ Line 100: / Line 98: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | SYS_C005075
 | "PROD_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005076
 | "CUST_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005077
 | "TIME_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005078
 | "CHANNEL_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005079
 | "PROMO_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005080
 | "QUANTITY_SOLD" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005081
 | "AMOUNT_SOLD" IS NOT NULL
@@ Line 137: / Line 135: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[SH.CHANNELS_(table)|SH.CHANNELS]]
 | CHANNEL_ID
 | CHANNEL_ID
-|-
+|- valign="top"
 | [[SH.CUSTOMERS_(table)|SH.CUSTOMERS]]
 | CUST_ID
 | CUST_ID
-|-
+|- valign="top"
 | [[SH.PRODUCTS_(table)|SH.PRODUCTS]]
 | PROD_ID
 | PROD_ID
-|-
+|- valign="top"
 | [[SH.PROMOTIONS_(table)|SH.PROMOTIONS]]
 | PROMO_ID
 | PROMO_ID
-|-
+|- valign="top"
 | [[SH.TIMES_(table)|SH.TIMES]]
 | TIME_ID
 | TIME_ID
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | SH.SALES
 |-
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 15: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description
 |-
@@ Line 23: / Line 26: @@
 | not null
+|
+| FK to the products dimension table
 |-
 | CUST_ID
@@ Line 30: / Line 32: @@
 | not null
+|
+| FK to the customers dimension table
 |-
 | TIME_ID
@@ Line 37: / Line 38: @@
 | not null
+|
+| FK to the times dimension table
 |-
 | CHANNEL_ID
@@ Line 44: / Line 44: @@
 | not null
+|
+| FK to the channels dimension table
 |-
 | PROMO_ID
@@ Line 51: / Line 50: @@
 | not null
+|
+| promotion identifier, without FK constraint (intentionally) to show outer join optimization
 |-
 | QUANTITY_SOLD
@@ Line 58: / Line 56: @@
 | not null
+|
+| product quantity sold with the transaction
 |-
 | AMOUNT_SOLD
@@ Line 65: / Line 62: @@
 | not null
+|
+|
+|
 |}
+=== Foreign Keys ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"