dbo.FactProductInventory
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | FactProductInventory |
| Module | Inventory |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ProductKey | int | dbo.DimProduct | |||||
| References: dbo.DimProduct | ||||||||
| 2 | DateKey | int | dbo.DimDate | |||||
| References: dbo.DimDate | ||||||||
| 3 | MovementDate | date | ||||||
| 4 | UnitCost | money | ||||||
| 5 | UnitsIn | int | ||||||
| 6 | UnitsOut | int | ||||||
| 7 | UnitsBalance | int | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.FactProductInventory | dbo.DimDate | dbo.FactProductInventory.DateKey = dbo.DimDate.DateKey | FK_FactProductInventory_DimDate | |
|
dbo.FactProductInventory.DateKey = dbo.DimDate.DateKey Name: FK_FactProductInventory_DimDate |
||||
| dbo.FactProductInventory | dbo.DimProduct | dbo.FactProductInventory.ProductKey = dbo.DimProduct.ProductKey | FK_FactProductInventory_DimProduct | |
|
dbo.FactProductInventory.ProductKey = dbo.DimProduct.ProductKey Name: FK_FactProductInventory_DimProduct |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_FactProductInventory | ProductKey, DateKey |
Uses
| Name |
|---|
|
dbo.FactProductInventory
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58