Difference between revisions of "Production.Product (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.Product |- |} {| border="1" cellpadding="5" cellspacing="0" style...) |
|||
Line 97: | Line 97: | ||
|- | |- | ||
| SizeUnitMeasureCode | | SizeUnitMeasureCode | ||
− | | nchar( | + | | nchar(3) |
| null | | null | ||
| | | | ||
Line 104: | Line 104: | ||
|- | |- | ||
| WeightUnitMeasureCode | | WeightUnitMeasureCode | ||
− | | nchar( | + | | nchar(3) |
| null | | null | ||
| | | | ||
Line 125: | Line 125: | ||
|- | |- | ||
| ProductLine | | ProductLine | ||
− | | nchar( | + | | nchar(2) |
| null | | null | ||
| | | | ||
Line 132: | Line 132: | ||
|- | |- | ||
| Class | | Class | ||
− | | nchar( | + | | nchar(2) |
| null | | null | ||
| | | | ||
Line 139: | Line 139: | ||
|- | |- | ||
| Style | | Style | ||
− | | nchar( | + | | nchar(2) |
| null | | null | ||
| | | |
Revision as of 16:30, 3 January 2009
wikibot
Table | Production.Product |
Column | Data Type | Nullable | Default | PK | Index |
ProductID | int | not null | PK_Product_ProductID | ||
Name | dbo.Name | not null | AK_Product_Name | ||
ProductNumber | nvarchar(25) | not null | AK_Product_ProductNumber | ||
MakeFlag | dbo.Flag | not null | ((1)) | ||
FinishedGoodsFlag | dbo.Flag | not null | ((1)) | ||
Color | nvarchar(15) | null | |||
SafetyStockLevel | smallint | not null | |||
ReorderPoint | smallint | not null | |||
StandardCost | money | not null | |||
ListPrice | money | not null | |||
Size | nvarchar(5) | null | |||
SizeUnitMeasureCode | nchar(3) | null | |||
WeightUnitMeasureCode | nchar(3) | null | |||
Weight | decimal(8, 2) | null | |||
DaysToManufacture | int | not null | |||
ProductLine | nchar(2) | null | |||
Class | nchar(2) | null | |||
Style | nchar(2) | null | |||
ProductSubcategoryID | int | null | |||
ProductModelID | int | null | |||
SellStartDate | datetime | not null | |||
SellEndDate | datetime | null | |||
DiscontinuedDate | datetime | null | |||
rowguid | uniqueidentifier | not null | (newid()) | AK_Product_rowguid | |
ModifiedDate | datetime | not null | (getdate()) |
Relation | Column | Referenced Column |
Production.ProductModel | ProductModelID | ProductModelID |
Production.ProductSubcategory | ProductSubcategoryID | ProductSubcategoryID |
Production.UnitMeasure | SizeUnitMeasureCode | UnitMeasureCode |
Production.UnitMeasure | WeightUnitMeasureCode | UnitMeasureCode |
Detail Table | Column | Referencing Column |
Production.BillOfMaterials | ProductID | ComponentID |
Production.BillOfMaterials | ProductID | ProductAssemblyID |
Production.ProductCostHistory | ProductID | ProductID |
Production.ProductDocument | ProductID | ProductID |
Production.ProductInventory | ProductID | ProductID |
Production.ProductListPriceHistory | ProductID | ProductID |
Production.ProductProductPhoto | ProductID | ProductID |
Production.ProductReview | ProductID | ProductID |
Purchasing.ProductVendor | ProductID | ProductID |
Purchasing.PurchaseOrderDetail | ProductID | ProductID |
Sales.ShoppingCartItem | ProductID | ProductID |
Sales.SpecialOfferProduct | ProductID | ProductID |
Production.TransactionHistory | ProductID | ProductID |
Production.WorkOrder | ProductID | ProductID |