ScrewTurn Wiki

Edit

wikibot

TableSH.PROMOTIONS

ColumnData TypeNullableDefaultPKIndex
PROMO_IDNUMBER(6, 0)not null PROMO_PK 
PROMO_NAMEVARCHAR2(30)not null   
PROMO_SUBCATEGORYVARCHAR2(30)not null   
PROMO_SUBCATEGORY_IDNUMBERnot null   
PROMO_CATEGORYVARCHAR2(30)not null   
PROMO_CATEGORY_IDNUMBERnot null   
PROMO_COSTNUMBER(10, 2)not null   
PROMO_BEGIN_DATEDATE(7)not null   
PROMO_END_DATEDATE(7)not null   
PROMO_TOTALVARCHAR2(15)not null   
PROMO_TOTAL_IDNUMBERnot null   



Detail TableColumnReferencing Column
SH.COSTSPROMO_IDPROMO_ID
SH.SALESPROMO_IDPROMO_ID

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