Difference between revisions of "Production.Culture (table)"

From dbscript Online Help
Jump to: navigation, search
Line 160: Line 160:
 
| Data Type
 
| Data Type
 
| Type
 
| Type
| [[dbo.Name_(type)|dbo.Name]]
+
| [[dbo.Name_(type)|true.Name]]
  
 
|-
 
|-
 
| Schema
 
| Schema
 
| Schema
 
| Schema
| [[Production_(schema)|.Production]]
+
| [[Production_(schema)|false.Production]]
  
 
|}
 
|}

Revision as of 07:33, 30 November 2009

wikibot

Table Production.Culture


Column Data Type Nullable Default PK Index
CultureID nchar(6) not null PK_Culture_CultureID
Name dbo.Name not null AK_Culture_Name
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
Production.ProductModelProductDescriptionCulture CultureID CultureID

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 true.Name
Schema Schema false.Production