Difference between revisions of "Production.ProductInventory (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductInventory |- |} {| border="1" cellpadding="5" cellspacing=...)
 
Line 66: Line 66:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Production.Location_(table)|Production.Location]]
 +
| LocationID
 +
| LocationID
 +
|-
 +
| [[Production.Product_(table)|Production.Product]]
 +
| ProductID
 +
| ProductID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductInventory
 +
|-
 +
 +
| '''Description
 +
| Product inventory information.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:26, 26 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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductInventory_(table)&oldid=1104"