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