Difference between revisions of "Person.CountryRegion (table)"
| Line 787: | Line 787: | ||
| Zimbabwe | | Zimbabwe | ||
|} | |} | ||
| − | |||
== automatically generated == | == automatically generated == | ||
| Line 809: | Line 808: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
| − | | '''Description | + | | '''Description / PK / Index |
| − | |||
|- | |- | ||
| Line 817: | Line 815: | ||
| not null | | not null | ||
| | | | ||
| − | | ISO standard code for countries and regions. | + | | ISO standard code for countries and regions.PK_CountryRegion_CountryRegionCode |
| − | |||
|- | |- | ||
| Name | | Name | ||
| Line 824: | Line 821: | ||
| not null | | not null | ||
| | | | ||
| − | | Country or region name. | + | | Country or region name.AK_CountryRegion_Name |
| − | |||
|- | |- | ||
| ModifiedDate | | ModifiedDate | ||
| Line 832: | Line 828: | ||
| (GETDATE()) | | (GETDATE()) | ||
| Date and time the record was last updated. | | Date and time the record was last updated. | ||
| − | |||
|} | |} | ||
| Line 851: | Line 846: | ||
| CountryRegionCode | | CountryRegionCode | ||
| CountryRegionCode | | CountryRegionCode | ||
| + | |} | ||
| + | |||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Referenced Object | ||
| + | | '''Object Type | ||
| + | | '''Dependency Type | ||
| + | |||
| + | |- | ||
| + | | [[dbo.Name_(type)|dbo.Name]] | ||
| + | | Type | ||
| + | | Data Type | ||
| + | |} | ||
| + | |||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Referencing Object | ||
| + | | '''Object Type | ||
| + | | '''Reference Type | ||
| + | |||
| + | |- | ||
| + | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] | ||
| + | | View | ||
| + | | Select | ||
| + | |- | ||
| + | | [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]] | ||
| + | | View | ||
| + | | Select | ||
| + | |- | ||
| + | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] | ||
| + | | View | ||
| + | | Select | ||
| + | |- | ||
| + | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] | ||
| + | | View | ||
| + | | Select | ||
| + | |- | ||
| + | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] | ||
| + | | View | ||
| + | | Select | ||
| + | |- | ||
| + | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] | ||
| + | | View | ||
| + | | Select | ||
|} | |} | ||
Revision as of 23:52, 26 November 2009
wikibot
| Table | Person.CountryRegion |
| Column | Data Type | Nullable | Default | PK | Index |
| CountryRegionCode | nvarchar(3) | not null | PK_CountryRegion_CountryRegionCode | ||
| Name | dbo.Name | not null | AK_CountryRegion_Name | ||
| ModifiedDate | datetime | not null | (getdate()) |
| Detail Table | Column | Referencing Column |
| Sales.CountryRegionCurrency | CountryRegionCode | CountryRegionCode |
| Person.StateProvince | CountryRegionCode | CountryRegionCode |
wikivalues
| Table Values | Person.CountryRegion |
| CountryRegionCode | Name |
| AF | Afghanistan |
| AL | Albania |
| DZ | Algeria |
| AS | American Samoa |
| AD | Andorra |
| AO | Angola |
| AI | Anguilla |
| AQ | Antarctica |
| AG | Antigua and Barbuda |
| AR | Argentina |
| AM | Armenia |
| AW | Aruba |
| AU | Australia |
| AT | Austria |
| AZ | Azerbaijan |
| BS | Bahamas, The |
| BH | Bahrain |
| BD | Bangladesh |
| BB | Barbados |
| BY | Belarus |
| BE | Belgium |
| BZ | Belize |
| BJ | Benin |
| BM | Bermuda |
| BT | Bhutan |
| BO | Bolivia |
| BA | Bosnia and Herzegovina |
| BW | Botswana |
| BV | Bouvet Island |
| BR | Brazil |
| IO | British Indian Ocean Territory |
| BN | Brunei |
| BG | Bulgaria |
| BF | Burkina Faso |
| BI | Burundi |
| KH | Cambodia |
| CM | Cameroon |
| CA | Canada |
| CV | Cape Verde |
| KY | Cayman Islands |
| CF | Central African Republic |
| TD | Chad |
| CL | Chile |
| CN | China |
| CX | Christmas Island |
| CC | Cocos (Keeling) Islands |
| CO | Colombia |
| KM | Comoros |
| CG | Congo |
| CD | Congo (DRC) |
| CK | Cook Islands |
| CR | Costa Rica |
| CI | Côte dIvoire |
| HR | Croatia |
| CU | Cuba |
| CY | Cyprus |
| CZ | Czech Republic |
| DK | Denmark |
| DJ | Djibouti |
| DM | Dominica |
| DO | Dominican Republic |
| EC | Ecuador |
| EG | Egypt |
| SV | El Salvador |
| GQ | Equatorial Guinea |
| ER | Eritrea |
| EE | Estonia |
| ET | Ethiopia |
| FK | Falkland Islands (Islas Malvinas) |
| FO | Faroe Islands |
| FJ | Fiji Islands |
| FI | Finland |
| FR | France |
| GF | French Guiana |
| PF | French Polynesia |
| TF | French Southern and Antarctic Lands |
| GA | Gabon |
| GM | Gambia, The |
| GE | Georgia |
| DE | Germany |
| GH | Ghana |
| GI | Gibraltar |
| GR | Greece |
| GL | Greenland |
| GD | Grenada |
| GP | Guadeloupe |
| GU | Guam |
| GT | Guatemala |
| GN | Guinea |
| GW | Guinea-Bissau |
| GY | Guyana |
| HT | Haiti |
| HM | Heard Island and McDonald Islands |
| HN | Honduras |
| HK | Hong Kong SAR |
| HU | Hungary |
| IS | Iceland |
| IN | India |
| ID | Indonesia |
| IR | Iran |
| IQ | Iraq |
| IE | Ireland |
| IL | Israel |
| IT | Italy |
| JM | Jamaica |
| JP | Japan |
| JO | Jordan |
| KZ | Kazakhstan |
| KE | Kenya |
| KI | Kiribati |
| KR | Korea |
| KW | Kuwait |
| KG | Kyrgyzstan |
| LA | Laos |
| LV | Latvia |
| LB | Lebanon |
| LS | Lesotho |
| LR | Liberia |
| LY | Libya |
| LI | Liechtenstein |
| LT | Lithuania |
| LU | Luxembourg |
| MO | Macao SAR |
| MK | Macedonia, Former Yugoslav Republic of |
| MG | Madagascar |
| MW | Malawi |
| MY | Malaysia |
| MV | Maldives |
| ML | Mali |
| MT | Malta |
| MH | Marshall Islands |
| MQ | Martinique |
| MR | Mauritania |
| MU | Mauritius |
| YT | Mayotte |
| MX | Mexico |
| FM | Micronesia |
| MD | Moldova |
| MC | Monaco |
| MN | Mongolia |
| MS | Montserrat |
| MA | Morocco |
| MZ | Mozambique |
| MM | Myanmar |
| NA | Namibia |
| NR | Nauru |
| NP | Nepal |
| NL | Netherlands |
| AN | Netherlands Antilles |
| NC | New Caledonia |
| NZ | New Zealand |
| NI | Nicaragua |
| NE | Niger |
| NG | Nigeria |
| NU | Niue |
| NF | Norfolk Island |
| KP | North Korea |
| MP | Northern Mariana Islands |
| NO | Norway |
| OM | Oman |
| PK | Pakistan |
| PW | Palau |
| PS | Palestinian Authority |
| PA | Panama |
| PG | Papua New Guinea |
| PY | Paraguay |
| PE | Peru |
| PH | Philippines |
| PN | Pitcairn Islands |
| PL | Poland |
| PT | Portugal |
| PR | Puerto Rico |
| QA | Qatar |
| RE | Réunion |
| RO | Romania |
| RU | Russia |
| RW | Rwanda |
| SH | Saint Helena |
| KN | Saint Kitts and Nevis |
| LC | Saint Lucia |
| PM | Saint Pierre and Miquelon |
| VC | Saint Vincent and the Grenadine |
| WS | Samoa |
| SM | San Marino |
| ST | São Tomé and Príncipe |
| SA | Saudi Arabia |
| SN | Senegal |
| CS | Serbia and Montenegro |
| SC | Seychelles |
| SL | Sierra Leone |
| SG | Singapore |
| SK | Slovakia |
| SI | Slovenia |
| SB | Solomon Islands |
| SO | Somalia |
| ZA | South Africa |
| GS | South Georgia and the South Sandwich Islands |
| ES | Spain |
| LK | Sri Lanka |
| SD | Sudan |
| SR | Suriname |
| SJ | Svalbard and Jan Mayen |
| SZ | Swaziland |
| SE | Sweden |
| CH | Switzerland |
| SY | Syria |
| TW | Taiwan |
| TJ | Tajikistan |
| TZ | Tanzania |
| TH | Thailand |
| TL | Timor-Leste |
| TG | Togo |
| TK | Tokelau |
| TO | Tonga |
| TT | Trinidad and Tobago |
| TN | Tunisia |
| TR | Turkey |
| TM | Turkmenistan |
| TC | Turks and Caicos Islands |
| TV | Tuvalu |
| UM | U.S. Minor Outlying Islands |
| UG | Uganda |
| UA | Ukraine |
| AE | United Arab Emirates |
| GB | United Kingdom |
| US | United States |
| UY | Uruguay |
| UZ | Uzbekistan |
| VU | Vanuatu |
| VA | Vatican City |
| VE | Venezuela |
| VN | Vietnam |
| VG | Virgin Islands, British |
| VI | Virgin Islands, U.S. |
| WF | Wallis and Futuna |
| YE | Yemen |
| ZM | Zambia |
| ZW | Zimbabwe |
automatically generated
| Table | Person.CountryRegion |
| Description | Lookup table containing the ISO standard codes for countries and regions. |
| Column | Data Type | Nullable | Default | Description / PK / Index |
| CountryRegionCode | nvarchar(3) | not null | ISO standard code for countries and regions.PK_CountryRegion_CountryRegionCode | |
| Name | Name | not null | Country or region name.AK_CountryRegion_Name | |
| ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
| Detail Table | Column | Referencing Column |
| Sales.CountryRegionCurrency | CountryRegionCode | CountryRegionCode |
| Person.StateProvince | CountryRegionCode | CountryRegionCode |
| Referenced Object | Object Type | Dependency Type |
| dbo.Name | Type | Data Type |
| Referencing Object | Object Type | Reference Type |
| HumanResources.vEmployee | View | Select |
| Person.vStateProvinceCountryRegion | View | Select |
| Purchasing.vVendor | View | Select |
| Sales.vIndividualCustomer | View | Select |
| Sales.vSalesPerson | View | Select |
| Sales.vStoreWithDemographics | View | Select |
