dist_puml/puml/level_4_erd.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentStyleType="text/css" height="982px" preserveAspectRatio="none" style="width:936px;height:982px;background:#FFFFFF;" version="1.1" viewBox="0 0 936 982" width="936px" zoomAndPan="magnify"><defs/><g><rect height="60.5313" style="stroke:#00000000;stroke-width:1.0;fill:none;" width="289" x="0" y="0"/><text fill="#888888" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="3" x="286" y="9.2822"> </text><text fill="#000000" font-family="sans-serif" font-size="22" lengthAdjust="spacing" textLength="265" x="24" y="32.0615">Entity Relation Diagram</text><text fill="#888888" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="3" x="286" y="46.5322"> </text><text fill="#888888" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="3" x="286" y="58.1729"> </text><!--MD5=[211fab40221c87d86ad7ebe9069e995a]
class **table 1**--><g id="elem_**table 1**"><rect codeLine="61" fill="#F1F1F1" height="166.3872" id="**table 1**" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="347" x="191" y="146.5313"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="57" x="336" y="164.5264">table 1</text><line style="stroke:#181818;stroke-width:0.5;" x1="192" x2="537" y1="172.8281" y2="172.8281"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="73" x="197" y="189.8232">BigQuery</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="197" y="206.1201"> </text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="164" x="197" y="222.417">Description for table 1</text><line style="stroke:#181818;stroke-width:1.0;stroke-dasharray:1.0,2.0;" x1="192" x2="537" y1="229.7188" y2="229.7188"/><ellipse cx="202" cy="240.7188" fill="none" rx="3" ry="3" style="stroke:#038048;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="16" x="211" y="246.6827">id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="227" y="247.2169">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="236" y="247.2169">string</text><line style="stroke:#181818;stroke-width:1.0;" x1="192" x2="537" y1="254.5187" y2="254.5187"/><ellipse cx="202" cy="265.5187" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="56" x="211" y="271.4826">some_id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="267" y="272.0168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="276" y="272.0168">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="181" x="320" y="272.0168">: Description for some_id</text><ellipse cx="202" cy="282.3186" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="72" x="211" y="288.2825">some_id_2</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="283" y="288.8168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="292" y="288.8168">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="196" x="336" y="288.8168">: Description for some_id_2</text><ellipse cx="202" cy="299.1185" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="48" x="211" y="305.0825">config</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="259" y="305.6167">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="34" x="272" y="305.6167">JSON</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="167" x="310" y="305.6167">: Description for config</text></g><!--MD5=[ad8ed6286682f4fbef377333683ce264]
class **table 2**--><g id="elem_**table 2**"><rect codeLine="73" fill="#F1F1F1" height="249.3807" id="**table 2**" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="333" x="198" y="450.5313"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="57" x="336" y="468.5264">table 2</text><line style="stroke:#181818;stroke-width:0.5;" x1="199" x2="530" y1="476.8281" y2="476.8281"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="73" x="204" y="493.8232">BigQuery</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="204" y="510.1201"> </text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="163" x="204" y="526.417">Description for table 2</text><line style="stroke:#181818;stroke-width:1.0;stroke-dasharray:1.0,2.0;" x1="199" x2="530" y1="533.7188" y2="533.7188"/><ellipse cx="209" cy="544.7188" fill="none" rx="3" ry="3" style="stroke:#038048;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="32" x="218" y="550.6827">id_1</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="250" y="551.2169">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="259" y="551.2169">string</text><ellipse cx="209" cy="561.5187" fill="none" rx="3" ry="3" style="stroke:#038048;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="32" x="218" y="567.4826">id_2</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="250" y="568.0168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="259" y="568.0168">string</text><line style="stroke:#181818;stroke-width:1.0;" x1="199" x2="530" y1="575.3186" y2="575.3186"/><ellipse cx="209" cy="586.3186" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="40" x="218" y="592.2825">label</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="258" y="592.8168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="267" y="592.8168">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="157" x="311" y="592.8168">: Description for label</text><ellipse cx="209" cy="603.1185" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="96" x="218" y="609.0825">scheduled_at</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="314" y="609.6167">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="76" x="323" y="609.6167">timestamp</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="118" x="403" y="609.6167">: Description for</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="94" x="218" y="625.9136">scheduled_at</text><ellipse cx="209" cy="636.2153" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="80" x="218" y="642.1793">foo_bar_ts</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="298" y="642.7135">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="76" x="307" y="642.7135">timestamp</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="118" x="387" y="642.7135">: Description for</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="76" x="218" y="659.0104">foo_bar_ts</text><ellipse cx="209" cy="669.3121" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="48" x="218" y="675.2761">baz_ts</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="266" y="675.8103">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="76" x="275" y="675.8103">timestamp</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="169" x="355" y="675.8103">: Description for baz_ts</text><ellipse cx="209" cy="686.1121" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="48" x="218" y="692.076">abc_ts</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="266" y="692.6102">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="76" x="275" y="692.6102">timestamp</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="169" x="355" y="692.6102">: Description for abc_ts</text></g><!--MD5=[0bfd2ffdd2244f3a6912f400e1835880]
class **table 3**--><g id="elem_**table 3**"><rect codeLine="88" fill="#F1F1F1" height="149.5873" id="**table 3**" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="339" x="7" y="792.5313"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="57" x="148" y="810.5264">table 3</text><line style="stroke:#181818;stroke-width:0.5;" x1="8" x2="345" y1="818.8281" y2="818.8281"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="73" x="13" y="835.8232">BigQuery</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="13" y="852.1201"> </text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="164" x="13" y="868.417">Description for table 3</text><line style="stroke:#181818;stroke-width:1.0;stroke-dasharray:1.0,2.0;" x1="8" x2="345" y1="875.7188" y2="875.7188"/><ellipse cx="18" cy="886.7188" fill="none" rx="3" ry="3" style="stroke:#038048;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="16" x="27" y="892.6827">id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="43" y="893.2169">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="52" y="893.2169">string</text><line style="stroke:#181818;stroke-width:1.0;" x1="8" x2="345" y1="900.5187" y2="900.5187"/><ellipse cx="18" cy="911.5187" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="72" x="27" y="917.4826">thingy_id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="99" y="918.0168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="108" y="918.0168">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="188" x="152" y="918.0168">: Description for thingy_id</text><ellipse cx="18" cy="928.3186" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="48" x="27" y="934.2825">config</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="75" y="934.8168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="34" x="88" y="934.8168">JSON</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="144" x="126" y="934.8168">: Configuration used</text></g><!--MD5=[f0c2e3e1370d5e57b9754a0f8d442a89]
class **type_y_samples_{date}**--><g id="elem_**type_y_samples_{date}**"><rect codeLine="99" fill="#F1F1F1" height="322.0652" id="**type_y_samples_{date}**" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="356" x="573.5" y="68.5313"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="190" x="656.5" y="86.5264">type_y_samples_{date}</text><line style="stroke:#181818;stroke-width:0.5;" x1="574.5" x2="928.5" y1="94.8281" y2="94.8281"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="158" x="579.5" y="111.8232">BigQueryDailyTable</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="579.5" y="128.1201"> </text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="340" x="579.5" y="144.417">A days worth of samples collected during single</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="139" x="579.5" y="160.7139">run of the pipeline.</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="579.5" y="177.0107"> </text><line style="stroke:#181818;stroke-width:1.0;stroke-dasharray:1.0,2.0;" x1="574.5" x2="928.5" y1="184.3125" y2="184.3125"/><ellipse cx="584.5" cy="195.3125" fill="none" rx="3" ry="3" style="stroke:#038048;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="56" x="593.5" y="201.2764">some_id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="649.5" y="201.8107">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="658.5" y="201.8107">string</text><line style="stroke:#181818;stroke-width:1.0;" x1="574.5" x2="928.5" y1="209.1124" y2="209.1124"/><ellipse cx="584.5" cy="220.1124" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="64" x="593.5" y="226.0764">strategy</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="657.5" y="226.6106">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="666.5" y="226.6106">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="177" x="710.5" y="226.6106">: Description of strategy</text><ellipse cx="584.5" cy="236.9124" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="136" x="593.5" y="242.8763">send_for_labeling</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="729.5" y="243.4105">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="58" x="738.5" y="243.4105">boolean</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="112" x="800.5" y="243.4105">: Description of</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="120" x="593.5" y="259.7074">send for labeling</text><line style="stroke:#181818;stroke-width:1.0;stroke-dasharray:1.0,2.0;" x1="574.5" x2="928.5" y1="267.0092" y2="267.0092"/><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="133" x="593.5" y="284.0043">Metadata Columns</text><ellipse cx="584.5" cy="294.306" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="88" x="593.5" y="300.27">model_score</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="681.5" y="300.8042">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="56" x="690.5" y="300.8042">number</text><ellipse cx="584.5" cy="311.106" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="72" x="593.5" y="317.0699">num_views</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="665.5" y="317.6041">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="56" x="674.5" y="317.6041">number</text><ellipse cx="584.5" cy="327.9059" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="80" x="593.5" y="333.8698">is_awesome</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="673.5" y="334.4041">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="58" x="682.5" y="334.4041">boolean</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="593.5" y="350.7009">.</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="593.5" y="366.9978">.</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="593.5" y="383.2947">.</text></g><!--MD5=[8c67a651a6a76ae601e11f41c5c807cf]
class **table 4**--><g id="elem_**table 4**"><rect codeLine="118" fill="#F1F1F1" height="216.2839" id="**table 4**" rx="2.5" ry="2.5" style="stroke:#181818;stroke-width:0.5;" width="345" x="381" y="759.5313"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="57" x="525" y="777.5264">table 4</text><line style="stroke:#181818;stroke-width:0.5;" x1="382" x2="725" y1="785.8281" y2="785.8281"/><text fill="#000000" font-family="sans-serif" font-size="14" font-weight="bold" lengthAdjust="spacing" textLength="73" x="387" y="802.8232">BigQuery</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="4" x="387" y="819.1201"> </text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="163" x="387" y="835.417">Description for table 4</text><line style="stroke:#181818;stroke-width:1.0;stroke-dasharray:1.0,2.0;" x1="382" x2="725" y1="842.7188" y2="842.7188"/><ellipse cx="392" cy="853.7188" fill="none" rx="3" ry="3" style="stroke:#038048;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="16" x="401" y="859.6827">id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="417" y="860.2169">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="426" y="860.2169">string</text><line style="stroke:#181818;stroke-width:1.0;" x1="382" x2="725" y1="867.5187" y2="867.5187"/><ellipse cx="392" cy="878.5187" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="32" x="401" y="884.4826">name</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="433" y="885.0168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="442" y="885.0168">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="156" x="490" y="885.0168">: Description of name</text><ellipse cx="392" cy="895.3186" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="40" x="401" y="901.2825">value</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="441" y="901.8168">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="450" y="901.8168">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="153" x="498" y="901.8168">: Description of value</text><ellipse cx="392" cy="912.1185" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="80" x="401" y="918.0825">labeler_id</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="481" y="918.6167">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="490" y="918.6167">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="186" x="534" y="918.6167">: Description of labeler_id</text><ellipse cx="392" cy="928.9185" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="48" x="401" y="934.8824">source</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="449" y="935.4166">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="458" y="935.4166">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="163" x="502" y="935.4166">: Description of source</text><ellipse cx="392" cy="945.7184" fill="#000000" rx="3" ry="3" style="stroke:#000000;stroke-width:1.0;"/><text fill="#000000" font-family="monospace" font-size="14" lengthAdjust="spacing" textLength="128" x="401" y="951.6823">some_other_field</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="5" x="529" y="952.2166">:</text><text fill="#000000" font-family="sans-serif" font-size="14" font-style="italic" lengthAdjust="spacing" textLength="40" x="538" y="952.2166">string</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="112" x="582" y="952.2166">: Description of</text><text fill="#000000" font-family="sans-serif" font-size="14" lengthAdjust="spacing" textLength="125" x="401" y="968.5134">some_other_field</text></g><!--MD5=[5a4626a73b92b07a534ee26850a4d4d4]
reverse link **table 1** to **table 2**--><g id="link_**table 1**_**table 2**"><path codeLine="132" d="M364.5,320.7273 C364.5,320.7273 364.5,450.3533 364.5,450.3533 " fill="none" id="**table 1**-backto-**table 2**" style="stroke:#181818;stroke-width:1.0;"/><line style="stroke:#181818;stroke-width:1.0;" x1="364.5" x2="358.5" y1="320.7273" y2="312.7273"/><line style="stroke:#181818;stroke-width:1.0;" x1="364.5" x2="370.5" y1="320.7273" y2="312.7273"/><line style="stroke:#181818;stroke-width:1.0;" x1="364.5" x2="364.5" y1="320.7273" y2="312.7273"/><ellipse cx="364.5" cy="326.7273" fill="none" rx="4" ry="4" style="stroke:#181818;stroke-width:1.0;"/></g><!--MD5=[fbb5996e07abeed7a4f3af40ddb4d8d6]
reverse link **table 2** to **table 3**--><g id="link_**table 2**_**table 3**"><path codeLine="133" d="M272,707.9263 C272,707.9263 272,792.5183 272,792.5183 " fill="none" id="**table 2**-backto-**table 3**" style="stroke:#181818;stroke-width:1.0;"/><line style="stroke:#181818;stroke-width:1.0;" x1="272" x2="266" y1="707.9263" y2="699.9263"/><line style="stroke:#181818;stroke-width:1.0;" x1="272" x2="278" y1="707.9263" y2="699.9263"/><line style="stroke:#181818;stroke-width:1.0;" x1="272" x2="272" y1="707.9263" y2="699.9263"/><ellipse cx="272" cy="713.9263" fill="none" rx="4" ry="4" style="stroke:#181818;stroke-width:1.0;"/></g><!--MD5=[2a9a20bb0bbaaa67466a426b94cb646f]
reverse link **table 2** to **table 4**--><g id="link_**table 2**_**table 4**"><path codeLine="134" d="M456,707.9263 C456,707.9263 456,759.1983 456,759.1983 " fill="none" id="**table 2**-backto-**table 4**" style="stroke:#181818;stroke-width:1.0;"/><line style="stroke:#181818;stroke-width:1.0;" x1="456" x2="450" y1="707.9263" y2="699.9263"/><line style="stroke:#181818;stroke-width:1.0;" x1="456" x2="462" y1="707.9263" y2="699.9263"/><line style="stroke:#181818;stroke-width:1.0;" x1="456" x2="456" y1="707.9263" y2="699.9263"/><ellipse cx="456" cy="713.9263" fill="none" rx="4" ry="4" style="stroke:#181818;stroke-width:1.0;"/></g><!--MD5=[d158393d7c1dde3c1bf237102ac8eff6]
@startuml
' Tables
!global $TYPE_X_SAMPLE_POOL_TABLE = "type_x_sample_pool"
!global $TYPE_Y_SAMPLE_POOL_TABLE = "type_y_sample_pool"
!unquoted procedure $SAMPLE_POOL_TABLE_DESC()
A subquery from which to query samples, should be joined to any
columns that you want to include in the $DAILY_COLLECTED_SAMPLES_TABLE table
!endprocedure

