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.
To be included in diagram (RAS 5/8/2019)
describe mercurydw.array_process_flow
Name Null? Type
----------------------------- -------- -------------
PRODUCT_ORDER_ID NOT NULL NUMBER(19)
BATCH_NAME NOT NULL VARCHAR2(40)
LCSET_SAMPLE_NAME NOT NULL VARCHAR2(40)
HYB_EVENT_ID NUMBER(19)
HYB_STATION VARCHAR2(255)
HYB_POSITION VARCHAR2(32)
SAMPLE_NAME VARCHAR2(40)
HYB_DATE DATE
CHIP VARCHAR2(64)
CHIP_WELL_BARCODE VARCHAR2(64)
AMP_EVENT_ID NUMBER(19)
AMP_STATION VARCHAR2(255)
AMP_PLATE_POSITION VARCHAR2(32)
AMP_DATE DATE
AMP_PLATE VARCHAR2(64)
PLATING_EVENT_ID NUMBER(19)
PLATING_DILUTION_STATION VARCHAR2(255)
DNA_PLATE_POSITION VARCHAR2(32)
PLATING_DILUTION_DATE DATE
DNA_PLATE VARCHAR2(64)
DNA_PLATE_NAME VARCHAR2(255)
POST_FRAG_EVENT_ID NUMBER(19)
POST_FRAG_HYB_OVEN VARCHAR2(255)
POST_FRAG_HYB_OVEN_DATE DATE
FRAG_EVENT_ID NUMBER(19)
FRAG_STATION VARCHAR2(255)
FRAG_DATE DATE
PRECIP_EVENT_ID NUMBER(19)
PRECIP_STATION VARCHAR2(255)
PRECIP_DATE DATE
POST_PRECIP_EVENT_ID NUMBER(19)
POST_PRECIP_HYB_OVEN VARCHAR2(255)
POST_PRECIP_HYB_OVEN_DATE DATE
PRECIP_IPA_EVENT_ID NUMBER(19)
PRECIP_IPA_STATION VARCHAR2(255)
PRECIP_IPA_DATE DATE
RESUSPENSION_EVENT_ID NUMBER(19)
RESUSPENSION_STATION VARCHAR2(255)
RESUSPENSION_DATE DATE
POSTRESUSPHYBOVEN_EVENT_ID NUMBER(19)
POSTRESUSPHYBOVEN_STATION VARCHAR2(255)
POSTRESUSPHYBOVEN_DATE DATE
POSTHYBHYBOVENLOADED_EVENT_ID NUMBER(19)
POSTHYBHYBOVENLOADED_STATION VARCHAR2(255)
POSTHYBHYBOVENLOADED_DATE DATE
HYBCHAMBERLOADED_EVENT_ID NUMBER(19)
HYBCHAMBERLOADED VARCHAR2(255)
HYBCHAMBERLOADED_DATE DATE
XSTAIN_EVENT_ID NUMBER(19)
XSTAIN VARCHAR2(255)
XSTAIN_DATE DATE
AUTOCALL_EVENT_ID NUMBER(19)
AUTOCALL_STARTED DATE
SCANNER VARCHAR2(255)
ETL_MOD_TIMESTAMP NOT NULL DATE