dbo.FactInternetSalesReason
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | FactInternetSalesReason |
| Module | Internet Sales |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | SalesOrderNumber | nvarchar(20) | dbo.FactInternetSales | |||||
| References: dbo.FactInternetSales | ||||||||
| 2 | SalesOrderLineNumber | tinyint | dbo.FactInternetSales | |||||
| References: dbo.FactInternetSales | ||||||||
| 3 | SalesReasonKey | int | dbo.DimSalesReason | |||||
| References: dbo.DimSalesReason | ||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.FactInternetSalesReason | dbo.DimSalesReason | dbo.FactInternetSalesReason.SalesReasonKey = dbo.DimSalesReason.SalesReasonKey | FK_FactInternetSalesReason_DimSalesReason | |
|
dbo.FactInternetSalesReason.SalesReasonKey = dbo.DimSalesReason.SalesReasonKey Name: FK_FactInternetSalesReason_DimSalesReason |
||||
| dbo.FactInternetSalesReason | dbo.FactInternetSales | dbo.FactInternetSalesReason.SalesOrderLineNumber = dbo.FactInternetSales.SalesOrderLineNumber dbo.FactInternetSalesReason.SalesOrderNumber = dbo.FactInternetSales.SalesOrderNumber |
FK_FactInternetSalesReason_FactInternetSales | |
|
dbo.FactInternetSalesReason.SalesOrderLineNumber = dbo.FactInternetSales.SalesOrderLineNumber Name: FK_FactInternetSalesReason_FactInternetSalesdbo.FactInternetSalesReason.SalesOrderNumber = dbo.FactInternetSales.SalesOrderNumber |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_FactInternetSalesReason_SalesOrderNumber_SalesOrderLineNumber_SalesReasonKey | SalesOrderNumber, SalesOrderLineNumber, SalesReasonKey |
Uses
| Name |
|---|
|
dbo.FactInternetSalesReason
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58