dbo.DimPromotion
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | DimPromotion |
| Module | Dimensions |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | PromotionKey | int | Identity | |||||
| Identity |
||||||||
| 2 | PromotionAlternateKey | int | ||||||
| 3 | EnglishPromotionName | nvarchar(255) | ||||||
| 4 | SpanishPromotionName | nvarchar(255) | ||||||
| 5 | FrenchPromotionName | nvarchar(255) | ||||||
| 6 | DiscountPct | float | ||||||
| 7 | EnglishPromotionType | nvarchar(50) | ||||||
| 8 | SpanishPromotionType | nvarchar(50) | ||||||
| 9 | FrenchPromotionType | nvarchar(50) | ||||||
| 10 | EnglishPromotionCategory | nvarchar(50) | ||||||
| 11 | SpanishPromotionCategory | nvarchar(50) | ||||||
| 12 | FrenchPromotionCategory | nvarchar(50) | ||||||
| 13 | StartDate | datetime | ||||||
| 14 | EndDate | datetime | ||||||
| 15 | MinQty | int | ||||||
| 16 | MaxQty | int | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.FactInternetSales | dbo.DimPromotion | dbo.FactInternetSales.PromotionKey = dbo.DimPromotion.PromotionKey | FK_FactInternetSales_DimPromotion | |
|
dbo.FactInternetSales.PromotionKey = dbo.DimPromotion.PromotionKey Name: FK_FactInternetSales_DimPromotion |
||||
| dbo.FactResellerSales | dbo.DimPromotion | dbo.FactResellerSales.PromotionKey = dbo.DimPromotion.PromotionKey | FK_FactResellerSales_DimPromotion | |
|
dbo.FactResellerSales.PromotionKey = dbo.DimPromotion.PromotionKey Name: FK_FactResellerSales_DimPromotion |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_DimPromotion_PromotionKey | PromotionKey | ||
| AK_DimPromotion_PromotionAlternateKey | PromotionAlternateKey |
Used by
| Name |
|---|
|
dbo.DimPromotion
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58