Column

Primary Key

Datatype

Length

Notes

MachineIDM

Part-key identifying the machine to which the diagnostic belongs.

Yes

INTEGER

4

FK -> WgnMachine

MachineID

Part-key identifying the machine to which the diagnostic belongs.

Yes

INTEGER

4

FK -> WgnMachine

DiagID

Identifies the type of diagnostic stored by this row.

Yes

INTEGER

4

Follow the hyperlink for details.

DiagValueType

Identifies the type of data that has been stored.

INTEGER

4

Follow the hyperlink for details.

DiagValueStr

For string type diagnostics, this column holds the string value.

VARCHAR

255

DiagValueLong

For numeric type diagnostics, this column holds the numeric value.

DECIMAL(28,0)

16

DiagValueTimestamp

For timestamp type diagnostics, this column holds the timestamp value.

TIMESTAMP

8

DiagTimestamp

This column stores the time that the diagnostic value was last updated.

TIMESTAMP

8