Difference between revisions of "Sales.CountryRegionCurrency (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.CountryRegionCurrency |- |} {| border="1" cellpadding="5" cellspacing=...)
 
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Table
 +
| Sales.CountryRegionCurrency
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping ISO currency codes to a country or region.
 +
|}
 +
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| CountryRegionCode
 +
| nvarchar(3)
 +
| not null
 +
|
 +
| ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
 +
|- valign="top"
 +
| CurrencyCode
 +
| nchar(3)
 +
| not null
 +
|
 +
| ISO standard currency code. Foreign key to Currency.CurrencyCode.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (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_CountryRegionCurrency_CountryRegionCode_CurrencyCode
 +
| CountryRegionCode, CurrencyCode
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| IX_CountryRegionCurrency_CurrencyCode
 +
|
 +
| CurrencyCode
 +
|}
 +
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 +
| CountryRegionCode
 +
| CountryRegionCode
 +
|- valign="top"
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
| CurrencyCode
 +
| CurrencyCode
 +
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 100:
 
| '''Table
 
| '''Table
 
| Sales.CountryRegionCurrency
 
| Sales.CountryRegionCurrency
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping ISO currency codes to a country or region.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 113:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| CountryRegionCode
 
| CountryRegionCode
 
| nvarchar(3)
 
| nvarchar(3)
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
+
| ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
−
|
+
|- valign="top"
−
|-
 
 
| CurrencyCode
 
| CurrencyCode
−
| nchar(0)
+
| nchar(3)
 
| not null
 
| not null
 
|  
 
|  
−
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
+
| ISO standard currency code. Foreign key to Currency.CurrencyCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
−
| IX_CountryRegionCurrency_CurrencyCode
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 57: Line 151:
 
| CurrencyCode
 
| CurrencyCode
 
| CurrencyCode
 
| CurrencyCode
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 
|}
 
|}

Latest revision as of 00:17, 24 June 2010

wikibot[edit]

Table Sales.CountryRegionCurrency
Description Cross-reference table mapping ISO currency codes to a country or region.

Columns[edit]

Column Data Type Nullable Default Description
CountryRegionCode nvarchar(3) not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CurrencyCode nchar(3) not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode CountryRegionCode, CurrencyCode

Indexes[edit]

Index Type Columns
IX_CountryRegionCurrency_CurrencyCode CurrencyCode

Foreign Keys[edit]

Relation Column Referenced Column
Person.CountryRegion CountryRegionCode CountryRegionCode
Sales.Currency CurrencyCode CurrencyCode

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.CountryRegionCurrency
Description Cross-reference table mapping ISO currency codes to a country or region.


Column Data Type Nullable Default Description / PK / Index
CountryRegionCode nvarchar(3) not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCode nchar(3) not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.CountryRegion CountryRegionCode CountryRegionCode
Sales.Currency CurrencyCode CurrencyCode


Dependency Type Object Type Referenced Object
Schema Schema Sales
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.CountryRegionCurrency_(table)&oldid=2660"