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

From dbscript Online Help
Jump to: navigation, search
 
(9 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.ProductInventory
 
| Production.ProductInventory
|-
+
|- valign="top"
 +
| '''Description
 +
| Product inventory information.
 
|}
 
|}
  
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
+
 
+
|- valign="top"
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_ProductInventory_ProductID_LocationID
+
| Product identification number. Foreign key to Product.ProductID.
|
+
|- valign="top"
|-
 
 
| LocationID
 
| LocationID
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
| PK_ProductInventory_ProductID_LocationID
+
| Inventory location identification number. Foreign key to Location.LocationID.
|
+
|- valign="top"
|-
 
 
| Shelf
 
| Shelf
 
| nvarchar(10)
 
| nvarchar(10)
 
| not null
 
| not null
 
|  
 
|  
|  
+
| Storage compartment within an inventory location.
|
+
|- valign="top"
|-
 
 
| Bin
 
| Bin
 
| tinyint
 
| tinyint
 
| not null
 
| not null
 
|  
 
|  
|  
+
| Storage container on a shelf in an inventory location.
|
+
|- valign="top"
|-
 
 
| Quantity
 
| Quantity
 
| smallint
 
| smallint
 
| not null
 
| not null
 
| ((0))
 
| ((0))
|  
+
| Quantity of products in the inventory location.
|
+
|- valign="top"
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (newid())
 
| (newid())
|  
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
+
|- valign="top"
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
|  
+
| Date and time the record was last updated.
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_ProductInventory_ProductID_LocationID
 +
| ProductID, LocationID
 
|}
 
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
  
 +
|- valign="top"
 +
| CK_ProductInventory_Bin
 +
| ([Bin]>=(0) AND [Bin]<=(100))
 +
| Check constraint [Bin] BETWEEN (0) AND (100)
 +
|- valign="top"
 +
| CK_ProductInventory_Shelf
 +
| ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')
 +
| Check constraint [Shelf] like '[A-Za-z]' OR [Shelf]='N/A'
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 76: Line 96:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[Production.Location_(table)|Production.Location]]
 
| [[Production.Location_(table)|Production.Location]]
 
| LocationID
 
| LocationID
 
| LocationID
 
| LocationID
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| Function
 +
| [[dbo.ufnGetStock_(function)|dbo.ufnGetStock]]
 +
 +
|}
 +
  
 
== automatically generated ==
 
== automatically generated ==
Line 93: Line 142:
 
| '''Table
 
| '''Table
 
| Production.ProductInventory
 
| Production.ProductInventory
|-
+
|- valign="top"
 
 
 
| '''Description
 
| '''Description
 
| Product inventory information.
 
| Product inventory information.
 
|-
 
|-
 
 
|}
 
|}
  
Line 108: Line 155:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''Description
+
| '''Description / PK / Index
| '''PK / Index
 
 
 
|-
+
|- valign="top"
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| Product identification number. Foreign key to Product.ProductID.
+
| Product identification number. Foreign key to Product.ProductID.<br />PK_ProductInventory_ProductID_LocationID
| PK_ProductInventory_ProductID_LocationID
+
|- valign="top"
|-
 
 
| LocationID
 
| LocationID
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
| Inventory location identification number. Foreign key to Location.LocationID.  
+
| Inventory location identification number. Foreign key to Location.LocationID. <br />PK_ProductInventory_ProductID_LocationID
| PK_ProductInventory_ProductID_LocationID
+
|- valign="top"
|-
 
 
| Shelf
 
| Shelf
 
| nvarchar(10)
 
| nvarchar(10)
 
| not null
 
| not null
 
|  
 
|  
| Storage compartment within an inventory location.
+
| Storage compartment within an inventory location.<br />
|
+
|- valign="top"
|-
 
 
| Bin
 
| Bin
 
| tinyint
 
| tinyint
 
| not null
 
| not null
 
|  
 
|  
| Storage container on a shelf in an inventory location.
+
| Storage container on a shelf in an inventory location.<br />
|
+
|- valign="top"
|-
 
 
| Quantity
 
| Quantity
 
| smallint
 
| smallint
 
| not null
 
| not null
 
| (0)
 
| (0)
| Quantity of products in the inventory location.
+
| Quantity of products in the inventory location.<br />
|
+
|- valign="top"
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (NEWID())
 
| (NEWID())
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />
|
+
|- valign="top"
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
|
 
 
|}
 
|}
  
Line 178: Line 217:
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| Function
 +
| [[dbo.ufnGetStock_(function)|dbo.ufnGetStock]]
 +
 
|}
 
|}

Latest revision as of 23:16, 23 June 2010

wikibot[edit]

Table Production.ProductInventory
Description Product inventory information.

Columns[edit]

Column Data Type Nullable Default Description
ProductID int not null Product identification number. Foreign key to Product.ProductID.
LocationID smallint not null Inventory location identification number. Foreign key to Location.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.

Primary Key[edit]

Primary Key Columns
PK_ProductInventory_ProductID_LocationID ProductID, LocationID

Check Constraints[edit]

Check Constraint Expression Description
CK_ProductInventory_Bin ([Bin]>=(0) AND [Bin]<=(100)) Check constraint [Bin] BETWEEN (0) AND (100)
CK_ProductInventory_Shelf ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A') Check constraint [Shelf] like '[A-Za-z]' OR [Shelf]='N/A'

Foreign Keys[edit]

Relation Column Referenced Column
Production.Location LocationID LocationID
Production.Product ProductID ProductID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production

Dependencies[edit]

Reference Type Object Type Referencing Object
Select Function dbo.ufnGetStock


automatically generated[edit]

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


Dependency Type Object Type Referenced Object
Schema Schema Production


Reference Type Object Type Referencing Object
Select Function dbo.ufnGetStock