Production.ProductDescription
| Documentation | AdventureWorks |
| Schema | Production |
| Name | ProductDescription |
| Module | Products |
Product descriptions in several languages.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ProductDescriptionID | int | Identity | Primary key for ProductDescription records. | ||||
| Primary key for ProductDescription records. Identity |
||||||||
| 2 | Description | nvarchar(400) | Description of the product. | |||||
| Description of the product. |
||||||||
| 3 | rowguid | uniqueidentifier | Default: newid() | Production.Illustration | 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. Default: newid() References: Production.Illustration |
||||||||
| 4 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| Production.ProductDescription | Production.Illustration | Production.ProductDescription.rowguid = Production.Illustration.IllustrationID | fk_Illustration_ProductDescription | |
|
Production.ProductDescription.rowguid = Production.Illustration.IllustrationID Name: fk_Illustration_ProductDescription |
||||
| Production.ProductModelProductDescriptionCulture | Production.ProductDescription | Production.ProductModelProductDescriptionCulture.ProductDescriptionID = Production.ProductDescription.ProductDescriptionID | FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Foreign key constraint referencing ProductDescription.ProductDescriptionID. |
|
|
Production.ProductModelProductDescriptionCulture.ProductDescriptionID = Production.ProductDescription.ProductDescriptionID Name: FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionIDForeign key constraint referencing ProductDescription.ProductDescriptionID. |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_ProductDescription_ProductDescriptionID | ProductDescriptionID | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
| AK_ProductDescription_rowguid | rowguid | Unique nonclustered index. Used to support replication samples. | |
| Unique nonclustered index. Used to support replication samples. | |||
Uses
| Name |
|---|
|
Production.ProductDescription
|
Used by
| Name |
|---|
|
Production.ProductDescription
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56