Warehouse.ColdRoomTemperatures_Archive
Documentation | WideWorldImporters |
Schema | Warehouse |
Name | ColdRoomTemperatures_Archive |
Modules | Warehouse, History tables |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ColdRoomTemperatureID | bigint | Instantaneous temperature readings for cold rooms (chillers) | |||||
Instantaneous temperature readings for cold rooms (chillers) |
||||||||
2 | ColdRoomSensorNumber | int | Cold room sensor number | |||||
Cold room sensor number |
||||||||
3 | RecordedWhen | datetime2(7) | Time when this temperature recording was taken | |||||
Time when this temperature recording was taken |
||||||||
4 | Temperature | decimal(10, 2) | Temperature at the time of recording | |||||
Temperature at the time of recording |
||||||||
5 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
6 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51