The following diagrams visualize the relationships between different tables within the Mercury DWH, and between Mercury and other data marts such as SLXRE2_RG_Ancestry, Sample_QC_Metrics, SLXRE2_Library_Pico_Quant, SLXRE2_Library_Agg_QC and SLXRE2_Sample_Agg_QC and RG_Ancestry.
In the diagrams, PK refers to the Primary Key and UK refers to Unique Keys within the tablesĀ (confirm about UK - RAS 05/03/19).