Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
SH PROMOTIONS (table)
Modified on 2011/08/27 12:11
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | SH.PROMOTIONS |- valign="top" | '''Description''' | dimension table without a PK-FK relationship with the facts table, to show outer join functionality |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | PROMO_ID | NUMBER(6, 0) | not null | | primary key column |- valign="top" | PROMO_NAME | VARCHAR2(30) | not null | | promotion description |- valign="top" | PROMO_SUBCATEGORY | VARCHAR2(30) | not null | | enables to investigate promotion hierarchies |- valign="top" | PROMO_SUBCATEGORY_ID | NUMBER | not null | | |- valign="top" | PROMO_CATEGORY | VARCHAR2(30) | not null | | promotion category |- valign="top" | PROMO_CATEGORY_ID | NUMBER | not null | | |- valign="top" | PROMO_COST | NUMBER(10, 2) | not null | | promotion cost, to do promotion effect calculations |- valign="top" | PROMO_BEGIN_DATE | DATE(7) | not null | | promotion begin day |- valign="top" | PROMO_END_DATE | DATE(7) | not null | | promotion end day |- valign="top" | PROMO_TOTAL | VARCHAR2(15) | not null | | |- valign="top" | PROMO_TOTAL_ID | NUMBER | not null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PROMO_PK | PROMO_ID |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | SYS_C005152 | "PROMO_ID" IS NOT NULL | |- valign="top" | SYS_C005153 | "PROMO_NAME" IS NOT NULL | |- valign="top" | SYS_C005154 | "PROMO_SUBCATEGORY" IS NOT NULL | |- valign="top" | SYS_C005155 | "PROMO_SUBCATEGORY_ID" IS NOT NULL | |- valign="top" | SYS_C005156 | "PROMO_CATEGORY" IS NOT NULL | |- valign="top" | SYS_C005157 | "PROMO_CATEGORY_ID" IS NOT NULL | |- valign="top" | SYS_C005158 | "PROMO_COST" IS NOT NULL | |- valign="top" | SYS_C005159 | "PROMO_BEGIN_DATE" IS NOT NULL | |- valign="top" | SYS_C005160 | "PROMO_END_DATE" IS NOT NULL | |- valign="top" | SYS_C005161 | "PROMO_TOTAL" IS NOT NULL | |- valign="top" | SYS_C005162 | "PROMO_TOTAL_ID" IS NOT NULL | |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[SH COSTS (table)|SH.COSTS]] | PROMO_ID | PROMO_ID |- valign="top" | [[SH SALES (table)|SH.SALES]] | PROMO_ID | PROMO_ID |}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.