SH.SALES (table)

wikibot

Table

SH.SALES

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(7)	not null			SALES_TIME_BIX
CHANNEL_ID	NUMBER	not null			SALES_CHANNEL_BIX
PROMO_ID	NUMBER	not null			SALES_PROMO_BIX
QUANTITY_SOLD	NUMBER(10, 2)	not null
AMOUNT_SOLD	NUMBER(10, 2)	not null

Relation	Column	Referenced Column
SH.CHANNELS	CHANNEL_ID	CHANNEL_ID
SH.CUSTOMERS	CUST_ID	CUST_ID
SH.PRODUCTS	PROD_ID	PROD_ID
SH.PROMOTIONS	PROMO_ID	PROMO_ID
SH.TIMES	TIME_ID	TIME_ID