!global $SAMPLE_LABELS_TABLE = "some_other_label_db"
!global $SAMPLE_LABELS_ID = "sampleLabelsDb"
!global $SAMPLE_LABELS_CONTAINER_DESC = $LABELED_DATASOURCE_DESC
!global $SAMPLE_LABELS_COMPONENT_DESC = "Stores all samples which have been labeled.\n"
!global $SAMPLE_LABELS_TYPE = "BigTable"
!global $SAMPLE_LABELS_SCHEMA = "https://docs.google.com/spreadsheets"

!global $DAILY_COLLECTED_SAMPLES_TABLE = "type_y_samples_{date}"
!global $DAILY_COLLECTED_SAMPLES_ID = "dailySamplesDb"
!global $DAILY_COLLECTED_SAMPLES_DESC = "A days worth of samples collected during single run of the pipeline.\n"
!global $DAILY_COLLECTED_SAMPLES_TYPE = "BigQueryDailyTable"

!global $LABELED_DATASOURCE_ID = "labeledDatasource"
!global $LABELED_DATASOURCE_NAME = "labeled_datasource_bucket"
!global $LABELED_DATASOURCE_TYPE = "GCS"
!global $LABELED_DATASOURCE_DESC = "Where the labelers write their labeling results"

'Columns
!global $SEND_FOR_LABELING_COLUMN = "send_for_labeling"
!global $CONTENT_ID_COLUMN = "some_id"

