Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: SH COSTS (table)

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2010/06/24 08:00


wikibot

TableSH.COSTS

Columns

ColumnData TypeNullableDefaultDescription
PROD_IDNUMBERnot null  
TIME_IDDATE(7)not null  
PROMO_IDNUMBERnot null  
CHANNEL_IDNUMBERnot null  
UNIT_COSTNUMBER(10, 2)not null  
UNIT_PRICENUMBER(10, 2)not null  

Indexes

IndexTypeColumns
COSTS_PROD_BIX PROD_ID
COSTS_TIME_BIX TIME_ID

Check Constraints

Check ConstraintExpressionDescription
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

RelationColumnReferenced Column
SH.CHANNELSCHANNEL_IDCHANNEL_ID
SH.PRODUCTSPROD_IDPROD_ID
SH.PROMOTIONSPROMO_IDPROMO_ID
SH.TIMESTIME_IDTIME_ID

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewSH.PROFITS

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.