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)
public location_monitors (table)
HR COUNTRIES (table)
Production (schema)
Production Culture (table)
Production ProductDescription (table)
Production ProductModel (table)
Production vProductAndDescription (view)
SH CHANNELS (table)
SH PRODUCTS (table)
SH PROMOTIONS (table)
SH TIMES (table)
public location_monitors (table)
HR COUNTRIES (table)
(4)
»
HR REGIONS (table)
»
public location_monitor_details (table)
»
SH COSTS (table)
[X]
»
Production ProductModelProductDescriptionCulture (table)
»
HR REGIONS (table)
»
public location_monitor_details (table)
»
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
.