From dbscript Online Help
wikibot[edit]
Columns[edit]
| 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[edit]
| Index
|
Type
|
Columns
|
| COSTS_PROD_BIX
|
|
PROD_ID
|
| COSTS_TIME_BIX
|
|
TIME_ID
|
Check Constraints[edit]
| 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[edit]
