ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

Production.Culture_(table)

Modified: 2011/08/27 10:14 by wikibot - Uncategorized

» Production.Culture_(table)

wikibot

Table	Production.Culture
Description	Lookup table containing the languages in which some AdventureWorks data is stored.

Columns

Column	Data Type	Nullable	Default	Description
CultureID	nchar(6)	not null		Primary key for Culture records.
Name	dbo.Name	not null		Culture description.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_Culture_CultureID	CultureID

Indexes

Index	Type	Columns
AK_Culture_Name	Unique	Name

Detail Tables

Detail Table	Column	Referencing Column
Production.ProductModelProductDescriptionCulture	CultureID	CultureID

References

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

wikivalues

Table Values

Production.Culture

CultureID	Name
ar	Arabic
zh-cht	Chinese
en	English
fr	French
he	Hebrew
	Invariant Language (Invariant Country)
es	Spanish
th	Thai

automatically generated

Table	Production.Culture
Description	Lookup table containing the languages in which some AdventureWorks data is stored.

Column	Data Type	Nullable	Default	Description / PK / Index
CultureID	nchar(6)	not null		Primary key for Culture records. PK_Culture_CultureID
Name	Name	not null		Culture description. AK_Culture_Name
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Production.ProductModelProductDescriptionCulture	CultureID	CultureID

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

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.