From dbscript Online Help
wikibot
Table
|
Production.ProductSubcategory
|
Description
|
Product subcategories. See ProductCategory table.
|
Columns
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
ProductSubcategoryID
|
int
|
not null
|
|
Primary key for ProductSubcategory records.
|
ProductCategoryID
|
int
|
not null
|
|
Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
|
Name
|
dbo.Name
|
not null
|
|
Subcategory 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
Primary Key
|
Columns
|
PK_ProductSubcategory_ProductSubcategoryID
|
ProductSubcategoryID
|
Indexes
Index
|
Type
|
Columns
|
AK_ProductSubcategory_Name
|
Unique
|
Name
|
AK_ProductSubcategory_rowguid
|
Unique
|
rowguid
|
Foreign Keys
Detail Tables
Detail Table
|
Column
|
Referencing Column
|
Production.Product
|
ProductSubcategoryID
|
ProductSubcategoryID
|
References
Dependency Type
|
Object Type
|
Referenced Object
|
Data Type
|
Type
|
dbo.Name
|
Schema
|
Schema
|
Production
|
automatically generated
Table
|
Production.ProductSubcategory
|
Description
|
Product subcategories. See ProductCategory table.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description / PK / Index
|
ProductSubcategoryID
|
int
|
not null
|
|
Primary key for ProductSubcategory records. PK_ProductSubcategory_ProductSubcategoryID
|
ProductCategoryID
|
int
|
not null
|
|
Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
|
Name
|
Name
|
not null
|
|
Subcategory description. AK_ProductSubcategory_Name
|
rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_ProductSubcategory_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
Detail Table
|
Column
|
Referencing Column
|
Production.Product
|
ProductSubcategoryID
|
ProductSubcategoryID
|
Dependency Type
|
Object Type
|
Referenced Object
|
Data Type
|
Type
|
dbo.Name
|
Schema
|
Schema
|
Production
|