Warehouse.StockItemStockGroups
Documentation | WideWorldImporters |
Schema | Warehouse |
Name | StockItemStockGroups |
Module | Warehouse |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | StockItemStockGroupID | int | Default: NEXT VALUE FOR [Sequences].[StockItemStockGroupID] | Internal reference for this linking row | ||||
Internal reference for this linking row Default: NEXT VALUE FOR [Sequences].[StockItemStockGroupID] |
||||||||
2 | StockItemID | int | Warehouse.StockItems | Stock item assigned to this stock group (FK indexed via unique constraint) | ||||
Stock item assigned to this stock group (FK indexed via unique constraint) References: Warehouse.StockItems |
||||||||
3 | StockGroupID | int | Warehouse.StockGroups | StockGroup assigned to this stock item (FK indexed via unique constraint) | ||||
StockGroup assigned to this stock item (FK indexed via unique constraint) References: Warehouse.StockGroups |
||||||||
4 | LastEditedBy | int | Application.People | |||||
References: Application.People | ||||||||
5 | LastEditedWhen | datetime2(7) | Default: sysdatetime() | When this row was last edited | ||||
When this row was last edited Default: sysdatetime() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Warehouse.StockItemStockGroups | Application.People | Warehouse.StockItemStockGroups.LastEditedBy = Application.People.PersonID | FK_Warehouse_StockItemStockGroups_Application_People Foreign key constraint referencing People.PersonID |
|
Warehouse.StockItemStockGroups.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItemStockGroups_Application_PeopleForeign key constraint referencing People.PersonID |
||||
Warehouse.StockItemStockGroups | Warehouse.StockGroups | Warehouse.StockItemStockGroups.StockGroupID = Warehouse.StockGroups.StockGroupID | FK_Warehouse_StockItemStockGroups_StockGroupID_Warehouse_StockGroups Foreign key constraint referencing StockGroups.StockGroupID |
|
Warehouse.StockItemStockGroups.StockGroupID = Warehouse.StockGroups.StockGroupID Name: FK_Warehouse_StockItemStockGroups_StockGroupID_Warehouse_StockGroupsForeign key constraint referencing StockGroups.StockGroupID |
||||
Warehouse.StockItemStockGroups | Warehouse.StockItems | Warehouse.StockItemStockGroups.StockItemID = Warehouse.StockItems.StockItemID | FK_Warehouse_StockItemStockGroups_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID |
|
Warehouse.StockItemStockGroups.StockItemID = Warehouse.StockItems.StockItemID Name: FK_Warehouse_StockItemStockGroups_StockItemID_Warehouse_StockItemsForeign key constraint referencing StockItems.StockItemID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Warehouse_StockItemStockGroups | StockItemStockGroupID | Primary key (clustered) constraint. | |
Primary key (clustered) constraint. | |||
UQ_StockItemStockGroups_StockGroupID_Lookup | StockGroupID, StockItemID | Unique nonclustered index. | |
Unique nonclustered index. | |||
UQ_StockItemStockGroups_StockItemID_Lookup | StockItemID, StockGroupID | Unique nonclustered index. | |
Unique nonclustered index. |
Uses
Name |
---|
Warehouse.StockItemStockGroups
|
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51