Warehouse.VehicleTemperatures - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Warehouse
Name	VehicleTemperatures
Module	Warehouse

Regularly recorded temperatures of vehicle chillers.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		VehicleTemperatureID	bigint		Identity		Instantaneous temperature readings for vehicle freezers and chillers
Instantaneous temperature readings for vehicle freezers and chillers Identity
	2		VehicleRegistration	nvarchar(20)				Vehicle registration number
Vehicle registration number
	3		ChillerSensorNumber	int				Cold room sensor number
Cold room sensor number
	4		RecordedWhen	datetime2(7)				Time when this temperature recording was taken
Time when this temperature recording was taken
	5		Temperature	decimal(10, 2)				Temperature at the time of recording
Temperature at the time of recording
	6		FullSensorData	nvarchar(1000)				Full JSON data received from sensor
Full JSON data received from sensor
	7		IsCompressed	bit				Is the sensor data compressed for archival storage?
Is the sensor data compressed for archival storage?
	8		CompressedSensorData	varbinary(MAX)				Compressed JSON data for archival purpose
Compressed JSON data for archival purpose

Unique keys

	Key name	Columns	Description
	PK_Warehouse_VehicleTemperatures	VehicleTemperatureID	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51