SH SALES (table)

Modified on 2011/08/27 12:11 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| SH.SALES
|- valign="top"
| '''Description'''
| facts table, without a primary key; all rows are uniquely identified by the combination of all foreign keys
|}

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

|- valign="top"
| PROD_ID
| NUMBER
| not null
| &nbsp;
| FK to the products dimension table
|- valign="top"
| CUST_ID
| NUMBER
| not null
| &nbsp;
| FK to the customers dimension table
|- valign="top"
| TIME_ID
| DATE(7)
| not null
| &nbsp;
| FK to the times dimension table
|- valign="top"
| CHANNEL_ID
| NUMBER
| not null
| &nbsp;
| FK to the channels dimension table
|- valign="top"
| PROMO_ID
| NUMBER
| not null
| &nbsp;
| promotion identifier, without FK constraint (intentionally) to show outer join optimization
|- valign="top"
| QUANTITY_SOLD
| NUMBER(10, 2)
| not null
| &nbsp;
| product quantity sold with the transaction
|- valign="top"
| AMOUNT_SOLD
| NUMBER(10, 2)
| not null
| &nbsp;
| invoiced amount to the customer
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| SALES_CHANNEL_BIX
| &nbsp;
| CHANNEL_ID
|- valign="top"
| SALES_CUST_BIX
| &nbsp;
| CUST_ID
|- valign="top"
| SALES_PROD_BIX
| &nbsp;
| PROD_ID
|- valign="top"
| SALES_PROMO_BIX
| &nbsp;
| PROMO_ID
|- valign="top"
| SALES_TIME_BIX
| &nbsp;
| TIME_ID
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| SYS_C005075
| "PROD_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005076
| "CUST_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005077
| "TIME_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005078
| "CHANNEL_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005079
| "PROMO_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005080
| "QUANTITY_SOLD" IS NOT NULL
| &nbsp;
|- valign="top"
| SYS_C005081
| "AMOUNT_SOLD" IS NOT NULL
| &nbsp;
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''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
|}
devio dbscript ScrewTurn Wiki

Navigation¶

SH SALES (table)
