From dbscript Online Help
wikibot
| Table
|
SH.CHANNELS
|
| Description
|
small dimension table
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| CHANNEL_ID
|
NUMBER
|
not null
|
|
primary key column
|
| CHANNEL_DESC
|
VARCHAR2(20)
|
not null
|
|
e.g. telesales, internet, catalog
|
| CHANNEL_CLASS
|
VARCHAR2(20)
|
not null
|
|
e.g. direct, indirect
|
| CHANNEL_CLASS_ID
|
NUMBER
|
not null
|
|
|
| CHANNEL_TOTAL
|
VARCHAR2(13)
|
not null
|
|
|
| CHANNEL_TOTAL_ID
|
NUMBER
|
not null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| CHANNELS_PK
|
CHANNEL_ID
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| 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 Table
|
Column
|
Referencing Column
|
| SH.COSTS
|
CHANNEL_ID
|
CHANNEL_ID
|
| SH.SALES
|
CHANNEL_ID
|
CHANNEL_ID
|