!global $SYSTEM_NAME = "My Project Name"



hide circle
skinparam linetype ortho
skinparam wrapWidth 350

left header

\t<font size=22 color=black>Entity Relation Diagram</font>


end header

!global $TABLE_1 = 'table 1'
!global $TABLE_1_TYPE = 'BigQuery'
!global $TABLE_1_DESC = 'Description for table 1'

!global $TABLE_2 = 'table 2'
!global $TABLE_2_TYPE = 'BigQuery'
!global $TABLE_2_DESC = 'Description for table 2'

!global $TABLE_3 = 'table 3'
!global $TABLE_3_TYPE = 'BigQuery'
!global $TABLE_3_DESC = 'Description for table 3'

!global $TABLE_4 = 'table 4'
!global $TABLE_4_TYPE = 'BigQuery'
!global $TABLE_4_DESC = 'Description for table 4'

entity "**$TABLE_1**" {
  **$TABLE_1_TYPE**

  $TABLE_1_DESC
  ..
  + ""id"": //string //
  - -
  * ""some_id"": //string //: Description for some_id
  * ""some_id_2"": //string// : Description for some_id_2
  * ""config"": // JSON //: Description for config
}

entity "**$TABLE_2**" {
  **$TABLE_2_TYPE**

  $TABLE_2_DESC
  ..
  + ""id_1"": //string //
  + ""id_2"": //string //
  - -
  * ""label"": //string //: Description for label
  * ""scheduled_at"": //timestamp //: Description for scheduled_at
  * ""foo_bar_ts"": //timestamp //: Description for foo_bar_ts
  * ""baz_ts"": //timestamp //: Description for baz_ts
  * ""abc_ts"": //timestamp //: Description for abc_ts
}

