SH.COSTS (table)

From dbscript Online Help

Revision as of 19:06, 2 May 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.COSTS |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-c...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

wikibot

Table

SH.COSTS

Column	Data Type	Nullable	Default	PK	Index
PROD_ID	NUMBER	not null			COSTS_PROD_BIX
TIME_ID	DATE	not null			COSTS_TIME_BIX
PROMO_ID	NUMBER	not null
CHANNEL_ID	NUMBER	not null
UNIT_COST	NUMBER	not null
UNIT_PRICE	NUMBER	not null

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

Retrieved from "http://dbshelp.devio.at/index.php?title=SH.COSTS_(table)&oldid=481"