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.