entity "**$TABLE_3**" {
  **$TABLE_3_TYPE**

  $TABLE_3_DESC
  ..
  + ""id"": //string //
  - -
  * ""thingy_id"": //string //: Description for thingy_id
  * ""config"": // JSON //: Configuration used
}

entity "**$DAILY_COLLECTED_SAMPLES_TABLE**" {
  **$DAILY_COLLECTED_SAMPLES_TYPE**

  $DAILY_COLLECTED_SAMPLES_DESC
  ..
  + ""$CONTENT_ID_COLUMN"": //string //
  - -
  *""strategy"": //string //: Description of strategy
  *""$SEND_FOR_LABELING_COLUMN"": //boolean //: Description of send for labeling
  ..
  Metadata Columns
  *""model_score"": //number //
  *""num_views"": //number //
  *""is_awesome"": //boolean //
  .
  .
  .
}

entity "**$TABLE_4**" {
  **$TABLE_4_TYPE**

  $TABLE_4_DESC
  ..
  + ""id"": //string//
  - -
  *""name"": //string  //: Description of name
  *""value"": //string  //: Description of value
  *""labeler_id"": //string //: Description of labeler_id
  *""source"": //string //: Description of source
  *""some_other_field"": //string //: Description of some_other_field
}

"**$TABLE_1**" }o- - "**$TABLE_2**"
"**$TABLE_2**" }o- - "**$TABLE_3**"
"**$TABLE_2**" }o- - "**$TABLE_4**"
@enduml

