Production.ProductModel

Table: 'Production.ProductModel'

6 fields. 136 bytes.

Product model classification.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ProductModelID	int identity		int		Not null	Primary key for ProductModel records.
Name	Name		nvarchar(50)		Not null	Product model description.
CatalogDescription	xml				Null	Detailed product catalog information in xml format.
Instructions	xml				Null	Manufacturing instructions in xml format.
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductModel'

Primary Key Name	Field Name
PK_ProductModel_ProductModelID	ProductModelID

There are no Foreign Keys for this table.

Indexes for table 'Production.ProductModel', 3 items

Index Name	Description	Clustered	Unique	Fields
PK_ProductModel_ProductModelID	Clustered index created by a primary key constraint.	Yes	Yes	ProductModelID
AK_ProductModel_Name	Unique nonclustered index.	No	Yes	Name
AK_ProductModel_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Production.ProductModel', 1 item

Name	Description	Type	Enabled
uProductModel	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModel table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductModel', 4 items

Object Name	Type	Field Name
Production.uProductModel	trigger	N/A
Production.vProductAndDescription	view	N/A
Production.vProductModelCatalogDescription	view	N/A
Production.vProductModelInstructions	view	N/A