From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| PROMO_ID
|
NUMBER(6, 0)
|
not null
|
|
PROMO_PK
|
|
| PROMO_NAME
|
VARCHAR2(30)
|
not null
|
|
|
|
| PROMO_SUBCATEGORY
|
VARCHAR2(30)
|
not null
|
|
|
|
| PROMO_SUBCATEGORY_ID
|
NUMBER
|
not null
|
|
|
|
| PROMO_CATEGORY
|
VARCHAR2(30)
|
not null
|
|
|
|
| PROMO_CATEGORY_ID
|
NUMBER
|
not null
|
|
|
|
| PROMO_COST
|
NUMBER(10, 2)
|
not null
|
|
|
|
| PROMO_BEGIN_DATE
|
DATE(7)
|
not null
|
|
|
|
| PROMO_END_DATE
|
DATE(7)
|
not null
|
|
|
|
| PROMO_TOTAL
|
VARCHAR2(15)
|
not null
|
|
|
|
| PROMO_TOTAL_ID
|
NUMBER
|
not null
|
|
|
|
| Detail Table
|
Column
|
Referencing Column
|
| SH.COSTS
|
PROMO_ID
|
PROMO_ID
|
| SH.SALES
|
PROMO_ID
|
PROMO_ID
|
