dbo.MSSQL_TemporalHistoryFor_731865674

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.MSSQL_TemporalHistoryFor_731865674.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no		System-versioned temporal history table for dbo.endataLocations; ID is the primary key of the shadowed row.
2	LocationName	varchar(500)	no		Historical value of LocationName from dbo.endataLocations at this point in time.
3	IsStale	bit	no		Historical value of IsStale from dbo.endataLocations at this point in time.
4	LocationHash	varbinary(32)	no		Historical value of LocationHash from dbo.endataLocations at this point in time.
5	CreatedAt	datetime2(7)	yes		Historical value of CreatedAt from dbo.endataLocations at this point in time.
6	UpdatedAt	datetime2(7)	yes		Historical value of UpdatedAt from dbo.endataLocations at this point in time.
7	ValidFrom	datetime2(7)	no		Start of the period during which this historical row version was current.
8	ValidTo	datetime2(7)	no		End of the period during which this historical row version was current.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
ix_MSSQL_TemporalHistoryFor_731865674	CLUSTERED			ValidTo, ValidFrom