| Latest revision |
Your text |
| 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 100: |
Line 5: |
| | | '''Table | | | '''Table |
| | | Sales.CountryRegionCurrency | | | Sales.CountryRegionCurrency |
| − | |- valign="top"
| |
| − | | '''Description
| |
| − | | Cross-reference table mapping ISO currency codes to a country or region.
| |
| | |- | | |- |
| | |} | | |} |
| Line 113: |
Line 15: |
| | | '''Nullable | | | '''Nullable |
| | | '''Default | | | '''Default |
| − | | '''Description / PK / Index | + | | '''PK |
| | + | | '''Index |
| | | | |
| − | |- valign="top" | + | |- |
| | | CountryRegionCode | | | CountryRegionCode |
| | | nvarchar(3) | | | nvarchar(3) |
| | | not null | | | not null |
| | | | | | |
| − | | ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | + | | PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |
| − | |- valign="top" | + | | |
| | + | |- |
| | | CurrencyCode | | | CurrencyCode |
| | | nchar(3) | | | nchar(3) |
| | | not null | | | not null |
| | | | | | |
| − | | ISO standard currency code. Foreign key to Currency.CurrencyCode.<br />PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode | + | | PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode |
| − | |- valign="top" | + | | IX_CountryRegionCurrency_CurrencyCode |
| | + | |- |
| | | ModifiedDate | | | ModifiedDate |
| | | datetime | | | datetime |
| | | not null | | | not null |
| − | | (GETDATE()) | + | | (getdate()) |
| − | | Date and time the record was last updated.<br /> | + | | |
| | + | | |
| | |} | | |} |
| | | | |
| Line 151: |
Line 57: |
| | | 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]]
| |
| − |
| |
| | |} | | |} |
