here's a first idea on what the new schema might look like:
Release Table:
-----------------------------------------+
ReleaseID |
Package |
Version |
VersionLabel |
-----------------------------------------+
SystemTest Table:
---------------------------------------------------------------------------------+
SystemTestID |
ReleaseID |
Status |
Output |
StandardID |
TestName |
Result |
Events |
CPU |
MEM |
---------------------------------------------------------------------------------+
Metadata Table:
-----------------------------------------------
SystemTestID |
Histogram |
Label |
Value |
Threshold |
-----------------------------------------------
OutputFile Table:
---------------------------
SystemTestID |
Label |
Value |
---------------------------
Release Table contains an entry for each RM checked out package.
SystemTest table contains all the test done for a specific entry in Release Table
Metadata table contains all the metadata of a specific test in SystemTest
OutputFile contains the files written out for a specific SystemTest.
I'm not sure how the triggering of it will work. I am considering making it a script that's part of the RM set of scripts which get executed in order.