Generated using SQL Data Dictionary demo version.
Countries that contain the states or provinces (including geographic boundaries)
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
PK | CountryID | int | NEXT VALUE FOR [Sequences].[CountryID] | ||
Numeric ID used for reference to a country within the database | |||||
UK | CountryName | nvarchar(60) | |||
Name of the country | |||||
UK | FormalName | nvarchar(60) | |||
Full formal name of the country as agreed by United Nations | |||||
IsoAlpha3Code | nvarchar(3) | X | |||
3 letter alphabetic code assigned to the country by ISO | |||||
IsoNumericCode | int | X | |||
Numeric code assigned to the country by ISO | |||||
CountryType | nvarchar(20) | X | |||
Type of country or administrative region | |||||
LatestRecordedPopulation | bigint | X | |||
Latest available population for the country | |||||
Continent | nvarchar(30) | ||||
Name of the continent | |||||
Region | nvarchar(30) | ||||
Name of the region | |||||
Subregion | nvarchar(30) | ||||
Name of the subregion | |||||
Border | geography | X | |||
Geographic border of the country as described by the United Nations | |||||
FK | LastEditedBy | int | |||
ValidFrom | datetime2 | ||||
ValidTo | datetime2 |