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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductCategory |- |} {| border="1" cellpadding="5" cellspacing="...)
 
 
(10 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.ProductCategory
 
| Production.ProductCategory
−
|-
+
|- valign="top"
 +
| '''Description
 +
| High-level product categorization.
 
|}
 
|}
  
−
 
+
=== 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"
−
|-
 
 
| ProductCategoryID
 
| ProductCategoryID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductCategory_ProductCategoryID
+
| Primary key for ProductCategory records.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Category description.
−
| AK_ProductCategory_Name
+
|- 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.
−
| AK_ProductCategory_rowguid
+
|- 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_ProductCategory_ProductCategoryID
 +
| ProductCategoryID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| AK_ProductCategory_Name
 +
| Unique
 +
| Name
 +
|- valign="top"
 +
| AK_ProductCategory_rowguid
 +
| Unique
 +
| rowguid
 +
|}
 +
 +
=== Detail Tables ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|- valign="top"
 +
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 +
| ProductCategoryID
 +
| ProductCategoryID
 +
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductCategory
 +
|- valign="top"
 +
| '''Description
 +
| High-level product categorization.
 +
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description / PK / Index
 +
 +
|- valign="top"
 +
| ProductCategoryID
 +
| int
 +
| not null
 
|  
 
|  
 +
| Primary key for ProductCategory records.<br />PK_ProductCategory_ProductCategoryID
 +
|- valign="top"
 +
| Name
 +
| Name
 +
| not null
 
|  
 
|  
 +
| Category description.<br />AK_ProductCategory_Name
 +
|- valign="top"
 +
| rowguid
 +
| uniqueidentifier
 +
| not null
 +
| (NEWID())
 +
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ProductCategory_rowguid
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 60: Line 164:
 
| ProductCategoryID
 
| ProductCategoryID
 
| ProductCategoryID
 
| ProductCategoryID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 
|}
 
|}

Latest revision as of 23:16, 23 June 2010

wikibot[edit]

Table Production.ProductCategory
Description High-level product categorization.

Columns[edit]

Column Data Type Nullable Default Description
ProductCategoryID int not null Primary key for ProductCategory records.
Name dbo.Name not null Category description.
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_ProductCategory_ProductCategoryID ProductCategoryID

Indexes[edit]

Index Type Columns
AK_ProductCategory_Name Unique Name
AK_ProductCategory_rowguid Unique rowguid

Detail Tables[edit]

Detail Table Column Referencing Column
Production.ProductSubcategory ProductCategoryID ProductCategoryID

References[edit]

Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production


automatically generated[edit]

Table Production.ProductCategory
Description High-level product categorization.


Column Data Type Nullable Default Description / PK / Index
ProductCategoryID int not null Primary key for ProductCategory records.
PK_ProductCategory_ProductCategoryID
Name Name not null Category description.
AK_ProductCategory_Name
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_ProductCategory_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Production.ProductSubcategory ProductCategoryID ProductCategoryID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductCategory_(table)&oldid=2628"