Application.StateProvinces

Columns

• //

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

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

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

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

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

  ${escapify(column.description)}
  Border
  [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_StateProvinces
  UNIQUE CLUSTERED
  StateProvinceID
• UQ_Application_StateProvinces_StateProvinceName
  UNIQUE NONCLUSTERED
  StateProvinceName
• //

  Auto-created to support a foreign key
  FK_Application_StateProvinces_CountryID
  NONCLUSTERED
  CountryID
• //

  Index used to quickly locate sales territories
  IX_Application_StateProvinces_SalesTerritory
  NONCLUSTERED
  SalesTerritory

Foreign Keys

• FK_Application_StateProvinces_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Application_StateProvinces_CountryID_Application_Countries
  Application.Countries
  CountryID ⥱ CountryID

Sample Data