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

From dbscript Online Help
Jump to: navigation, search
 
(16 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.Culture
 
| Production.Culture
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Lookup table containing the languages in which some AdventureWorks data is stored.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| CultureID
 
| CultureID
 
| nchar(6)
 
| nchar(6)
 
| not null
 
| not null
 
|  
 
|  
−
| PK_Culture_CultureID
+
| Primary key for Culture records.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Culture description.
−
| AK_Culture_Name
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_Culture_CultureID
 +
| CultureID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_Culture_Name
 +
| Unique
 +
| Name
 +
|}
  
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 48: Line 68:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 
| [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 
| CultureID
 
| CultureID
 
| CultureID
 
| CultureID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
 
== wikivalues ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| Production.Culture
 
| Production.Culture
−
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
−
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
−
|- style="background:silver"
 
 
| '''CultureID
 
| '''CultureID
 
| '''Name
 
| '''Name
−
|-  
+
|- valign="top"
−
| ar     
+
 
−
| Arabic
+
| ar     
−
|-  
+
| Arabic
−
| zh-cht
+
|- valign="top"
−
| Chinese
+
 
−
|-  
+
| zh-cht
−
| en     
+
| Chinese
−
| English
+
|- valign="top"
−
|-  
+
 
−
| fr     
+
| en     
−
| French
+
| English
−
|-  
+
|- valign="top"
−
| he     
+
 
−
| Hebrew
+
| fr     
−
|-  
+
| French
−
|
+
|- valign="top"
−
| Invariant Language (Invariant Country)
+
 
−
|-  
+
| he     
−
| es     
+
| Hebrew
−
| Spanish
+
|- valign="top"
−
|-  
+
 
−
| th     
+
|  
−
| Thai
+
| Invariant Language (Invariant Country)
 +
|- valign="top"
 +
 
 +
| es     
 +
| Spanish
 +
|- valign="top"
 +
 
 +
| th     
 +
| Thai
 
|}
 
|}
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 99: Line 148:
 
| '''Table
 
| '''Table
 
| Production.Culture
 
| Production.Culture
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Lookup table containing the languages in which some AdventureWorks data is stored.
 
| Lookup table containing the languages in which some AdventureWorks data is stored.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 116: Line 163:
 
| '''Description / PK / Index
 
| '''Description / PK / Index
 
 
−
|-
+
|- valign="top"
 
| CultureID
 
| CultureID
 
| nchar(6)
 
| nchar(6)
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Culture records.PK_Culture_CultureID
+
| Primary key for Culture records.<br />PK_Culture_CultureID
−
|-
+
|- valign="top"
 
| Name
 
| Name
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Culture description.AK_Culture_Name
+
| Culture description.<br />AK_Culture_Name
−
|-
+
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 153: Line 200:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
+
 
−
| '''Dependency Type
 
−
 
 
|-
 
|-
 +
| Data Type
 +
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
−
| Type
+
 
−
| Data Type
+
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 
 
|}
 
|}

Latest revision as of 09:55, 27 August 2011

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
PK_Culture_CultureID CultureID

Indexes[edit]

Index Type Columns
AK_Culture_Name Unique Name

Detail Tables[edit]

Detail Table Column Referencing Column
Production.ProductModelProductDescriptionCulture CultureID CultureID

References[edit]

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


wikivalues[edit]

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[edit]

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.Culture_(table)&oldid=2932"