@startuml








hide circle
skinparam linetype ortho
skinparam wrapWidth 350

left header

\t<font size=22 color=black>Entity Relation Diagram</font>


end header





entity "**table 1**" {
  **BigQuery**

  Description for table 1
  ..
  + ""id"": //string //
  - -
  * ""some_id"": //string //: Description for some_id
  * ""some_id_2"": //string// : Description for some_id_2
  * ""config"": // JSON //: Description for config
}

entity "**table 2**" {
  **BigQuery**

  Description for table 2
  ..
  + ""id_1"": //string //
  + ""id_2"": //string //
  - -
  * ""label"": //string //: Description for label
  * ""scheduled_at"": //timestamp //: Description for scheduled_at
  * ""foo_bar_ts"": //timestamp //: Description for foo_bar_ts
  * ""baz_ts"": //timestamp //: Description for baz_ts
  * ""abc_ts"": //timestamp //: Description for abc_ts
}

entity "**table 3**" {
  **BigQuery**

  Description for table 3
  ..
  + ""id"": //string //
  - -
  * ""thingy_id"": //string //: Description for thingy_id
  * ""config"": // JSON //: Configuration used
}

entity "**type_y_samples_{date}**" {
  **BigQueryDailyTable**

  A days worth of samples collected during single run of the pipeline.\n
  ..
  + ""some_id"": //string //
  - -
  *""strategy"": //string //: Description of strategy
  *""send_for_labeling"": //boolean //: Description of send for labeling
  ..
  Metadata Columns
  *""model_score"": //number //
  *""num_views"": //number //
  *""is_awesome"": //boolean //
  .
  .
  .
}

entity "**table 4**" {
  **BigQuery**

  Description for table 4
  ..
  + ""id"": //string//
  - -
  *""name"": //string  //: Description of name
  *""value"": //string  //: Description of value
  *""labeler_id"": //string //: Description of labeler_id
  *""source"": //string //: Description of source
  *""some_other_field"": //string //: Description of some_other_field
}

"**table 1**" }o- - "**table 2**"
"**table 2**" }o- - "**table 3**"
"**table 2**" }o- - "**table 4**"
@enduml

PlantUML version 1.2022.7beta2(Unknown compile time)
(GPL source distribution)
Java Runtime: Java(TM) SE Runtime Environment
JVM: Java HotSpot(TM) 64-Bit Server VM
Default Encoding: UTF-8
Language: en
Country: US
--></g></svg>