| Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| PROD_ID
|
NUMBER(6,0)
|
N
|
|
FK to the products dimension table
|
| CUST_ID
|
NUMBER(,)
|
N
|
|
FK to the customers dimension table
|
| TIME_ID
|
DATE
|
N
|
|
FK to the times dimension table
|
| CHANNEL_ID
|
CHAR(1)
|
N
|
|
FK to the channels dimension table
|
| PROMO_ID
|
NUMBER(6,0)
|
N
|
|
promotion identifier, without FK constraint (intentionally) to show outer join optimization
|
| QUANTITY_SOLD
|
NUMBER(3,0)
|
N
|
|
product quantity sold with the transaction
|
| AMOUNT_SOLD
|
NUMBER(10,2)
|
N
|
|
invoiced amount to the customer
|