Difference between revisions of "Production.ProductInventory (table)"
Line 169: | Line 169: | ||
| ProductID | | ProductID | ||
| ProductID | | ProductID | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Referenced Object | ||
+ | | '''Object Type | ||
+ | | '''Dependency Type | ||
+ | |||
+ | |- | ||
+ | | [[.Production_(schema)|.Production]] | ||
+ | | Schema | ||
+ | | Schema | ||
|} | |} | ||
Line 177: | Line 190: | ||
| '''Object Type | | '''Object Type | ||
| '''Reference Type | | '''Reference Type | ||
− | + | ||
|- | |- | ||
| [[dbo.ufnGetStock_(function)|dbo.ufnGetStock]] | | [[dbo.ufnGetStock_(function)|dbo.ufnGetStock]] |
Revision as of 06:23, 30 November 2009
wikibot
Table | Production.ProductInventory |
Column | Data Type | Nullable | Default | PK | Index |
ProductID | int | not null | PK_ProductInventory_ProductID_LocationID | ||
LocationID | smallint | not null | PK_ProductInventory_ProductID_LocationID | ||
Shelf | nvarchar(10) | not null | |||
Bin | tinyint | not null | |||
Quantity | smallint | not null | ((0)) | ||
rowguid | uniqueidentifier | not null | (newid()) | ||
ModifiedDate | datetime | not null | (getdate()) |
Relation | Column | Referenced Column |
Production.Location | LocationID | LocationID |
Production.Product | ProductID | ProductID |
automatically generated
Table | Production.ProductInventory |
Description | Product inventory information. |
Column | Data Type | Nullable | Default | Description / PK / Index |
ProductID | int | not null | Product identification number. Foreign key to Product.ProductID. PK_ProductInventory_ProductID_LocationID | |
LocationID | smallint | not null | Inventory location identification number. Foreign key to Location.LocationID. PK_ProductInventory_ProductID_LocationID | |
Shelf | nvarchar(10) | not null | Storage compartment within an inventory location. | |
Bin | tinyint | not null | Storage container on a shelf in an inventory location. | |
Quantity | smallint | not null | (0) | Quantity of products in the inventory location. |
rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
Relation | Column | Referenced Column |
Production.Location | LocationID | LocationID |
Production.Product | ProductID | ProductID |
Referenced Object | Object Type | Dependency Type |
.Production | Schema | Schema |
Referencing Object | Object Type | Reference Type |
dbo.ufnGetStock | Function | Select |