Generated using SQL Data Dictionary demo version.
Cities that are part of any address (including geographic location)
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
PK | CityID | int | NEXT VALUE FOR [Sequences].[CityID] | ||
Numeric ID used for reference to a city within the database | |||||
CityName | nvarchar(50) | ||||
Formal name of the city | |||||
FK | StateProvinceID | int | |||
State or province for this city | |||||
Location | geography | X | |||
Geographic location of the city | |||||
LatestRecordedPopulation | bigint | X | |||
Latest available population for the City | |||||
FK | LastEditedBy | int | |||
ValidFrom | datetime2 | ||||
ValidTo | datetime2 |
Auto-created to support a foreign key