Scout Database Model (CR)

Table: UpdateDevice

March 25, 2025

Contributed by:

Each entry holds the data of a single device which is (or was) part of an update job. Entries may only be removed if the corresponding update job is not running.

ColumnName	Data Type	Key	Not Null	Default Value	Comment
UpdateDeviceID	INTEGER	PK	NN		Unique ID of update device
UpdateJobID	INTEGER	FK			The Id of update job this client is part of Foreign key refers to UpdateJob table
Id	INTEGER	(FK)	NN		Client IDRefers to DeviceID of Device table
Mac	NVARCHAR(255)		NN		Client MAC address
ClientIdentifier	UNIQUEIDENTIFIER		NN		Unique identifier for client devices and eLux portable sticks
Ip	NVARCHAR(255)		NN		Client IP address
TimeCreated	INTEGER		NN		Creation time (Unix time)
TimeModified	INTEGER		NN		Last modification time (Unix time)
SetupID	INTEGER		NN		Device configuration where the firmware parameters come from (refers to table Setup)
UpdOption	INTEGER			0	Update option
					1 - UPD_DEVOPTION_V2
					2 - UPD_DEVOPTION_V6
					4 - UPD_DEVOPTION_CANFORMAT
					7 - Combination of the flags above
StartStatus	INTEGER				State of device at beginning of update job
					1 - UPD_DEVSTATUS_OFF, Client was switched off
					3 - UPD_DEVSTATUS_ON, Client was up and running
Status	INTEGER				Current state of device
					1 - UPD_DEVSTATUS_OFF, Client is switched off
					2 - UPD_DEVSTATUS_STARTING, Client is starting
					3 - UPD_DEVSTATUS_ON, Client is up and running
					4 - UPD_DEVSTATUS_UPDATING, Client is updating
					5 - UPD_DEVSTATUS_DONE, Client has been updated
					6 - UPD_DEVSTATUS_WAITHALT, Client is shutting down
Result	INTEGER				Update result
					0 - UPD_JOBRESULT_OK, Update successful
					1 - UPD_JOBRESULT_ERROR, Update failed
GroupID	INTEGER				Group which owns the device specific update parameters (foreign key refers to table Groups
Version	NVARCHAR(255)				Version of client
ProgressStatus	INTEGER				Status of update process:Start transfer, End transfer, Deferred, Start installation, End installation
ClientFeatures	INTEGER				Features the client is capable of (can be a bit combination of values) For the values, see the Device table.
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	UpdateDeviceID

How to create

    CREATE TABLE UpdateDevice(
    UpdateDeviceID INTEGER NOT NULL,
    UpdateJobID INTEGER,
    Id INTEGER NOT NULL,
    Mac NVARCHAR(255) NOT NULL,
    ClientIdentifier UNIQUEIDENTIFIER NOT NULL,
    Ip NVARCHAR(255) NOT NULL,
    TimeCreated INTEGER NOT NULL,
    TimeModified INTEGER NOT NULL,
    SetupID INTEGER,
    UpdOption INTEGER,
    StartStatus INTEGER,
    Status INTEGER,
    Result INTEGER,
    GroupID INTEGER,
    Version NVARCHAR(255),
    ProgressStatus INTEGER,
    ClientFeatures INTEGER;
    ReservedString1 NVARCHAR(255),
    ReservedString2 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    CONSTRAINT FK_UpdateDevice_UpdateJobID_UpdateJob_UpdateJobID FOREIGN KEY (UpdateJobID) REFERENCES UpdateJob (UpdateJobID),
    CONSTRAINT PK_UpdateDevice
    PRIMARY KEY (UpdateDeviceID));
 

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: UpdateDevice

March 25, 2025

Contributed by:

Table: UpdateDevice

How to create

In this article