Application.Cities - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Application
Name	Cities
Module	Application

Cities that are part of any address (including geographic location)

There are many addresses stored in the system, for people, customer organization delivery addresses, pickup addresses at suppliers, etc. Whenever an address is stored, there is a reference to a city in this table. There is also a spatial location for each city.

Columns

		Name	Data type	Attributes	References	Description
	1	CityID	int	Default: NEXT VALUE FOR [Sequences].[CityID]		Numeric ID used for reference to a city within the database
Numeric ID used for reference to a city within the database Default: NEXT VALUE FOR [Sequences].[CityID]
	2	CityName	nvarchar(50)			Formal name of the city
Formal name of the city
	3	StateProvinceID	int		Application.StateProvinces	State or province for this city
State or province for this city References: Application.StateProvinces
	4	Location	geography			Geographic location of the city
Geographic location of the city
	5	LatestRecordedPopulation	bigint			Latest available population for the City
Latest available population for the City
	6	LastEditedBy	int		Application.People
References: Application.People
	7	ValidFrom	datetime2(7)			Valid from this date and time
Valid from this date and time
	8	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.Cities	Application.People	Application.Cities.LastEditedBy = Application.People.PersonID	FK_Application_Cities_Application_People Foreign key constraint referencing People.PersonID
Application.Cities.LastEditedBy = Application.People.PersonID Name: FK_Application_Cities_Application_People Foreign key constraint referencing People.PersonID
Application.Cities	Application.StateProvinces	Application.Cities.StateProvinceID = Application.StateProvinces.StateProvinceID	FK_Application_Cities_StateProvinceID_Application_StateProvinces Foreign key constraint referencing StateProvinces.StateProvinceID
Application.Cities.StateProvinceID = Application.StateProvinces.StateProvinceID Name: FK_Application_Cities_StateProvinceID_Application_StateProvinces Foreign key constraint referencing StateProvinces.StateProvinceID
Sales.Customers	Application.Cities	Sales.Customers.DeliveryCityID = Application.Cities.CityID	FK_Sales_Customers_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Sales.Customers.DeliveryCityID = Application.Cities.CityID Name: FK_Sales_Customers_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Sales.Customers	Application.Cities	Sales.Customers.PostalCityID = Application.Cities.CityID	FK_Sales_Customers_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Sales.Customers.PostalCityID = Application.Cities.CityID Name: FK_Sales_Customers_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers	Application.Cities	Purchasing.Suppliers.DeliveryCityID = Application.Cities.CityID	FK_Purchasing_Suppliers_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers.DeliveryCityID = Application.Cities.CityID Name: FK_Purchasing_Suppliers_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers	Application.Cities	Purchasing.Suppliers.PostalCityID = Application.Cities.CityID	FK_Purchasing_Suppliers_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers.PostalCityID = Application.Cities.CityID Name: FK_Purchasing_Suppliers_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters	Application.Cities	Application.SystemParameters.DeliveryCityID = Application.Cities.CityID	FK_Application_SystemParameters_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters.DeliveryCityID = Application.Cities.CityID Name: FK_Application_SystemParameters_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters	Application.Cities	Application.SystemParameters.PostalCityID = Application.Cities.CityID	FK_Application_SystemParameters_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters.PostalCityID = Application.Cities.CityID Name: FK_Application_SystemParameters_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID

Unique keys

	Key name	Columns	Description
	PK_Application_Cities	CityID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Application.Cities
Application.People
Application.StateProvinces

Used by

Name
Application.Cities
Application.SystemParameters
Application.SystemParameters
Purchasing.Suppliers
Purchasing.Suppliers
Sales.Customers
Sales.Customers

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