Databases > WideWorldImporters > Tables > Warehouse.ColdRoomTemperatures

WideWorldImporters

Warehouse.ColdRoomTemperatures

SYSTEM VERSIONED

Created: Modified:

Columns

  • ColdRoomTemperatureID
    [bigint] IDENTITY (1,1) NOT NULL
  • ColdRoomSensorNumber
    [int] NOT NULL
  • RecordedWhen
    [datetime2](8) NOT NULL
  • Temperature
    [decimal](10, 2) NOT NULL
  • ValidFrom
    [datetime2](8) NOT NULL
  • ValidTo
    [datetime2](8) NOT NULL

Indexes

  • PK_Warehouse_ColdRoomTemperatures
    UNIQUE NONCLUSTERED
    ColdRoomTemperatureID
  • IX_Warehouse_ColdRoomTemperatures_ColdRoomSensorNumber
    NONCLUSTERED
    ColdRoomSensorNumber

Sample Data

ColdRoomTemperatureID
ColdRoomSensorNumber
RecordedWhen
Temperature
ValidFrom
ValidTo
3654737
1
3.72
3654738
2
4.7
3654739
3
3
3654740
4
3.58