Updates to Default Database Schemas

When the default database schema is updated in new versions of TestStand, the old default database schemas remain available as legacy schemas.

The following table summarizes changes to the default database schema:

Table 7. Changes to the Default Database Schema
Version Default Database Schema Changes
TestStand 2020 The data types for the following columns in the PROP_NUMERICLIMIT table were changed from Numeric to String to enable TestStand to log INF, -INF, NAN and IND values when you use them as limits of Numeric Limit Test and Multi Numeric Limit Test steps.
  • LOW_LIMIT
  • HIGH_LIMIT
  • NOMINAL_VALUE
  • LOWER_THRESHOLD
  • HIGHER_THRESHOLD
TestStand 2016 The following columns were added to the PROP_NUMERICLIMIT table to log limit values when you use the EQT comparison type in Numeric Limit Test and Multi Numeric Limit Test.
  • THRESHOLD_TYPE
  • NOMINAL_VALUE
  • LOWER_THRESHOLD
  • HIGHER_THRESHOLD
TestStand 2012 The following columns were added to the UUT_RESULT table to log the part number of the UUT and data from the TestStand Offline Results Processor.
  • PART_NUMBER
  • TSR_FILE_NAME
  • TSR_FILE_ID
  • TSR_FILE_CLOSED
TestStand 4.1 The following changes were made to support logging additional results:
  • The tables listed below are no longer included and this information is logged in the PROP_RESULT table, which includes property result information and simple intrinsic property values. The PROP_RESULT table contains a foreign key that references the STEP_RESULT table.
    • STEP_PASSFAIL
    • STEP_CALLEXE
    • STEP_MSGPOPUP
    • STEP_PROPERTYLOADER
    • STEP_STRINGVALUE
    • MEAS_IVI_SINGLEPOINT
  • The following tables were added, each of which contains a foreign key that references the PROP_RESULT table:
    • PROP_BINARY—logs binary data, such as array values.
    • PROP_ANALOGWAVEFORM—logs analog waveform data, such as the LabVIEWAnalogWaveform, NI_IviWave, and NI_IviWavePair data types. This table replaces the MEAS_IVI_WAVE and MEAS_IVI_WAVEPAIR tables in previous versions of TestStand.
    • PROP_DIGITALWAVEFORM—logs digital waveform data, such as the LabVIEWDigitalWaveform data type.
    • PROP_NUMERICLIMIT—logs numeric limit data. This table replaces the MEAS_NUMERICLIMIT table in previous versions of TestStand.
  • The following new fields were added to the STEP_RESULT table:
    • STEP_ID—specifies the unique step ID.
    • CAUSED_SEQFAIL—specifies whether a step caused a sequence failure.