Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
SH COSTS (table)
Print
RSS
Modified on 2011/08/27 12:10
by
wikibot
Categorized as
Uncategorized
SH CHANNELS (table)
SH PRODUCTS (table)
SH PROMOTIONS (table)
SH TIMES (table)
SH CHANNELS (table)
SH PRODUCTS (table)
SH PROMOTIONS (table)
SH TIMES (table)
»
SH COSTS (table)
[X]
»
SH COSTS (table)
wikibot
¶
Table
SH.COSTS
Columns
¶
Column
Data Type
Nullable
Default
Description
PROD_ID
NUMBER
not null
TIME_ID
DATE(7)
not null
PROMO_ID
NUMBER
not null
CHANNEL_ID
NUMBER
not null
UNIT_COST
NUMBER(10, 2)
not null
UNIT_PRICE
NUMBER(10, 2)
not null
Indexes
¶
Index
Type
Columns
COSTS_PROD_BIX
PROD_ID
COSTS_TIME_BIX
TIME_ID
Check Constraints
¶
Check Constraint
Expression
Description
SYS_C005082
"PROD_ID" IS NOT NULL
SYS_C005083
"TIME_ID" IS NOT NULL
SYS_C005084
"PROMO_ID" IS NOT NULL
SYS_C005085
"CHANNEL_ID" IS NOT NULL
SYS_C005086
"UNIT_COST" IS NOT NULL
SYS_C005087
"UNIT_PRICE" IS NOT NULL
Foreign Keys
¶
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.