Database entries
The database consists of different tables, which connect with one to many relations. The relations are specified using a "parent id" on the children elements.
UID
UID is a structure storing instrument serial number and a timestamp, thus providing a unique identifier
| Field | Type |
|---|---|
| instrument_serial | int32 |
| timestamp | int32 |
The instrument_serial field doesn't use first 5 bits, so we use them as a counter.
The counter helps us when data is saved multiple times in a single second.
The timestamp field is in seconds since EPOCH (01-01-1970).
Project
Project is a top-level structure, which stores a name and code.
| Field | Type |
|---|---|
| Project ID | UID |
| Project code | string |
| Client code | string |
| Site code | string |
| Time of last update | int32? |
Test Plan
Test plan is a top-level structure, which defines a testing procedure.
| Field | Type |
|---|---|
| TestPlan ID | UID |
| TestPlan code | string |
| TestPlan name | string |
| Settings | [ResultSetting] |
| Description | string? |
Step
Step is a structure that holds results, measurements, settings, instructions and sequence number. It can be found in both Test Plans and Workspaces.
| Field | Type |
|---|---|
| Step ID | UID |
| Parent ID | UID |
| Sequence number | int32 |
| Results | [ResultSetting] |
| Measurements | [Measurement] |
| Settings | [ResultSetting] |
| Instruction | string? |
Measurement
Measurement holds a measurement number, results and settings.
| Field | Type |
|---|---|
| Measurement number | int32 |
| Results | [ResultSetting] |
| Settings | [ResultSetting] |
DUT
Dut structure represents the device under test.
| Field | Type |
|---|---|
| DUT ID | UID |
| DUT Code | string |
| Project ID | UID |
| Testplan ID | UID? |
| Results | [ResultSetting] |
| Last update | int32? |
ResultSetting
ResultSetting is a structure that holds values common to both Result and Setting.
| Field | Type |
|---|---|
| Name enum | int32 |
| Value | ResultSettingValue? |
| Limit | LimitValue? |
ResultSettingValue
ResultSettingValue stores either Numeric or Descriptive values.
| Field | Type |
|---|---|
| Numeric value | float? |
| Descriptive value | int32? |
LimitValue
LimitValue stores the low and high values of the limit.
| Field | Type |
|---|---|
| Limit low | float? |
| Limit high | float? |