Application.Countries - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Application
Name	Countries
Module	Application

Countries that contain the states or provinces (including geographic boundaries)

States or Provinces are part of countries. This table has details of those, including spatial data describing the boundaries of each country.

Columns

		Name	Data type	Attributes	References	Description
	1	CountryID	int	Default: NEXT VALUE FOR [Sequences].[CountryID]		Numeric ID used for reference to a country within the database
Numeric ID used for reference to a country within the database Default: NEXT VALUE FOR [Sequences].[CountryID]
	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		Application.People
References: Application.People
	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

Relations

Foreign table	Primary table	Join	Title / Name / Description
Application.Countries	Application.People	Application.Countries.LastEditedBy = Application.People.PersonID	FK_Application_Countries_Application_People Foreign key constraint referencing People.PersonID
Application.Countries.LastEditedBy = Application.People.PersonID Name: FK_Application_Countries_Application_People Foreign key constraint referencing People.PersonID
Application.StateProvinces	Application.Countries	Application.StateProvinces.CountryID = Application.Countries.CountryID	FK_Application_StateProvinces_CountryID_Application_Countries Foreign key constraint referencing Countries.CountryID
Application.StateProvinces.CountryID = Application.Countries.CountryID Name: FK_Application_StateProvinces_CountryID_Application_Countries Foreign key constraint referencing Countries.CountryID

Unique keys

	Key name	Columns	Description
	PK_Application_Countries	CountryID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Application_Countries_CountryName	CountryName	Unique nonclustered index.
Unique nonclustered index.
	UQ_Application_Countries_FormalName	FormalName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Application.Countries
Application.People

Used by

Name
Application.Countries
Application.StateProvinces

Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51