ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
SH.COSTS_(table)
Print
RSS
Modified: 2010/06/24 06:52 by
wikibot
-
Uncategorized
(10)
»
HR.EMPLOYEES_(table)
»
public.outages_(table)
»
SH.COSTS_(table)
[X]
»
Purchasing.ProductVendor_(table)
»
public.service_(table)
»
Purchasing.VendorAddress_(table)
»
OE.ORDER_ITEMS_(table)
»
OE.ORDERS_(table)
»
Production.UnitMeasure_(table)
»
HR.REGIONS_(table)
»
HR.EMPLOYEES_(table)
»
public.outages_(table)
»
SH.COSTS_(table)
Edit
wikibot
Table
SH.COSTS
Edit
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
Edit
Indexes
Index
Type
Columns
COSTS_PROD_BIX
PROD_ID
COSTS_TIME_BIX
TIME_ID
Edit
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
Edit
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
Edit
Dependencies
Reference Type
Object Type
Referencing Object
Select
View
SH.PROFITS
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.