AdventureWorks

Basic Index   Expanded Index

Table Name:Production.Culture
Description:Lookup table containing the languages in which some AdventureWorks data is stored.
Primary Keys:CultureID
FieldTypeDefaultsNulls?Comments
CultureIDnchar (6)NoneNoPrimary key for Culture records.
Namenvarchar (50)NoneNoCulture description.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Culture_CultureIDYesYesCultureID
AK_Culture_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ProductModelProductDescriptionCulture_Culture_CultureIDProduction.ProductModelProductDescriptionCultureCultureID

No triggers