Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableSH.CHANNELS
Descriptionsmall dimension table

Columns

ColumnData TypeNullableDefaultDescription
CHANNEL_IDNUMBERnot null primary key column
CHANNEL_DESCVARCHAR2(20)not null e.g. telesales, internet, catalog
CHANNEL_CLASSVARCHAR2(20)not null e.g. direct, indirect
CHANNEL_CLASS_IDNUMBERnot null  
CHANNEL_TOTALVARCHAR2(13)not null  
CHANNEL_TOTAL_IDNUMBERnot null  

Primary Key

Primary KeyColumns
CHANNELS_PKCHANNEL_ID

Check Constraints

Check ConstraintExpressionDescription
SYS_C005145"CHANNEL_ID" IS NOT NULL 
SYS_C005146"CHANNEL_DESC" IS NOT NULL 
SYS_C005147"CHANNEL_CLASS" IS NOT NULL 
SYS_C005148"CHANNEL_CLASS_ID" IS NOT NULL 
SYS_C005149"CHANNEL_TOTAL" IS NOT NULL 
SYS_C005150"CHANNEL_TOTAL_ID" IS NOT NULL 

Detail Tables

Detail TableColumnReferencing Column
SH.COSTSCHANNEL_IDCHANNEL_ID
SH.SALESCHANNEL_IDCHANNEL_ID

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