Application.Cities_Archive
Documentation | WideWorldImporters |
Schema | Application |
Name | Cities_Archive |
Modules | Application, History tables |
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
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | CityID | int | Numeric ID used for reference to a city within the database | |||||
Numeric ID used for reference to a city within the database |
||||||||
2 | CityName | nvarchar(50) | Formal name of the city | |||||
Formal name of the city |
||||||||
3 | StateProvinceID | int | State or province for this city | |||||
State or province for this city |
||||||||
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 | ||||||
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 |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51