Application.Countries_Archive
Documentation | WideWorldImporters |
Schema | Application |
Name | Countries_Archive |
Modules | Application, History tables |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | CountryID | int | Numeric ID used for reference to a country within the database | |||||
Numeric ID used for reference to a country within the database |
||||||||
2 | CountryName | nvarchar(60) | Name of the country | |||||
Name of the country |
||||||||
3 | FormalName | nvarchar(60) | Full formal name of the country as agreed by United Nations | |||||
Full formal name of the country as agreed by United Nations |
||||||||
4 | IsoAlpha3Code | nvarchar(3) | 3 letter alphabetic code assigned to the country by ISO | |||||
3 letter alphabetic code assigned to the country by ISO |
||||||||
5 | IsoNumericCode | int | Numeric code assigned to the country by ISO | |||||
Numeric code assigned to the country by ISO |
||||||||
6 | CountryType | nvarchar(20) | Type of country or administrative region | |||||
Type of country or administrative region |
||||||||
7 | LatestRecordedPopulation | bigint | Latest available population for the country | |||||
Latest available population for the country |
||||||||
8 | Continent | nvarchar(30) | Name of the continent | |||||
Name of the continent |
||||||||
9 | Region | nvarchar(30) | Name of the region | |||||
Name of the region |
||||||||
10 | Subregion | nvarchar(30) | Name of the subregion | |||||
Name of the subregion |
||||||||
11 | Border | geography | Geographic border of the country as described by the United Nations | |||||
Geographic border of the country as described by the United Nations |
||||||||
12 | LastEditedBy | int | ||||||
13 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
14 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51