Result Database Relation

[PeggyC]

I am looking at the TestStand, looking into the result database and trying to make sense out of whole thing.  I am more used to the Access database terminology.  So, from the database, I see the following table

PROP_ANALOGWAVEFORM

PROP_BINARY

PROP_DIGITALWAVEFORM

PROP_NUMERICLIMIT

PROP_RESULT

STEP_RESULT

STEP_SEQCALL

UUT_RESULT

View Step & Property Results

View Step & Property Results - All Measurements

View UUT & Step Results

View UUT Results

Can someone provide some pointers on how all these table are related?

Thanks.

Peggy

[Norbert_B]

Peggy,

if you look into the database using Access, you should already see some relations.

The topmost level would be UUT_RESULT. This has relations to e.g. STEP_RESULT. STEP_RESULT has relations to the different PROP_-tables in regard to the type of the step. So if a step is a numeric limit step, it will have a relation to PROP_NUMERICLIMIT.

The "View" entries are interfaces to create SQL-statements in order to query for certain values. So this has nothing to do with the tables first of all. It only connects to the tables in order to browse for requested entries.

The relations between tables are realized in the database schema you use in TestStand. The table UUT_RESULT has a primary key, which is a counter. The table STEP_RESULT has also a counter as primary key (which is prerequisite), but also introduces a foreign key, which refers to the primary key of the table UUT_RESULT.

So a single UUT creates a single record in UUT_RESULT (lets call its primary key "n"). In the STEP_RESULT table you will find e.g. 5 steps (x, x+1, x+2,..,x+4) which will all share the foreign key "n". This is the relation......

hope this helps,

Norbert 

[PeggyC]

Thanks.  I guess I am doing quite a bit of reverse engineering.  I think I am getting the idea now, but there are still fields I am not sure about the purpose.  For example:

1. How is PROP_NUMERICLIMIT linked to the STEP_RESULT?  It looks like "PROP_RESULT" is the foreign key, but I don't know how to relate to the STEP_RESULT table.

2. What is STEP_RESULT.STEP_GROUP field?  From the "computer.seq" demo result, it has "Setup", "Main", and "Cleanup".  What are they mean in terms of the TestStand execution?

3. In the STEP_RESULT table, there are also some mystery field : STEP_RESULT.CAUSED_SEQFAIL, STEP_RESULT.INTERACTIVE_EXENUM?  What is their purpose?

Last, as I am evaluating the result recording mechanism.  It looks like TestStand is storing the execution result in a runtime variable TestResult list.  Would there be a limit on how much it can store (ie. number of step, memory, etc.)?

Thank you.

Peggy

[Dennis_Knutson]

STEP_RESULT is linked to PROP_RESULT. If the step type is a numeric limit or multiple numeric limit, the data is stored in the PROP_NUMERICLIMIT table. So, STEP_RESULT is linked to PROP_RESULT which is linked to PROP_NUMERICLIMIT. It's often handly to use a tool like Visio to draw out all of the relationships. Or, load the schema into Access and get a view of it there.

What the startup, main, cleanup groups are is defined in the user manual. What an interactive execution is is also defined there (and in the help).

Each step has several run options. One is that a step failure will cause a sequence failure. You can turn this off so it's just another step property to be logged.

[PeggyC]

I missed the PROP_RESULT table.  Thank you.  My question is answered.