Warehouse.ColdRoomTemperatures
| Documentation | WideWorldImporters |
| Schema | Warehouse |
| Name | ColdRoomTemperatures |
| Module | Warehouse |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ColdRoomTemperatureID | bigint | Identity | Instantaneous temperature readings for cold rooms (chillers) | ||||
| Instantaneous temperature readings for cold rooms (chillers) Identity |
||||||||
| 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 |
||||||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_Warehouse_ColdRoomTemperatures | ColdRoomTemperatureID | Primary key (nonclustered) constraint. | |
| Primary key (nonclustered) constraint. | |||
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51