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.
...