Application.Cities

Columns

• //

  ${escapify(column.description)}
  CityID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[CityID])
• //

  ${escapify(column.description)}
  CityName
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  StateProvinceID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  Location
  [geography] NULL
• //

  ${escapify(column.description)}
  LatestRecordedPopulation
  [bigint] NULL
• LastEditedBy
  [int] NOT NULL
• ValidFrom
  [datetime2](8) NOT NULL
• ValidTo
  [datetime2](8) NOT NULL

Indexes

• PK_Application_Cities
  UNIQUE CLUSTERED
  CityID
• //

  Auto-created to support a foreign key
  FK_Application_Cities_StateProvinceID
  NONCLUSTERED
  StateProvinceID

Foreign Keys

• FK_Application_Cities_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Application_Cities_StateProvinceID_Application_StateProvinces
  Application.StateProvinces
  StateProvinceID ⥱ StateProvinceID

Sample Data