Warehouse.PackageTypes
Documentation | WideWorldImporters |
Schema | Warehouse |
Name | PackageTypes |
Module | Warehouse |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | PackageTypeID | int | Default: NEXT VALUE FOR [Sequences].[PackageTypeID] | Numeric ID used for reference to a package type within the database | ||||
Numeric ID used for reference to a package type within the database Default: NEXT VALUE FOR [Sequences].[PackageTypeID] |
||||||||
2 | PackageTypeName | nvarchar(50) | Full name of package types that stock items can be purchased in or sold in | |||||
Full name of package types that stock items can be purchased in or sold in |
||||||||
3 | LastEditedBy | int | Application.People | |||||
References: Application.People | ||||||||
4 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
5 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Warehouse.PackageTypes | Application.People | Warehouse.PackageTypes.LastEditedBy = Application.People.PersonID | FK_Warehouse_PackageTypes_Application_People Foreign key constraint referencing People.PersonID |
|
Warehouse.PackageTypes.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_PackageTypes_Application_PeopleForeign key constraint referencing People.PersonID |
||||
Sales.InvoiceLines | Warehouse.PackageTypes | Sales.InvoiceLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID | FK_Sales_InvoiceLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID |
|
Sales.InvoiceLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID Name: FK_Sales_InvoiceLines_PackageTypeID_Warehouse_PackageTypesForeign key constraint referencing PackageTypes.PackageTypeID |
||||
Sales.OrderLines | Warehouse.PackageTypes | Sales.OrderLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID | FK_Sales_OrderLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID |
|
Sales.OrderLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID Name: FK_Sales_OrderLines_PackageTypeID_Warehouse_PackageTypesForeign key constraint referencing PackageTypes.PackageTypeID |
||||
Purchasing.PurchaseOrderLines | Warehouse.PackageTypes | Purchasing.PurchaseOrderLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID | FK_Purchasing_PurchaseOrderLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID |
|
Purchasing.PurchaseOrderLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID Name: FK_Purchasing_PurchaseOrderLines_PackageTypeID_Warehouse_PackageTypesForeign key constraint referencing PackageTypes.PackageTypeID |
||||
Warehouse.StockItems | Warehouse.PackageTypes | Warehouse.StockItems.OuterPackageID = Warehouse.PackageTypes.PackageTypeID | FK_Warehouse_StockItems_OuterPackageID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID |
|
Warehouse.StockItems.OuterPackageID = Warehouse.PackageTypes.PackageTypeID Name: FK_Warehouse_StockItems_OuterPackageID_Warehouse_PackageTypesForeign key constraint referencing PackageTypes.PackageTypeID |
||||
Warehouse.StockItems | Warehouse.PackageTypes | Warehouse.StockItems.UnitPackageID = Warehouse.PackageTypes.PackageTypeID | FK_Warehouse_StockItems_UnitPackageID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID |
|
Warehouse.StockItems.UnitPackageID = Warehouse.PackageTypes.PackageTypeID Name: FK_Warehouse_StockItems_UnitPackageID_Warehouse_PackageTypesForeign key constraint referencing PackageTypes.PackageTypeID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Warehouse_PackageTypes | PackageTypeID | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. | |||
UQ_Warehouse_PackageTypes_PackageTypeName | PackageTypeName | Unique nonclustered index. | |
Unique nonclustered index. |
Uses
Name |
---|
Warehouse.PackageTypes
|
Used by
Name |
---|
Warehouse.PackageTypes
|
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51