There are 2 schemas in SEQPROD
- MERCURYDW - actual DWH refreshed by Mercury ETL
- MERCURYDWRO - provides Read-Only access to data in MERCURYDW.
PK = Primary Key
UK = Unique Key
Mercurydw table relationships
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | truefalse |
|---|
| align | center |
|---|
| pageId | left613974036 |
|---|
| type | rich |
|---|
| autoSize | 1 |
|---|
| macroId | 9a971060-5943-4a70-bbd8-b4a7f7b4cb52 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 1 |
|---|
| width | 1000 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updatedconsumerKey | 1554399139661Confluence:8792679401 |
|---|
| height | 1000 |
|---|
|
SLXRE2_RG_Ancestry
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | leftcenter |
|---|
| type | rich |
|---|
| autoSize | 10 |
|---|
| macroId | 46dc74c1-451c-4750-913a-fb301f1ef948 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 2 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 15543991234081555530379186 |
|---|
| height | 500 |
|---|
|
Sample_QC_Metrics
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | leftcenter |
|---|
| type | rich |
|---|
| autoSize | 10 |
|---|
| macroId | 8af007485cd6f175-c6ecdcfd-47a044dd-953d9fe3-bdc306a4fa0cd73101b4dadc |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 3 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 15543991707171555530436970 |
|---|
| height | 500 |
|---|
|
SLXRE2_Library_Pico_Quant
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | leftcenter |
|---|
| type | rich |
|---|
| autoSize | 10 |
|---|
| macroId | 8af00748b549f413-c6ec5d87-47a04bf3-953d8a6e-bdc306a4fa0ce40cdf3f2e36 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 4 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 15543991872681555530456590 |
|---|
| height | 500 |
|---|
|
SLXRE2_Library_Agg_QC & SLXRE2_Sample_Agg_QC
| Lucidchart |
|---|
| pageCount | 6 |
|---|
| autoUpdate | false |
|---|
| align | leftcenter |
|---|
| type | rich |
|---|
| autoSize | 10 |
|---|
| macroId | 8af007484f91a3b6-c6ec90c5-47a04744-953db6c9-bdc306a4fa0ca5ff09560c90 |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 5 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 15543992165021555530491868 |
|---|
| height | 500 |
|---|
|
RG_Ancestry
| Lucidchart |
|---|
| pageCount | 7 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| type | rich |
|---|
| autoSize | 0 |
|---|
| macroId | fd77965b-447c-4f97-a22c-f3fa9aa2108f |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 6 |
|---|
| width | 350 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updated | 1557773071892 |
|---|
| height | 450 |
|---|
|
Array_Process_Flow
| Lucidchart |
|---|
| pageCount | 7 |
|---|
| autoUpdate | false |
|---|
| align | center |
|---|
| pageId | left613974036 |
|---|
| type | rich |
|---|
| autoSize | 1 |
|---|
| macroId | 8af0074801cf33bb-c6ec8a59-47a04718-953d864e-bdc306a4fa0c7891aa654def |
|---|
| instanceId | Confluence:8792679401 |
|---|
| pages | 67 |
|---|
| width | 700 |
|---|
| documentId | 6a618b32-c268-4b8a-b012-eaf615a4f960 |
|---|
| documentToken | 6a618b32-c268-4b8a-b012-eaf615a4f960|42323|613974036|vOAuA/l75EFPL+VzlIlJ9jRWkopwfEurbt18lmxOH9M= |
|---|
| updatedconsumerKey | 1554399239444Confluence:8792679401 |
|---|
| height | 500 |
|---|
|