Skip to content

DataWithBaraa/claude-code-data-engineering-skills / skills/impact

impact

Verified

Use before you change a table, a column or a function, to see what it is built from, what depends on it, who reads it, which checks cover it, and the safe order of the change.

references/impact.html

View on GitHub
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Impact of a change to orders · newvolt-data-platform</title>
<style>
@font-face{font-family:'Bricolage Grotesque';font-weight:200 800;font-display:block;src:url('fonts/BricolageGrotesque-700.woff2') format('woff2');}
@font-face{font-family:'JetBrains Mono';font-weight:100 800;font-display:block;src:url('fonts/JetBrainsMono-500.woff2') format('woff2');}
*{margin:0;padding:0;box-sizing:border-box;}
:root{--bg:#0f0a1e;--plate:#1a1230;--ink:#ece7f8;--ink-2:rgba(236,231,248,.72);--line:rgba(236,231,248,.14);--line-2:rgba(236,231,248,.08);
  --purple:#8a63f2;--purple-soft:#c9b8ff;--red:#ff8a73;--orange:#ffa657;--gold:#ffd23f;}
html{background:var(--bg);}
body{font-family:'Bricolage Grotesque',sans-serif;font-weight:400;color:var(--ink);background:var(--bg);font-size:20px;line-height:1.5;-webkit-font-smoothing:antialiased;}
.id,code,pre,.t td.m,.t td.num{font-family:'JetBrains Mono',monospace;font-variant-ligatures:none;}
.id{font-size:.95em;color:var(--purple-soft);white-space:nowrap;}
.nw{white-space:nowrap;}
.red{color:var(--red);} .orange{color:var(--orange);} .dim{color:var(--ink-2);}
a{color:inherit;text-decoration:none;}
[id]{scroll-margin-top:100px;}

/* the top bar */
nav{position:sticky;top:0;z-index:10;height:72px;background:#0d0919;border-bottom:1px solid var(--line);display:flex;align-items:center;padding:0 48px;gap:28px;white-space:nowrap;}
nav .brand{font-family:'JetBrains Mono',monospace;font-size:20px;color:var(--ink);margin-right:12px;}
nav a.p{font-size:19px;color:var(--ink-2);padding:8px 12px;border-radius:8px;}
nav a.p:hover{color:var(--ink);background:rgba(236,231,248,.05);}
nav a.p.on{color:var(--ink);background:rgba(138,99,242,.2);}
nav .built{margin-left:auto;font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink-2);white-space:nowrap;}
main{max-width:1440px;margin:0 auto;padding:56px 48px 160px;}
p,.one,.lead{text-wrap:pretty;}

/* head */
h1{font-size:48px;font-weight:800;letter-spacing:-.02em;line-height:1.05;}
.lead{margin-top:14px;font-size:24px;line-height:1.4;}
.kpis{margin-top:36px;display:grid;grid-template-columns:repeat(6,minmax(0,1fr));border-top:1px solid var(--line);border-bottom:1px solid var(--line);}
.kpis.k5{grid-template-columns:repeat(5,minmax(0,1fr));} .kpis.k4{grid-template-columns:repeat(4,minmax(0,1fr));}
.kpi{padding:22px 20px 22px 0;}
.kpi + .kpi{border-left:1px solid var(--line);padding-left:22px;}
.kpi .l{font-size:19px;color:var(--ink-2);}
.kpi .v{margin-top:8px;font-size:44px;font-weight:700;line-height:1;letter-spacing:-.01em;white-space:nowrap;}
.kpi .sub{margin-top:8px;font-size:18px;color:var(--ink-2);font-family:'JetBrains Mono',monospace;white-space:nowrap;}
main > .s:first-of-type{margin-top:64px;} .kpis{margin-top:28px;} .kpis + .s{margin-top:80px;}
.kpi .v.red{color:var(--red);} .kpi .v.orange{color:var(--orange);} .kpi .v.sm{font-size:36px;margin-top:12px;}
.kpi .v .id{font-size:44px;font-weight:700;color:var(--ink);}

/* screens */
.s{margin-top:104px;} .s.run-s{margin-top:152px;}
.s h2{font-size:32px;font-weight:700;letter-spacing:-.01em;line-height:1.15;text-wrap:balance;}
.s h2 .id{font-size:.9em;font-weight:600;}
.s .one{margin-top:8px;font-size:22px;font-weight:400;line-height:1.45;}
.vis{margin-top:30px;}
.vis svg{display:block;}

/* tables */
table.t{width:100%;border-collapse:collapse;}
.t th{font-size:17px;font-weight:600;color:var(--ink-2);text-align:left;padding:0 28px 12px 0;border-bottom:1px solid var(--line);white-space:nowrap;}
.t th.num{text-align:right;} .t th.grow{width:100%;}
.t td{padding:12px 28px 12px 0;border-bottom:1px solid var(--line-2);vertical-align:baseline;font-size:20px;line-height:1.4;white-space:nowrap;}
.t td:last-child,.t th:last-child{padding-right:0;}
.t td.m,.t td.num{font-size:19px;} .t td.num{text-align:right;}
.t td.col{color:var(--ink);font-weight:600;}
.t td.wrap{white-space:normal;line-height:1.45;text-wrap:balance;}
.t th.w100{width:100px;} .t th.w130{width:130px;} .t th.w160{width:160px;} .t th.w180{width:180px;} .t th.w200{width:200px;} .t th.w240{width:240px;} .t th.w290{width:290px;} .t th.w320{width:320px;} .t th.w400{width:400px;} .t th.w230{width:230px;} .t th.w250{width:250px;} .t th.w260{width:260px;} .t th.w270{width:270px;} .t th.w280{width:280px;} .t th.w300{width:300px;} .t th.w420{width:420px;} .t th.w110{width:110px;} .t th.w150{width:150px;} .t th.w170{width:170px;} .t th.w200{width:200px;} .t th.w220{width:220px;} .t th.w330{width:330px;}
.lin .node circle.cross{fill:var(--bg);stroke:var(--purple-soft);stroke-width:1.5;}
.lin .wire.bus path,.lin .wire.bus circle{opacity:0;}
.lin .wire.bus.up path,.lin .wire.bus.up circle,.lin .wire.bus.down path,.lin .wire.bus.down circle{opacity:1;}
.t.fixed{table-layout:fixed;} .t.fixed td{white-space:normal;}
.t td.bar{vertical-align:middle;} .t .b{fill:var(--purple);}
table.t.auto{width:auto;min-width:60%;} .t.auto th.grow{width:auto;}
table.t.w1060{width:1060px;}

/* pipeline of layers, as on the incident map */
.layers{display:flex;align-items:stretch;}
.layers .arr{flex:none;width:40px;align-self:center;color:var(--ink-2);}
.layer{flex:1;min-width:0;border:1px solid var(--line);border-radius:12px;padding:16px 18px 18px;background:rgba(236,231,248,.03);}
.layer .nm{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--purple-soft);}
.layer .cnt{margin-top:8px;font-size:40px;font-weight:700;line-height:1;}
.layer .cnt small{font-size:19px;font-weight:600;color:var(--ink-2);margin-left:8px;}
.layer .sub{margin-top:10px;font-size:18px;color:var(--ink-2);line-height:1.35;}
.layer.red{border:2px dashed var(--red);background:none;} .layer.red .cnt{color:var(--red);}
.layer.gold{border-color:rgba(255,210,63,.6);}
.arr svg{width:40px;height:24px;fill:none;stroke:var(--ink-2);stroke-width:2;stroke-linecap:round;stroke-linejoin:round;}
.arr.gate svg{width:56px;height:56px;} .layers .arr.gate{width:56px;} .arr.gate circle{stroke:var(--purple-soft);} .arr.gate text{fill:var(--ink);stroke:none;font-family:'JetBrains Mono',monospace;font-size:17px;}

/* the page list */
.plist{border-top:1px solid var(--line);}
.prow{display:grid;grid-template-columns:220px minmax(0,1fr) 470px;column-gap:28px;align-items:baseline;padding:18px 0;border-bottom:1px solid var(--line-2);}
.prow:hover{background:rgba(236,231,248,.03);}
.prow .t1{font-size:24px;font-weight:700;} .prow .t2{font-size:20px;color:var(--ink-2);} .prow .t3{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--purple-soft);text-align:right;}

.run{display:grid;grid-template-columns:minmax(0,1fr) minmax(0,1fr);column-gap:32px;}
.plate{border:1px solid var(--line);border-radius:14px;padding:26px 30px 28px;background:var(--plate);}
.plate .k{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink-2);}
.plate .v{margin-top:8px;font-size:40px;font-weight:800;letter-spacing:-.02em;line-height:1;}
.plate .v .st{font-size:22px;font-weight:600;margin-left:12px;vertical-align:4px;}
.plate .line{margin-top:16px;font-size:19px;color:var(--ink-2);line-height:1.5;}
.plate .line.raw{font-family:'JetBrains Mono',monospace;}
.st.held,.st.red,.st.failed{color:var(--red);} .st.skipped{color:var(--orange);}

/* strips */
.strips{display:grid;row-gap:24px;}
.strip{display:grid;grid-template-columns:270px minmax(0,1fr) 260px;align-items:center;column-gap:24px;}
.strip .nm{font-size:19px;}
.strip .cells{display:flex;gap:4px;flex-wrap:wrap;}
.strip .cells i{display:block;width:26px;height:22px;border-radius:3px;background:var(--purple);}
.strip .cells i.orange{background:var(--orange);} .strip .cells i.red{background:var(--red);} .strip .cells i.dim{background:rgba(236,231,248,.16);}
.strip .cnt{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink-2);text-align:right;white-space:nowrap;}
.strip .cnt b{font-weight:600;}

/* charts */
svg text{font-family:'Bricolage Grotesque',sans-serif;}
svg .lbl{font-size:20px;fill:var(--ink);} svg .lbl tspan.m,svg .m{font-family:'JetBrains Mono',monospace;font-size:19px;}
svg .val{font-family:'JetBrains Mono',monospace;font-size:19px;fill:var(--ink);}
svg .bar{fill:var(--purple);} svg .bar.red{fill:var(--red);} svg .bar.orange{fill:var(--orange);} svg .bar.dim{fill:rgba(236,231,248,.16);}
svg .axis{font-size:18px;font-weight:600;fill:var(--ink-2);}
svg .base{stroke:var(--line);stroke-width:1.5;} svg .tick{stroke:rgba(236,231,248,.3);stroke-width:1.5;}

/* the run calendar */
.cal{display:grid;grid-template-columns:repeat(31,minmax(0,1fr));gap:6px;}
.cal a{display:block;border:1px solid var(--line);border-radius:8px;padding:10px 0 9px;text-align:center;background:rgba(236,231,248,.03);}
.cal a .d{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink);}
.cal a .s{display:block;margin:8px auto 0;width:28px;height:28px;border-radius:6px;background:var(--purple);}
.t.runs tr.hit td{background:rgba(138,99,242,.12);}
.cal a.held .s,.cal a.red .s{background:var(--red);}
.steps{display:flex;gap:2px;height:16px;}
.steps i{display:block;height:16px;border-radius:2px;background:var(--purple);}
.steps i.held,.steps i.red{background:var(--red);} .steps i.off{background:rgba(236,231,248,.12);}
.t td.note{white-space:normal;font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink-2);line-height:1.45;}
.t.runs{table-layout:fixed;}
.t.runs col.c1{width:140px} .t.runs col.c2{width:120px} .t.runs col.c3{width:200px} .t.runs col.c4{width:130px} .t.runs col.c5{width:110px}
.t.runs td.bar{vertical-align:top;padding-top:18px;}
.t td.st{font-family:'JetBrains Mono',monospace;font-size:19px;font-weight:500;}
.t.runs tr{scroll-margin-top:100px;}
.t.runs tr:target td,.t.runs tr.hit td{background:rgba(138,99,242,.12);}

/* catalog */
.search{display:flex;align-items:center;gap:20px;margin-top:36px;}
.search input{flex:1;font:inherit;font-size:22px;color:var(--ink);background:var(--plate);border:1px solid var(--line);border-radius:12px;padding:16px 20px;outline:none;}
.search input:focus{border-color:var(--purple);}
.search .n{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink-2);white-space:nowrap;}
.sec{margin-top:64px;}
.sec h2{display:flex;align-items:baseline;gap:18px;font-size:28px;font-weight:700;}
.sec h2 .id{font-size:.85em;font-weight:600;} .sec h2 .n{font-size:19px;font-weight:500;color:var(--ink-2);}
.sec .one{margin-top:6px;font-size:20px;color:var(--ink-2);}
.tbl{border-top:1px solid var(--line-2);}
.tbl .row{display:grid;grid-template-columns:28px 400px minmax(0,1fr) 110px 280px;column-gap:20px;align-items:baseline;padding:13px 0;border-bottom:1px solid var(--line-2);cursor:pointer;}
.tbl .row:hover{background:rgba(236,231,248,.03);}
.tbl .row .tri{font-size:18px;color:var(--ink-2);transition:transform .15s;} .tbl .row.open .tri{transform:rotate(90deg);}
.tbl .row .nm{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink);}
.tbl .row .ds{font-size:19px;color:var(--ink-2);line-height:1.35;}
.tbl .row .c{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink-2);text-align:right;}
.tbl .row .k{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--purple-soft);line-height:1.35;}
.tbl .cols{display:none;padding:6px 0 18px 48px;border-bottom:1px solid var(--line-2);}
.tbl .cols.open{display:block;}
.tbl .cols .col{display:grid;grid-template-columns:320px 140px minmax(0,1fr);column-gap:20px;padding:6px 0;font-size:18px;}
.tbl .cols .col.full{display:block;color:var(--ink);padding-bottom:12px;}
.tbl .cols .col .cn{font-family:'JetBrains Mono',monospace;color:var(--ink);} .tbl .cols .col .cn.key{color:var(--purple-soft);}
.tbl .cols .col .ct{font-family:'JetBrains Mono',monospace;color:var(--ink-2);} .tbl .cols .col .cd{color:var(--ink-2);}
.hidden{display:none !important;}

/* lineage */
.lin{position:relative;}
.lin svg text{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
.lin .node rect{fill:var(--plate);stroke:var(--line);stroke-width:1;rx:6;}
.lin .node.gold rect{stroke:var(--gold);} .lin .node.stale rect{stroke:var(--red);stroke-dasharray:5 4;}
.lin .node{cursor:pointer;}
.lin .node.on rect{stroke:var(--purple-soft);stroke-width:2;fill:rgba(138,99,242,.22);}
.lin .node.up rect{stroke:var(--purple);stroke-width:2;} .lin .node.down rect{stroke:var(--orange);stroke-width:2;}
.lin .node.off{opacity:.22;}
.lin .wire path{fill:none;stroke:rgba(201,184,255,.32);stroke-width:1.3;}
.lin .wire.up path{stroke:var(--purple);stroke-width:2;} .lin .wire.down path{stroke:var(--orange);stroke-width:2;} .lin .wire.off{opacity:.08;}
.lin .hd{font-size:19px;font-weight:600;fill:var(--ink);font-family:'Bricolage Grotesque',sans-serif;}
.lin .hd2{font-size:17px;fill:var(--ink-2);font-family:'JetBrains Mono',monospace;}
.lin .grp{font-size:17px;fill:var(--ink-2);font-family:'JetBrains Mono',monospace;}
.lin .grp.hd3{font-family:'Bricolage Grotesque',sans-serif;font-size:19px;font-weight:600;fill:var(--ink);}

/* call graph */
.tree{display:grid;row-gap:0;}
.tree{max-width:1060px;}
.tree .n{display:grid;grid-template-columns:480px 300px 120px 160px;align-items:baseline;padding:9px 0;border-bottom:1px solid var(--line-2);}
.tree .n .fn{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink);}
.tree .n.d0 .fn{font-weight:600;color:var(--purple-soft);} .tree .n.d1 .fn{padding-left:0;}
.tree .n.d2 .fn{padding-left:36px;} .tree .n.d3 .fn{padding-left:72px;}
.tree .n .mo{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink-2);}
.tree .n .ln,.tree .n .ca{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--ink-2);text-align:right;}
.tree .hd{display:grid;grid-template-columns:480px 300px 120px 160px;font-size:17px;font-weight:600;color:var(--ink-2);padding-bottom:12px;border-bottom:1px solid var(--line);}
.tree .hd span:nth-child(3),.tree .hd span:nth-child(4){text-align:right;}

/* data model */
.er svg text{font-family:'JetBrains Mono',monospace;font-size:18px;fill:var(--ink);}
.er .ent rect{fill:var(--plate);stroke:var(--line);stroke-width:1;rx:10;}
.er .ent.planned rect{stroke-dasharray:6 5;} .er .ent.planned text{fill:var(--ink-2);}
.er .ent .nm{font-size:21px;font-weight:600;fill:var(--ink);font-family:'Bricolage Grotesque',sans-serif;}
.er .ent.planned .nm{fill:var(--ink-2);}
.er .ent .key{fill:var(--purple-soft);}
.er .rel{fill:none;stroke:rgba(236,231,248,.35);stroke-width:1.5;}
.er .rel.planned{stroke-dasharray:6 5;}
.er .lab{font-size:17px;fill:var(--ink-2);font-family:'JetBrains Mono',monospace;paint-order:stroke;stroke:#0f0a1e;stroke-width:8px;stroke-linejoin:round;}

/* architecture */
.srclist{border-top:1px solid var(--line);}
.src{display:grid;grid-template-columns:200px 180px 260px minmax(0,1fr);column-gap:28px;align-items:baseline;padding:13px 0;border-bottom:1px solid var(--line-2);}
.src .nm{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink);}
.src .f,.src .a{font-size:19px;color:var(--ink-2);} .src .b{font-size:19px;color:var(--ink);}
.src.paused .nm,.src.paused .b{color:var(--ink-2);}
.durbar{display:flex;gap:3px;} .durbar i{display:block;height:28px;border-radius:3px;background:var(--purple);}
.stps{margin-top:20px;display:grid;grid-template-columns:repeat(8,minmax(0,1fr));gap:24px;}
.stp{border-top:1px solid var(--line);padding-top:12px;} .stp .nm{display:block;font-family:'JetBrains Mono',monospace;font-size:17px;color:var(--purple-soft);} .stp .d{display:block;margin-top:4px;font-size:24px;font-weight:700;} .stp .d small{display:block;font-size:17px;font-weight:400;color:var(--ink-2);margin-top:2px;}
.rec{border:1px solid var(--line);border-radius:12px;padding:18px 22px;display:grid;grid-template-columns:repeat(5,minmax(0,1fr));}
.rec div{padding-right:16px;} .rec .k{font-family:'JetBrains Mono',monospace;font-size:18px;color:var(--purple-soft);} .rec .v{margin-top:4px;font-size:19px;color:var(--ink-2);}
.gates4{margin-top:32px;display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:16px;}
.g4{border:1px solid var(--line);border-radius:12px;padding:18px 18px;}
.g4 .h{display:flex;align-items:center;gap:12px;font-size:21px;font-weight:700;}
.g4 .h i{display:inline-flex;flex:none;width:30px;height:30px;border-radius:50%;border:2px solid var(--purple-soft);align-items:center;justify-content:center;font-family:'JetBrains Mono',monospace;font-size:17px;font-style:normal;}
.g4 .cells{margin-top:14px;display:flex;gap:3px;} .g4 .cells i{display:block;flex:1;height:16px;border-radius:2px;background:rgba(236,231,248,.22);} .g4 .cells i.red{background:var(--red);}
.g4 .w{margin-top:8px;font-size:18px;color:var(--ink-2);line-height:1.4;}
.g4 .o{margin-top:10px;font-size:18px;color:var(--ink);} .g4{display:flex;flex-direction:column;} .g4 .o{margin-top:auto;padding-top:10px;} .g4 .o b{color:var(--ink);font-weight:600;}
.g4.live .o b{color:var(--red);}

/* the graph pages */
.lin svg{display:block;}
.lin .node text{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
.lin .node.dead rect{stroke-dasharray:5 4;stroke:rgba(255,138,115,.7);}
.lin .node.dead text{fill:var(--ink-2);}
.lin .wire.dim{stroke:rgba(201,184,255,.16);stroke-dasharray:4 5;}
.lin .node text.sub2{fill:var(--ink-2);font-size:17px;}
.lin .node text{letter-spacing:-.02em;}
.lin .wire .dot{fill:rgba(201,184,255,.6);} .lin .wire.up .dot{fill:var(--purple);} .lin .wire.down .dot{fill:var(--orange);} .lin .wire.off .dot{opacity:.1;}
.lin .wire.bus path{stroke-opacity:.6;} .lin .wire.same path{stroke-opacity:.5;}
.er .sep{stroke:var(--line);stroke-width:1;}
.er .colname{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
.er .colname.key{fill:var(--purple-soft);} .er .colname.fk{fill:var(--ink);}

.er .ct{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink-2);}
.er .ent.fact rect{stroke:var(--gold);} .er .ent.obt rect{stroke-dasharray:6 5;}
.er .stub{fill:rgba(201,184,255,.6);}
.arch2 svg{display:block;}
.t.marts td.wrap{white-space:normal;line-height:1.5;}
.t.marts th:nth-child(3),.t.marts td:nth-child(3){width:300px;min-width:300px;white-space:normal;}
.arch2 text{font-family:'Bricolage Grotesque',sans-serif;}
.arch2 .hd{font-size:19px;font-weight:600;fill:var(--ink);}
.arch2 .nm{font-family:'JetBrains Mono',monospace;font-size:18px;fill:var(--purple-soft);}
.arch2 .sm{font-size:17px;fill:var(--ink-2);}
.arch2 .big{font-size:34px;font-weight:700;fill:var(--ink);}
.arch2 .bx{fill:var(--plate);stroke:var(--line);stroke-width:1;}
.arch2 .bx.gold{stroke:var(--gold);} .arch2 .bx.paused{stroke-dasharray:5 4;}
.arch2 .ar{stroke:rgba(236,231,248,.4);stroke-width:1.5;fill:none;} .arch2 .ar.thick{stroke-width:2;} .arch2 .ar.dash{stroke-dasharray:4 5;}
.arch2 .gt{fill:var(--bg);stroke:var(--purple-soft);stroke-width:2;} .arch2 .gtn{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
.arch2 .step{fill:var(--purple);}
.t.scripts{table-layout:fixed;} .t.scripts td.wrap{white-space:normal;text-wrap:pretty;}

/* level-1 architecture */
.arch2 .l1{font-family:'JetBrains Mono',monospace;font-size:21px;fill:var(--ink);} .arch2 .gtn.big{font-size:19px;}
.arch2 .step{fill:rgba(138,99,242,.32);} .arch2 .step.slow{fill:var(--purple);}
.er .ent.hub rect{stroke:var(--purple-soft);stroke-width:2;} .er .lab{font-size:18px;fill:var(--ink);}
.dead{display:grid;grid-template-columns:repeat(3,minmax(0,1fr));gap:14px 32px;} .dead-fn{border-top:1px solid var(--line-2);padding-top:10px;} .dead-fn .fn{font-size:19px;} .dead-fn .mod,.dead-fn .why{margin-top:4px;font-size:17px;color:var(--ink-2);}
.arch2 .nm-s{font-size:17px;}  .arch2 tspan.mono{font-family:'JetBrains Mono',monospace;font-weight:500;}
.arch2 .l1s{font-size:18px;fill:var(--ink-2);}
.arch2 .l1n{font-size:19px;fill:var(--ink-2);}
.arch2 .bx.ends{fill:none;}
.arch2 tspan.big{font-size:30px;font-weight:700;fill:var(--ink);} .arch2 tspan.sm{font-size:17px;fill:var(--ink-2);}
.arch2 .ah{fill:rgba(236,231,248,.5);}
.arch2 .nm2{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);font-weight:600;}
.arch2 .sm2{font-size:17px;fill:var(--ink-2);}
/* the layers strip and the call graph hubs */
.lin .node.hub rect{stroke:var(--purple-soft);stroke-width:2;}
/* data model level 1 */
.er .ent .key{font-size:17px;}
/* data quality */
svg .hm.c0{fill:rgba(236,231,248,.08);} svg .hm.c1{fill:var(--orange);} svg .hm.c1.soft{fill:none;stroke:rgba(255,166,87,.6);stroke-width:1.5;} svg .hm.c3{fill:var(--red);}
.lates{display:grid;row-gap:14px;}
.late{display:grid;grid-template-columns:260px minmax(0,1fr) 110px;column-gap:24px;align-items:center;}
.late .lbl{font-size:20px;} .late .bar{display:block;height:22px;background:rgba(236,231,248,.08);border-radius:3px;overflow:hidden;}
.late .bar i{display:block;height:22px;background:var(--purple);} .late .bar i.red{background:var(--red);} .late .bar i.orange{background:var(--orange);}
.late .n{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink-2);text-align:right;}
.st.late{color:var(--orange);}
/* catalog */
.tabs{margin-top:28px;display:flex;gap:10px;}
.tab{cursor:pointer;background:transparent;border:1px solid var(--line);border-radius:10px;padding:10px 18px;font:inherit;font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink-2);}
.tab span{margin-left:10px;color:var(--purple-soft);} .tab.on{color:var(--ink);background:rgba(138,99,242,.2);border-color:rgba(138,99,242,.5);}
.csec{margin-top:28px;} .csec .one{font-size:20px;color:var(--ink-2);margin-bottom:14px;}
.crow{border:1px solid var(--line);border-radius:12px;margin-top:8px;background:var(--plate);}
.chead{display:grid;grid-template-columns:24px auto minmax(0,1fr) auto;grid-template-areas:"tri nm tags meta" "tri ds ds ds";column-gap:18px;row-gap:2px;align-items:center;padding:12px 18px;cursor:pointer;}
.chead .tri{grid-area:tri;} .chead .nm{grid-area:nm;} .chead .meta{grid-area:meta;} .chead .tags{grid-area:tags;display:flex;justify-content:flex-start;} .chead .ds{grid-area:ds;}
.chead:hover{background:rgba(236,231,248,.03);}
.crow .tri{font-size:17px;color:var(--ink-2);transition:transform .15s;} .crow.open .tri{transform:rotate(90deg);}
.chead .nm{font-family:'JetBrains Mono',monospace;font-size:19px;color:var(--ink);} .chead .ds{font-size:18px;color:var(--ink-2);white-space:nowrap;}
.chead .meta{display:grid;grid-template-columns:130px 110px 110px 100px;column-gap:18px;text-align:right;font-family:'JetBrains Mono',monospace;font-size:17px;color:var(--ink-2);white-space:nowrap;}
.chead .tag{font-size:17px;color:var(--ink-2);border:1px solid var(--line);border-radius:6px;padding:2px 10px;margin-right:8px;white-space:nowrap;} .chead .tag.bad{color:var(--red);border-color:rgba(255,138,115,.5);}
.crow .cols{display:none;padding:4px 18px 16px 60px;border-top:1px solid var(--line-2);} .crow.open .cols{display:block;}
.crow .col{display:grid;grid-template-columns:280px 150px 50px 220px minmax(0,1fr);column-gap:18px;padding:7px 0;font-size:18px;border-bottom:1px solid var(--line-2);}
.crow .col.hd{color:var(--ink-2);font-size:18px;font-weight:600;border-bottom:1px solid var(--line);}
.crow .col .cn{font-family:'JetBrains Mono',monospace;color:var(--ink);} .crow .col .cn.key{color:var(--purple-soft);} .crow .col .ct,.crow .col .cx,.crow .col .cs{font-family:'JetBrains Mono',monospace;color:var(--ink-2);} .crow .col .cs{color:var(--ink);} .crow .col .cd{color:var(--ink-2);}

/* the surface system: page, paper, card */
.wide{width:1600px;margin-left:-128px;}
.paper{background:linear-gradient(160deg,#1b1436 0%,#110c24 100%);border:1px solid rgba(138,99,242,.28);border-radius:16px;padding:28px;}
.card,.plate,.crow,.cal a,.search input{background:#241a44;border:1px solid rgba(173,150,255,.26);box-shadow:0 1px 0 rgba(0,0,0,.45),0 6px 18px rgba(0,0,0,.25);}
.card{border-radius:12px;}
.layers.cards .layer{border-left-width:4px;padding:18px 16px 20px;}
.layers.cards .layer .nm{color:var(--ink);font-size:19px;} .layers.cards .layer .cnt{font-size:40px;margin-top:10px;} .layers.cards .layer .sub{font-size:18px;color:var(--ink-2);margin-top:10px;}
.layers.cards .arr.gate circle{fill:#15102a;}
.paper.lates{padding:28px 32px;} .late .bar{background:rgba(236,231,248,.1);}
.cal{gap:8px;} .cal a{border-radius:10px;padding:12px 0 12px;} .cal a .s{width:30px;height:30px;border-radius:7px;}
.crow{margin-top:10px;} .crow .cols{border-top:1px solid rgba(236,231,248,.14);}
.tab.on{background:#241a44;border-color:rgba(236,231,248,.3);}
/* the drawing on paper */
.lin2 .lane{fill:rgba(236,231,248,.03);stroke:none;}
.lin2 .node rect{fill:#241a44;stroke:rgba(236,231,248,.24);rx:7;} .lin2 .node{filter:drop-shadow(0 1px 0 rgba(0,0,0,.45));}
.lin2 .node rect.bar{stroke:none;rx:0;}
.lin2 .node.stale rect{stroke:var(--red);stroke-dasharray:5 4;} .lin2 .node.stale rect.bar{fill:var(--red) !important;}
.lin2 .node.dead rect{stroke:rgba(255,138,115,.7);stroke-dasharray:5 4;} .lin2 .node.dead rect.bar{fill:rgba(255,138,115,.7) !important;} .lin2 .node.dead text{fill:var(--ink-2);}
.lin2 .node.hub rect{stroke:var(--purple-soft);stroke-width:2;}
.lin2 .node.on rect{stroke:var(--purple-soft);stroke-width:2;fill:rgba(138,99,242,.35);} .lin2 .node.up rect{stroke:var(--purple);stroke-width:2;fill:#2d2060;} .lin2 .node.down rect{stroke:var(--orange);stroke-width:2;fill:#3a2a2a;}
.lin2 .node.off{opacity:.18;}
.lin2 .wire path{stroke:rgba(201,184,255,.34);stroke-width:1.3;} .lin2 .wire.dim path{stroke:rgba(201,184,255,.2);stroke-dasharray:4 5;}
.lin2 .wire.up path{stroke:var(--purple);stroke-width:2.2;} .lin2 .wire.down path{stroke:var(--orange);stroke-width:2.2;} .lin2 .wire.off{opacity:.06;}
.lin2 .hd{font-size:19px;} .lin2 .hd2{font-size:17px;} .lin2 .grp{font-size:17px;fill:var(--ink-2);letter-spacing:.01em;}
.lin2 .wire.bus{opacity:0;} .lin2 .wire.bus.up,.lin2 .wire.bus.down,.lin2 .wire.bus.dim{opacity:1;} .lin2 .wire.bus.dim path{opacity:1;}
.lin2 .wire.dim path{stroke:rgba(201,184,255,.26);stroke-dasharray:3 5;} .lin2 .wire.same path{stroke-opacity:.5;}
.lin2 .node.layer-bronze rect.bar{fill:rgba(201,184,255,.6) !important;} .lin2 .node.layer-silver_clean rect.bar{fill:#c9b8ff !important;} .lin2 .node.layer-silver_core rect.bar{fill:#8a63f2 !important;}
.lin2 .node.layer-gold rect.bar{fill:#ffd23f !important;} .lin2 .node.layer-_ops rect.bar{fill:rgba(236,231,248,.35) !important;}
.lin2 .node text.sub2{fill:var(--ink-2);}
.lin2 .node.slow rect{fill:var(--purple);stroke:none;} .lin2 .node.slow rect.bar{fill:var(--purple) !important;} .lin2 .node.slow text.sub2{fill:rgba(236,231,248,.85);}
.lin2 .node.paused rect{stroke-dasharray:5 4;} .lin2 .node.paused text{fill:var(--ink-2);}
.lin2 .gate circle{fill:#19122f;stroke:var(--purple-soft);stroke-width:2;} .lin2 .gate path{stroke:rgba(236,231,248,.3);stroke-width:1.5;fill:none;} .lin2 .gate text{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
/* the architecture drawing */
.arch3 svg{display:block;} .arch3 text{font-family:'Bricolage Grotesque',sans-serif;}
.arch3 .hd{font-size:19px;font-weight:600;fill:var(--ink);} .arch3 tspan.mono{font-family:'JetBrains Mono',monospace;font-weight:500;}
.arch3 .nm{font-family:'JetBrains Mono',monospace;font-size:18px;fill:var(--ink);} .arch3 .sm{font-size:17px;fill:var(--ink-2);}
.arch3 .bx{fill:#241a44;stroke:rgba(236,231,248,.24);stroke-width:1;filter:drop-shadow(0 1px 0 rgba(0,0,0,.45));} .arch3 .bx.paused{stroke-dasharray:5 4;} .arch3 .bar{stroke:none;}
.arch3 .ar{stroke:rgba(236,231,248,.4);stroke-width:1.5;fill:none;} .arch3 .ah{fill:rgba(236,231,248,.5);} .arch3 .dot{fill:var(--purple-soft);}
.arch3 .gt{fill:#19122f;stroke:var(--purple-soft);stroke-width:2;} .arch3 .gtn{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
.arch3 .step{fill:#241a44;stroke:rgba(236,231,248,.24);} .arch3 .step.slow{fill:var(--purple);stroke:none;}
.arch3 .nm2{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);font-weight:600;} .arch3 .sm2{font-size:17px;fill:var(--ink-2);}
.arch3 tspan.big{font-size:30px;font-weight:700;fill:var(--ink);} .arch3 tspan.sm{font-size:17px;fill:var(--ink-2);}
/* the entity cards */
.er2 svg{display:block;} .er2 svg text{font-family:'JetBrains Mono',monospace;font-size:17px;fill:var(--ink);}
.er2 .ent rect{fill:#241a44;stroke:rgba(236,231,248,.24);stroke-width:1;rx:10;} .er2 .ent{filter:drop-shadow(0 1px 0 rgba(0,0,0,.45));} .er2 .ent rect.bar{stroke:none;rx:0;}
.er2 .ent .nm{font-family:'Bricolage Grotesque',sans-serif;font-size:21px;font-weight:600;fill:var(--ink);} .er2 .ent .grain{font-family:'Bricolage Grotesque',sans-serif;font-size:17px;fill:var(--ink-2);}
.er2 .ent .key{fill:var(--purple-soft);}  .er2 .ent .more{font-family:'Bricolage Grotesque',sans-serif;font-size:17px;fill:var(--ink-2);}
.er2 .ent.fact rect{stroke:rgba(255,210,63,.7);} .er2 .ent.hub rect{stroke:var(--purple-soft);stroke-width:2;}
.er2 .sep{stroke:rgba(236,231,248,.14);stroke-width:1;} .er2 .colname{fill:var(--ink);} .er2 .colname.key{fill:var(--purple-soft);}
.er2 .rel{fill:none;stroke:rgba(201,184,255,.42);stroke-width:1.5;}
.er2 .lab{font-size:18px;fill:var(--ink);paint-order:stroke;stroke:#19122f;stroke-width:8px;stroke-linejoin:round;}

/* the ground, from the insight series: a radial purple ground, a faint grid, plates with a purple edge */
:root{--ground:#080513;--plate:linear-gradient(160deg,#1b1436 0%,#110c24 100%);--plate-border:rgba(138,99,242,.28);--red:#ff8a73;}
html{background:var(--ground);}
body{background:var(--ground);}
body{position:relative;min-height:100%;}
body::before{content:'';position:absolute;left:0;right:0;top:0;height:min(1600px,100%);z-index:0;pointer-events:none;
  background:radial-gradient(1500px 900px at 50% 420px,#161033 0%,#0e0a1d 55%,rgba(8,5,19,0) 100%);}
body::after{content:'';position:fixed;inset:0;z-index:0;pointer-events:none;
  background-image:linear-gradient(rgba(173,150,255,.05) 1.2px,transparent 1.2px),linear-gradient(90deg,rgba(173,150,255,.05) 1.2px,transparent 1.2px);
  background-size:46px 46px;}
main,nav{position:relative;z-index:1;}
nav{position:sticky;z-index:10;}
.lin2 .node rect,.er2 .ent rect{stroke:rgba(173,150,255,.26);}

.t td.why{white-space:normal;color:var(--ink-2);}
.vd{font-weight:700;white-space:nowrap;}
.vd.ok{color:#7ee0a8;} .vd.care{color:var(--orange);} .vd.no{color:var(--red);}
.stepsbox{margin-top:28px;}
.chg-steps{display:block;margin:0;padding-left:30px;font-size:21px;line-height:1.55;max-width:1180px;list-style:decimal;}
.chg-steps li{display:list-item;margin:0 0 14px;padding-left:6px;} .chg-steps li::marker{color:var(--purple-soft);font-weight:700;}
.chg-note{margin-top:22px;font-size:19px;color:var(--ink-2);max-width:1180px;}
</style>
</head>
<body>
<main>
  <h1>Impact of a change to orders</h1>
  <p class="lead">The core table orders in silver_core: what it is built from, the 7 gold tables that read it, the roles that query them, the checks that cover it, and the safe order of the change.</p>
<div class="kpis"><div class="kpi"><div class="l">built from</div><div class="v">6</div><div class="sub">tables and the feed</div></div><div class="kpi"><div class="l">read by</div><div class="v">7</div><div class="sub">gold tables</div></div><div class="kpi"><div class="l">data products</div><div class="v">4</div><div class="sub">Trading and 3 more</div></div><div class="kpi"><div class="l">roles</div><div class="v">6</div><div class="sub">in the query logs</div></div><div class="kpi"><div class="l">queries</div><div class="v">1,412</div><div class="sub">in 2026-08</div></div><div class="kpi"><div class="l">checks</div><div class="v orange">6</div><div class="sub">4 would break</div></div></div>
  <section class="s">
    <h2>Upstream and downstream</h2>
    <p class="one">orders is lit: everything it is built from on the left, everything that reads it on the right. Click any other table to see its own.</p>
    <div class="vis wide paper"><div class="lin lin2"><svg viewBox="0 0 1544 1868" width="1544" height="1868"><rect class="lane" x="-12.0" y="2" width="374.0" height="1866" rx="12"/><rect class="lane" x="442.7" y="2" width="324.0" height="1802" rx="12"/><rect class="lane" x="847.3" y="2" width="274.0" height="1514" rx="12"/><rect class="lane" x="1202.0" y="2" width="354.0" height="1322" rx="12"/><g class="wire " data-a="b:listing_versions" data-b="c:listing_versions"><path d="M350.0 528.0 C402.3 528.0 402.3 528.0 454.7 528.0"/></g><g class="wire " data-a="b:prices" data-b="c:prices"><path d="M350.0 656.0 C402.3 656.0 402.3 656.0 454.7 656.0"/></g><g class="wire " data-a="b:products" data-b="c:products"><path d="M350.0 560.0 C402.3 560.0 402.3 560.0 454.7 560.0"/></g><g class="wire " data-a="b:sku_offers" data-b="c:sku_offers"><path d="M350.0 592.0 C402.3 592.0 402.3 592.0 454.7 592.0"/></g><g class="wire " data-a="b:codes" data-b="c:codes"><path d="M350.0 272.0 C402.3 272.0 402.3 272.0 454.7 272.0"/></g><g class="wire " data-a="b:customers" data-b="c:customers"><path d="M350.0 112.0 C402.3 112.0 402.3 112.0 454.7 112.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:customers"><path d="M350.0 1840.0 H444.7 V112.0 H454.7"/></g><g class="wire " data-a="b:discount_components" data-b="c:discount_components"><path d="M350.0 400.0 C402.3 400.0 402.3 400.0 454.7 400.0"/></g><g class="wire " data-a="b:order_lines" data-b="c:order_lines"><path d="M350.0 432.0 C402.3 432.0 402.3 432.0 454.7 432.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:order_lines"><path d="M350.0 1840.0 H444.7 V432.0 H454.7"/></g><g class="wire " data-a="b:order_status_history" data-b="c:order_status_history"><path d="M350.0 304.0 C402.3 304.0 402.3 304.0 454.7 304.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:order_status_history"><path d="M350.0 1840.0 H444.7 V304.0 H454.7"/></g><g class="wire " data-a="b:orders" data-b="c:orders"><path d="M350.0 336.0 C402.3 336.0 402.3 336.0 454.7 336.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:orders"><path d="M350.0 1840.0 H444.7 V336.0 H454.7"/></g><g class="wire " data-a="b:return_cases" data-b="c:return_cases"><path d="M350.0 848.0 C402.3 848.0 402.3 848.0 454.7 848.0"/></g><g class="wire " data-a="b:returns" data-b="c:returns"><path d="M350.0 464.0 C402.3 464.0 402.3 464.0 454.7 464.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:returns"><path d="M350.0 1840.0 H444.7 V464.0 H454.7"/></g><g class="wire " data-a="b:account_members" data-b="c:account_members"><path d="M350.0 144.0 C402.3 144.0 402.3 144.0 454.7 144.0"/></g><g class="wire " data-a="b:business_accounts" data-b="c:business_accounts"><path d="M350.0 176.0 C402.3 176.0 402.3 176.0 454.7 176.0"/></g><g class="wire " data-a="b:contacts" data-b="c:contacts"><path d="M350.0 208.0 C402.3 208.0 402.3 208.0 454.7 208.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:contacts"><path d="M350.0 1840.0 H444.7 V208.0 H454.7"/></g><g class="wire " data-a="b:voucher_offers" data-b="c:voucher_offers"><path d="M350.0 1168.0 C402.3 1168.0 402.3 1168.0 454.7 1168.0"/></g><g class="wire " data-a="b:marketing_spend" data-b="c:marketing_spend"><path d="M350.0 1200.0 C402.3 1200.0 402.3 1200.0 454.7 1200.0"/></g><g class="wire " data-a="b:marketplace_fee_postings" data-b="c:marketplace_fee_postings"><path d="M350.0 1584.0 C402.3 1584.0 402.3 1584.0 454.7 1584.0"/></g><g class="wire " data-a="b:marketplace_fee_rates" data-b="c:marketplace_fee_rates"><path d="M350.0 1616.0 C402.3 1616.0 402.3 1616.0 454.7 1616.0"/></g><g class="wire " data-a="b:recovery_ledger" data-b="c:recovery_ledger"><path d="M350.0 880.0 C402.3 880.0 402.3 880.0 454.7 880.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:recovery_ledger"><path d="M350.0 1840.0 H444.7 V880.0 H454.7"/></g><g class="wire " data-a="b:refund_ledger" data-b="c:refund_ledger"><path d="M350.0 912.0 C402.3 912.0 402.3 912.0 454.7 912.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:refund_ledger"><path d="M350.0 1840.0 H444.7 V912.0 H454.7"/></g><g class="wire " data-a="b:sales_targets" data-b="c:sales_targets"><path d="M350.0 1648.0 C402.3 1648.0 402.3 1648.0 454.7 1648.0"/></g><g class="wire " data-a="b:shipping_ledger" data-b="c:shipping_ledger"><path d="M350.0 752.0 C402.3 752.0 402.3 752.0 454.7 752.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:shipping_ledger"><path d="M350.0 1840.0 H444.7 V752.0 H454.7"/></g><g class="wire " data-a="b:standard_costs" data-b="c:standard_costs"><path d="M350.0 688.0 C402.3 688.0 402.3 688.0 454.7 688.0"/></g><g class="wire " data-a="b:stock_exits" data-b="c:stock_exits"><path d="M350.0 1680.0 C402.3 1680.0 402.3 1680.0 454.7 1680.0"/></g><g class="wire " data-a="b:target_versions" data-b="c:target_versions"><path d="M350.0 1712.0 C402.3 1712.0 402.3 1712.0 454.7 1712.0"/></g><g class="wire " data-a="b:campaigns" data-b="c:campaigns"><path d="M350.0 1232.0 C402.3 1232.0 402.3 1232.0 454.7 1232.0"/></g><g class="wire " data-a="b:trading_calendar" data-b="c:trading_calendar"><path d="M350.0 1744.0 C402.3 1744.0 402.3 1744.0 454.7 1744.0"/></g><g class="wire " data-a="b:purchase_orders" data-b="c:purchase_orders"><path d="M350.0 1072.0 C402.3 1072.0 402.3 1072.0 454.7 1072.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:purchase_orders"><path d="M350.0 1840.0 H444.7 V1072.0 H454.7"/></g><g class="wire " data-a="b:receipts" data-b="c:receipts"><path d="M350.0 1104.0 C402.3 1104.0 402.3 1104.0 454.7 1104.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:receipts"><path d="M350.0 1840.0 H444.7 V1104.0 H454.7"/></g><g class="wire " data-a="b:supplier_invoice_lines" data-b="c:supplier_invoice_lines"><path d="M350.0 976.0 C402.3 976.0 402.3 976.0 454.7 976.0"/></g><g class="wire " data-a="b:suppliers" data-b="c:suppliers"><path d="M350.0 1008.0 C402.3 1008.0 402.3 1008.0 454.7 1008.0"/></g><g class="wire " data-a="b:messages" data-b="c:messages"><path d="M350.0 1456.0 C402.3 1456.0 402.3 1456.0 454.7 1456.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:messages"><path d="M350.0 1840.0 H444.7 V1456.0 H454.7"/></g><g class="wire " data-a="b:support_agents" data-b="c:support_agents"><path d="M350.0 1488.0 C402.3 1488.0 402.3 1488.0 454.7 1488.0"/></g><g class="wire " data-a="b:tickets" data-b="c:tickets"><path d="M350.0 1520.0 C402.3 1520.0 402.3 1520.0 454.7 1520.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:tickets"><path d="M350.0 1840.0 H444.7 V1520.0 H454.7"/></g><g class="wire " data-a="b:shipments" data-b="c:shipments"><path d="M350.0 784.0 C402.3 784.0 402.3 784.0 454.7 784.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:shipments"><path d="M350.0 1840.0 H444.7 V784.0 H454.7"/></g><g class="wire " data-a="b:stock" data-b="c:stock"><path d="M350.0 1296.0 C402.3 1296.0 402.3 1296.0 454.7 1296.0"/></g><g class="wire " data-a="b:stock_counts" data-b="c:stock_counts"><path d="M350.0 1328.0 C402.3 1328.0 402.3 1328.0 454.7 1328.0"/></g><g class="wire " data-a="b:stock_daily" data-b="c:stock_daily"><path d="M350.0 1360.0 C402.3 1360.0 402.3 1360.0 454.7 1360.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:stock_daily"><path d="M350.0 1840.0 H444.7 V1360.0 H454.7"/></g><g class="wire " data-a="b:stock_movements" data-b="c:stock_movements"><path d="M350.0 1392.0 C402.3 1392.0 402.3 1392.0 454.7 1392.0"/></g><g class="wire bus dim" data-a="b:feed" data-b="c:stock_movements"><path d="M350.0 1840.0 H444.7 V1392.0 H454.7"/></g><g class="wire " data-a="b:web_events" data-b="c:web_events"><path d="M350.0 1776.0 C402.3 1776.0 402.3 1776.0 454.7 1776.0"/></g><g class="wire " data-a="c:customers" data-b="k:customers"><path d="M754.7 112.0 C807.0 112.0 807.0 160.0 859.3 160.0"/></g><g class="wire " data-a="c:contacts" data-b="k:customers"><path d="M754.7 208.0 C807.0 208.0 807.0 160.0 859.3 160.0"/></g><g class="wire " data-a="c:account_members" data-b="k:customers"><path d="M754.7 144.0 C807.0 144.0 807.0 160.0 859.3 160.0"/></g><g class="wire " data-a="c:business_accounts" data-b="k:customers"><path d="M754.7 176.0 C807.0 176.0 807.0 160.0 859.3 160.0"/></g><g class="wire " data-a="c:orders" data-b="k:orders"><path d="M754.7 336.0 C807.0 336.0 807.0 304.0 859.3 304.0"/></g><g class="wire " data-a="c:order_status_history" data-b="k:orders"><path d="M754.7 304.0 C807.0 304.0 807.0 304.0 859.3 304.0"/></g><g class="wire " data-a="c:codes" data-b="k:orders"><path d="M754.7 272.0 C807.0 272.0 807.0 304.0 859.3 304.0"/></g><g class="wire " data-a="c:order_lines" data-b="k:order_lines"><path d="M754.7 432.0 C807.0 432.0 807.0 432.0 859.3 432.0"/></g><g class="wire " data-a="c:discount_components" data-b="k:order_lines"><path d="M754.7 400.0 C807.0 400.0 807.0 432.0 859.3 432.0"/></g><g class="wire " data-a="c:returns" data-b="k:order_lines"><path d="M754.7 464.0 C807.0 464.0 807.0 432.0 859.3 432.0"/></g><g class="wire " data-a="c:products" data-b="k:products"><path d="M754.7 560.0 C807.0 560.0 807.0 560.0 859.3 560.0"/></g><g class="wire " data-a="c:sku_offers" data-b="k:products"><path d="M754.7 592.0 C807.0 592.0 807.0 560.0 859.3 560.0"/></g><g class="wire " data-a="c:listing_versions" data-b="k:products"><path d="M754.7 528.0 C807.0 528.0 807.0 560.0 859.3 560.0"/></g><g class="wire " data-a="c:prices" data-b="k:product_prices"><path d="M754.7 656.0 C807.0 656.0 807.0 672.0 859.3 672.0"/></g><g class="wire " data-a="c:standard_costs" data-b="k:product_prices"><path d="M754.7 688.0 C807.0 688.0 807.0 672.0 859.3 672.0"/></g><g class="wire " data-a="c:shipments" data-b="k:shipments"><path d="M754.7 784.0 C807.0 784.0 807.0 768.0 859.3 768.0"/></g><g class="wire " data-a="c:shipping_ledger" data-b="k:shipments"><path d="M754.7 752.0 C807.0 752.0 807.0 768.0 859.3 768.0"/></g><g class="wire " data-a="c:returns" data-b="k:returns"><path d="M754.7 464.0 C807.0 464.0 807.0 800.0 859.3 800.0"/></g><g class="wire " data-a="c:return_cases" data-b="k:returns"><path d="M754.7 848.0 C807.0 848.0 807.0 800.0 859.3 800.0"/></g><g class="wire " data-a="c:refund_ledger" data-b="k:returns"><path d="M754.7 912.0 C807.0 912.0 807.0 800.0 859.3 800.0"/></g><g class="wire " data-a="c:recovery_ledger" data-b="k:returns"><path d="M754.7 880.0 C807.0 880.0 807.0 800.0 859.3 800.0"/></g><g class="wire " data-a="c:suppliers" data-b="k:suppliers"><path d="M754.7 1008.0 C807.0 1008.0 807.0 992.0 859.3 992.0"/></g><g class="wire " data-a="c:supplier_invoice_lines" data-b="k:suppliers"><path d="M754.7 976.0 C807.0 976.0 807.0 992.0 859.3 992.0"/></g><g class="wire " data-a="c:purchase_orders" data-b="k:purchase_orders"><path d="M754.7 1072.0 C807.0 1072.0 807.0 1088.0 859.3 1088.0"/></g><g class="wire " data-a="c:receipts" data-b="k:purchase_orders"><path d="M754.7 1104.0 C807.0 1104.0 807.0 1088.0 859.3 1088.0"/></g><g class="wire " data-a="c:campaigns" data-b="k:campaigns"><path d="M754.7 1232.0 C807.0 1232.0 807.0 1200.0 859.3 1200.0"/></g><g class="wire " data-a="c:marketing_spend" data-b="k:campaigns"><path d="M754.7 1200.0 C807.0 1200.0 807.0 1200.0 859.3 1200.0"/></g><g class="wire " data-a="c:voucher_offers" data-b="k:campaigns"><path d="M754.7 1168.0 C807.0 1168.0 807.0 1200.0 859.3 1200.0"/></g><g class="wire " data-a="c:stock_daily" data-b="k:stock"><path d="M754.7 1360.0 C807.0 1360.0 807.0 1344.0 859.3 1344.0"/></g><g class="wire " data-a="c:stock_movements" data-b="k:stock"><path d="M754.7 1392.0 C807.0 1392.0 807.0 1344.0 859.3 1344.0"/></g><g class="wire " data-a="c:stock_counts" data-b="k:stock"><path d="M754.7 1328.0 C807.0 1328.0 807.0 1344.0 859.3 1344.0"/></g><g class="wire " data-a="c:stock" data-b="k:stock"><path d="M754.7 1296.0 C807.0 1296.0 807.0 1344.0 859.3 1344.0"/></g><g class="wire " data-a="c:tickets" data-b="k:tickets"><path d="M754.7 1520.0 C807.0 1520.0 807.0 1488.0 859.3 1488.0"/></g><g class="wire " data-a="c:messages" data-b="k:tickets"><path d="M754.7 1456.0 C807.0 1456.0 807.0 1488.0 859.3 1488.0"/></g><g class="wire " data-a="c:support_agents" data-b="k:tickets"><path d="M754.7 1488.0 C807.0 1488.0 807.0 1488.0 859.3 1488.0"/></g><g class="wire " data-a="k:order_lines" data-b="g:fact_order_lines"><path d="M1109.3 432.0 C1161.7 432.0 1161.7 469.3 1214.0 469.3"/></g><g class="wire " data-a="k:orders" data-b="g:fact_order_lines"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 469.3 1214.0 469.3"/></g><g class="wire " data-a="k:product_prices" data-b="g:fact_order_lines"><path d="M1109.3 672.0 C1161.7 672.0 1161.7 469.3 1214.0 469.3"/></g><g class="wire " data-a="k:orders" data-b="g:fact_orders"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 232.0 1214.0 232.0"/></g><g class="wire " data-a="k:customers" data-b="g:fact_orders"><path d="M1109.3 160.0 C1161.7 160.0 1161.7 232.0 1214.0 232.0"/></g><g class="wire " data-a="k:shipments" data-b="g:fact_shipments"><path d="M1109.3 768.0 C1161.7 768.0 1161.7 536.0 1214.0 536.0"/></g><g class="wire " data-a="k:orders" data-b="g:fact_shipments"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 536.0 1214.0 536.0"/></g><g class="wire " data-a="k:returns" data-b="g:fact_returns"><path d="M1109.3 800.0 C1161.7 800.0 1161.7 616.0 1214.0 616.0"/></g><g class="wire " data-a="k:order_lines" data-b="g:fact_returns"><path d="M1109.3 432.0 C1161.7 432.0 1161.7 616.0 1214.0 616.0"/></g><g class="wire " data-a="k:stock" data-b="g:fact_stock_daily"><path d="M1109.3 1344.0 C1161.7 1344.0 1161.7 952.0 1214.0 952.0"/></g><g class="wire " data-a="k:products" data-b="g:fact_stock_daily"><path d="M1109.3 560.0 C1161.7 560.0 1161.7 952.0 1214.0 952.0"/></g><g class="wire " data-a="k:purchase_orders" data-b="g:fact_purchases"><path d="M1109.3 1088.0 C1161.7 1088.0 1161.7 1056.0 1214.0 1056.0"/></g><g class="wire " data-a="k:suppliers" data-b="g:fact_purchases"><path d="M1109.3 992.0 C1161.7 992.0 1161.7 1056.0 1214.0 1056.0"/></g><g class="wire " data-a="k:customers" data-b="g:dim_customers"><path d="M1109.3 160.0 C1161.7 160.0 1161.7 160.0 1214.0 160.0"/></g><g class="wire " data-a="k:products" data-b="g:dim_products"><path d="M1109.3 560.0 C1161.7 560.0 1161.7 648.0 1214.0 648.0"/></g><g class="wire " data-a="k:product_prices" data-b="g:dim_products"><path d="M1109.3 672.0 C1161.7 672.0 1161.7 648.0 1214.0 648.0"/></g><g class="wire " data-a="k:suppliers" data-b="g:dim_suppliers"><path d="M1109.3 992.0 C1161.7 992.0 1161.7 992.0 1214.0 992.0"/></g><g class="wire " data-a="k:campaigns" data-b="g:dim_campaigns"><path d="M1109.3 1200.0 C1161.7 1200.0 1161.7 1200.0 1214.0 1200.0"/></g><g class="wire " data-a="k:shipments" data-b="g:dim_carriers"><path d="M1109.3 768.0 C1161.7 768.0 1161.7 768.0 1214.0 768.0"/></g><g class="wire " data-a="k:returns" data-b="g:dim_return_reasons"><path d="M1109.3 800.0 C1161.7 800.0 1161.7 832.0 1214.0 832.0"/></g><g class="wire " data-a="k:orders" data-b="g:dim_promotions_old"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 304.0 1214.0 304.0"/></g><g class="wire " data-a="k:order_lines" data-b="g:obt_order_lines"><path d="M1109.3 432.0 C1161.7 432.0 1161.7 432.0 1214.0 432.0"/></g><g class="wire " data-a="k:orders" data-b="g:obt_order_lines"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 432.0 1214.0 432.0"/></g><g class="wire " data-a="k:customers" data-b="g:obt_order_lines"><path d="M1109.3 160.0 C1161.7 160.0 1161.7 432.0 1214.0 432.0"/></g><g class="wire " data-a="k:products" data-b="g:obt_order_lines"><path d="M1109.3 560.0 C1161.7 560.0 1161.7 432.0 1214.0 432.0"/></g><g class="wire " data-a="k:product_prices" data-b="g:obt_order_lines"><path d="M1109.3 672.0 C1161.7 672.0 1161.7 432.0 1214.0 432.0"/></g><g class="wire " data-a="k:orders" data-b="g:rpt_daily_sales_wide"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 368.0 1214.0 368.0"/></g><g class="wire " data-a="k:order_lines" data-b="g:rpt_daily_sales_wide"><path d="M1109.3 432.0 C1161.7 432.0 1161.7 368.0 1214.0 368.0"/></g><g class="wire " data-a="k:order_lines" data-b="g:rpt_margin_by_family"><path d="M1109.3 432.0 C1161.7 432.0 1161.7 568.0 1214.0 568.0"/></g><g class="wire " data-a="k:products" data-b="g:rpt_margin_by_family"><path d="M1109.3 560.0 C1161.7 560.0 1161.7 568.0 1214.0 568.0"/></g><g class="wire " data-a="k:product_prices" data-b="g:rpt_margin_by_family"><path d="M1109.3 672.0 C1161.7 672.0 1161.7 568.0 1214.0 568.0"/></g><g class="wire " data-a="k:shipments" data-b="g:rpt_delivery_sla"><path d="M1109.3 768.0 C1161.7 768.0 1161.7 800.0 1214.0 800.0"/></g><g class="wire " data-a="k:returns" data-b="g:rpt_returns_by_reason"><path d="M1109.3 800.0 C1161.7 800.0 1161.7 864.0 1214.0 864.0"/></g><g class="wire " data-a="k:purchase_orders" data-b="g:rpt_supplier_fill_rate"><path d="M1109.3 1088.0 C1161.7 1088.0 1161.7 1088.0 1214.0 1088.0"/></g><g class="wire " data-a="k:suppliers" data-b="g:rpt_supplier_fill_rate"><path d="M1109.3 992.0 C1161.7 992.0 1161.7 1088.0 1214.0 1088.0"/></g><g class="wire " data-a="k:order_lines" data-b="g:metric_trading"><path d="M1109.3 432.0 C1161.7 432.0 1161.7 400.0 1214.0 400.0"/></g><g class="wire " data-a="k:orders" data-b="g:metric_trading"><path d="M1109.3 304.0 C1161.7 304.0 1161.7 400.0 1214.0 400.0"/></g><g class="wire " data-a="k:shipments" data-b="g:metric_service"><path d="M1109.3 768.0 C1161.7 768.0 1161.7 1024.0 1214.0 1024.0"/></g><g class="wire " data-a="k:tickets" data-b="g:metric_service"><path d="M1109.3 1488.0 C1161.7 1488.0 1161.7 1024.0 1214.0 1024.0"/></g><g class="wire " data-a="k:returns" data-b="g:metric_service"><path d="M1109.3 800.0 C1161.7 800.0 1161.7 1024.0 1214.0 1024.0"/></g><text class="hd" x="0.0" y="22">bronze</text><text class="hd2" x="0.0" y="46">42 tables</text><text class="grp" x="0.0" y="84.0">commerce, crm · customers</text><g class="node " data-k="b:customers"><rect x="0.0" y="99.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="99.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="117.0">commerce_customers</text></g><g class="node " data-k="b:account_members"><rect x="0.0" y="131.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="131.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="149.0">crm_account_members</text></g><g class="node " data-k="b:business_accounts"><rect x="0.0" y="163.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="163.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="181.0">crm_business_accounts</text></g><g class="node " data-k="b:contacts"><rect x="0.0" y="195.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="195.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="213.0">crm_contacts</text></g><text class="grp" x="0.0" y="244.0">commerce · orders</text><g class="node " data-k="b:codes"><rect x="0.0" y="259.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="259.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="277.0">commerce_codes</text></g><g class="node " data-k="b:order_status_history"><rect x="0.0" y="291.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="291.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="309.0">commerce_order_status_history</text></g><g class="node " data-k="b:orders"><rect x="0.0" y="323.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="323.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="341.0">commerce_orders</text></g><text class="grp" x="0.0" y="372.0">commerce · order_lines</text><g class="node " data-k="b:discount_components"><rect x="0.0" y="387.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="387.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="405.0">commerce_discount_components</text></g><g class="node " data-k="b:order_lines"><rect x="0.0" y="419.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="419.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="437.0">commerce_order_lines</text></g><g class="node " data-k="b:returns"><rect x="0.0" y="451.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="451.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="469.0">commerce_returns</text></g><text class="grp" x="0.0" y="500.0">catalog · products</text><g class="node " data-k="b:listing_versions"><rect x="0.0" y="515.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="515.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="533.0">catalog_listing_versions</text></g><g class="node " data-k="b:products"><rect x="0.0" y="547.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="547.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="565.0">catalog_products</text></g><g class="node " data-k="b:sku_offers"><rect x="0.0" y="579.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="579.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="597.0">catalog_sku_offers</text></g><text class="grp" x="0.0" y="628.0">catalog, finance · product_prices</text><g class="node " data-k="b:prices"><rect x="0.0" y="643.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="643.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="661.0">catalog_prices</text></g><g class="node " data-k="b:standard_costs"><rect x="0.0" y="675.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="675.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="693.0">finance_standard_costs</text></g><text class="grp" x="0.0" y="724.0">finance, warehouse · shipments</text><g class="node " data-k="b:shipping_ledger"><rect x="0.0" y="739.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="739.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="757.0">finance_shipping_ledger</text></g><g class="node " data-k="b:shipments"><rect x="0.0" y="771.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="771.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="789.0">warehouse_shipments</text></g><text class="grp" x="0.0" y="820.0">commerce, finance · returns</text><g class="node " data-k="b:return_cases"><rect x="0.0" y="835.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="835.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="853.0">commerce_return_cases</text></g><g class="node " data-k="b:recovery_ledger"><rect x="0.0" y="867.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="867.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="885.0">finance_recovery_ledger</text></g><g class="node " data-k="b:refund_ledger"><rect x="0.0" y="899.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="899.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="917.0">finance_refund_ledger</text></g><text class="grp" x="0.0" y="948.0">purchasing · suppliers</text><g class="node " data-k="b:supplier_invoice_lines"><rect x="0.0" y="963.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="963.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="981.0">purchasing_supplier_invoice_lines</text></g><g class="node " data-k="b:suppliers"><rect x="0.0" y="995.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="995.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1013.0">purchasing_suppliers</text></g><text class="grp" x="0.0" y="1044.0">purchasing · purchase_orders</text><g class="node " data-k="b:purchase_orders"><rect x="0.0" y="1059.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1059.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1077.0">purchasing_purchase_orders</text></g><g class="node " data-k="b:receipts"><rect x="0.0" y="1091.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1091.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1109.0">purchasing_receipts</text></g><text class="grp" x="0.0" y="1140.0" textLength="348" lengthAdjust="spacing">crm, finance, marketing · campaigns</text><g class="node " data-k="b:voucher_offers"><rect x="0.0" y="1155.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1155.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1173.0">crm_voucher_offers</text></g><g class="node " data-k="b:marketing_spend"><rect x="0.0" y="1187.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1187.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1205.0">finance_marketing_spend</text></g><g class="node " data-k="b:campaigns"><rect x="0.0" y="1219.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1219.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1237.0">marketing_campaigns</text></g><text class="grp" x="0.0" y="1268.0">warehouse · stock</text><g class="node " data-k="b:stock"><rect x="0.0" y="1283.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1283.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1301.0">warehouse_stock</text></g><g class="node " data-k="b:stock_counts"><rect x="0.0" y="1315.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1315.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1333.0">warehouse_stock_counts</text></g><g class="node " data-k="b:stock_daily"><rect x="0.0" y="1347.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1347.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1365.0">warehouse_stock_daily</text></g><g class="node " data-k="b:stock_movements"><rect x="0.0" y="1379.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1379.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1397.0">warehouse_stock_movements</text></g><text class="grp" x="0.0" y="1428.0">support · tickets</text><g class="node " data-k="b:messages"><rect x="0.0" y="1443.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1443.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1461.0">support_messages</text></g><g class="node " data-k="b:support_agents"><rect x="0.0" y="1475.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1475.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1493.0">support_agents</text></g><g class="node " data-k="b:tickets"><rect x="0.0" y="1507.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1507.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1525.0">support_tickets</text></g><text class="grp" x="0.0" y="1556.0" textLength="348" lengthAdjust="spacing">finance, marketing, web · no core table</text><g class="node " data-k="b:marketplace_fee_postings"><rect x="0.0" y="1571.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1571.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1589.0">finance_marketplace_fee_postings</text></g><g class="node " data-k="b:marketplace_fee_rates"><rect x="0.0" y="1603.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1603.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1621.0">finance_marketplace_fee_rates</text></g><g class="node " data-k="b:sales_targets"><rect x="0.0" y="1635.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1635.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1653.0">finance_sales_targets</text></g><g class="node " data-k="b:stock_exits"><rect x="0.0" y="1667.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1667.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1685.0">finance_stock_exits</text></g><g class="node " data-k="b:target_versions"><rect x="0.0" y="1699.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1699.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1717.0">finance_target_versions</text></g><g class="node " data-k="b:trading_calendar"><rect x="0.0" y="1731.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1731.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1749.0">marketing_trading_calendar</text></g><g class="node " data-k="b:web_events"><rect x="0.0" y="1763.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1763.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1781.0">web_events</text></g><text class="grp" x="0.0" y="1812.0">the daily feed</text><g class="node " data-k="b:feed"><rect x="0.0" y="1827.0" width="350.0" height="26"/><rect class="bar" x="0.0" y="1827.0" width="4" height="26" style="fill:rgba(201,184,255,.6)"/><text x="14.0" y="1845.0">deliveries_changes</text></g><text class="hd" x="454.7" y="22">silver_clean</text><text class="hd2" x="454.7" y="46">41 tables</text><text class="grp" x="454.7" y="84.0">feeds customers</text><g class="node " data-k="c:customers"><rect x="454.7" y="99.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="99.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="117.0">customers</text></g><g class="node " data-k="c:account_members"><rect x="454.7" y="131.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="131.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="149.0">account_members</text></g><g class="node " data-k="c:business_accounts"><rect x="454.7" y="163.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="163.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="181.0">business_accounts</text></g><g class="node " data-k="c:contacts"><rect x="454.7" y="195.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="195.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="213.0">contacts</text></g><text class="grp" x="454.7" y="244.0">feeds orders</text><g class="node " data-k="c:codes"><rect x="454.7" y="259.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="259.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="277.0">codes</text></g><g class="node " data-k="c:order_status_history"><rect x="454.7" y="291.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="291.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="309.0">order_status_history</text></g><g class="node " data-k="c:orders"><rect x="454.7" y="323.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="323.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="341.0">orders</text></g><text class="grp" x="454.7" y="372.0">feeds order_lines</text><g class="node " data-k="c:discount_components"><rect x="454.7" y="387.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="387.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="405.0">discount_components</text></g><g class="node " data-k="c:order_lines"><rect x="454.7" y="419.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="419.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="437.0">order_lines</text></g><g class="node " data-k="c:returns"><rect x="454.7" y="451.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="451.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="469.0">returns</text></g><text class="grp" x="454.7" y="500.0">feeds products</text><g class="node " data-k="c:listing_versions"><rect x="454.7" y="515.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="515.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="533.0">listing_versions</text></g><g class="node " data-k="c:products"><rect x="454.7" y="547.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="547.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="565.0">products</text></g><g class="node " data-k="c:sku_offers"><rect x="454.7" y="579.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="579.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="597.0">sku_offers</text></g><text class="grp" x="454.7" y="628.0">feeds product_prices</text><g class="node " data-k="c:prices"><rect x="454.7" y="643.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="643.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="661.0">prices</text></g><g class="node " data-k="c:standard_costs"><rect x="454.7" y="675.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="675.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="693.0">standard_costs</text></g><text class="grp" x="454.7" y="724.0">feeds shipments</text><g class="node " data-k="c:shipping_ledger"><rect x="454.7" y="739.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="739.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="757.0">shipping_ledger</text></g><g class="node " data-k="c:shipments"><rect x="454.7" y="771.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="771.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="789.0">shipments</text></g><text class="grp" x="454.7" y="820.0">feeds returns</text><g class="node " data-k="c:return_cases"><rect x="454.7" y="835.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="835.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="853.0">return_cases</text></g><g class="node " data-k="c:recovery_ledger"><rect x="454.7" y="867.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="867.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="885.0">recovery_ledger</text></g><g class="node " data-k="c:refund_ledger"><rect x="454.7" y="899.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="899.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="917.0">refund_ledger</text></g><text class="grp" x="454.7" y="948.0">feeds suppliers</text><g class="node " data-k="c:supplier_invoice_lines"><rect x="454.7" y="963.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="963.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="981.0">supplier_invoice_lines</text></g><g class="node " data-k="c:suppliers"><rect x="454.7" y="995.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="995.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1013.0">suppliers</text></g><text class="grp" x="454.7" y="1044.0">feeds purchase_orders</text><g class="node " data-k="c:purchase_orders"><rect x="454.7" y="1059.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1059.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1077.0">purchase_orders</text></g><g class="node " data-k="c:receipts"><rect x="454.7" y="1091.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1091.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1109.0">receipts</text></g><text class="grp" x="454.7" y="1140.0">feeds campaigns</text><g class="node " data-k="c:voucher_offers"><rect x="454.7" y="1155.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1155.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1173.0">voucher_offers</text></g><g class="node " data-k="c:marketing_spend"><rect x="454.7" y="1187.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1187.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1205.0">marketing_spend</text></g><g class="node " data-k="c:campaigns"><rect x="454.7" y="1219.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1219.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1237.0">campaigns</text></g><text class="grp" x="454.7" y="1268.0">feeds stock</text><g class="node " data-k="c:stock"><rect x="454.7" y="1283.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1283.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1301.0">stock</text></g><g class="node " data-k="c:stock_counts"><rect x="454.7" y="1315.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1315.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1333.0">stock_counts</text></g><g class="node " data-k="c:stock_daily"><rect x="454.7" y="1347.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1347.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1365.0">stock_daily</text></g><g class="node " data-k="c:stock_movements"><rect x="454.7" y="1379.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1379.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1397.0">stock_movements</text></g><text class="grp" x="454.7" y="1428.0">feeds tickets</text><g class="node " data-k="c:messages"><rect x="454.7" y="1443.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1443.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1461.0">messages</text></g><g class="node " data-k="c:support_agents"><rect x="454.7" y="1475.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1475.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1493.0">support_agents</text></g><g class="node " data-k="c:tickets"><rect x="454.7" y="1507.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1507.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1525.0">tickets</text></g><text class="grp" x="454.7" y="1556.0">no core table</text><g class="node " data-k="c:marketplace_fee_postings"><rect x="454.7" y="1571.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1571.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1589.0">marketplace_fee_postings</text></g><g class="node " data-k="c:marketplace_fee_rates"><rect x="454.7" y="1603.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1603.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1621.0">marketplace_fee_rates</text></g><g class="node " data-k="c:sales_targets"><rect x="454.7" y="1635.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1635.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1653.0">sales_targets</text></g><g class="node " data-k="c:stock_exits"><rect x="454.7" y="1667.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1667.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1685.0">stock_exits</text></g><g class="node " data-k="c:target_versions"><rect x="454.7" y="1699.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1699.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1717.0">target_versions</text></g><g class="node " data-k="c:trading_calendar"><rect x="454.7" y="1731.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1731.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1749.0">trading_calendar</text></g><g class="node " data-k="c:web_events"><rect x="454.7" y="1763.0" width="300.0" height="26"/><rect class="bar" x="454.7" y="1763.0" width="4" height="26" style="fill:#c9b8ff"/><text x="468.7" y="1781.0">web_events</text></g><text class="hd" x="859.3" y="22">silver_core</text><text class="hd2" x="859.3" y="46">12 tables</text><g class="node " data-k="k:customers"><rect x="859.3" y="147.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="147.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="165.0">customers</text></g><g class="node hub" data-k="k:orders"><rect x="859.3" y="291.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="291.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="309.0">orders</text></g><g class="node hub" data-k="k:order_lines"><rect x="859.3" y="419.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="419.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="437.0">order_lines</text></g><g class="node " data-k="k:products"><rect x="859.3" y="547.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="547.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="565.0">products</text></g><g class="node " data-k="k:product_prices"><rect x="859.3" y="659.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="659.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="677.0">product_prices</text></g><g class="node " data-k="k:shipments"><rect x="859.3" y="755.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="755.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="773.0">shipments</text></g><g class="node " data-k="k:returns"><rect x="859.3" y="787.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="787.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="805.0">returns</text></g><g class="node " data-k="k:suppliers"><rect x="859.3" y="979.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="979.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="997.0">suppliers</text></g><g class="node " data-k="k:purchase_orders"><rect x="859.3" y="1075.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="1075.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="1093.0">purchase_orders</text></g><g class="node " data-k="k:campaigns"><rect x="859.3" y="1187.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="1187.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="1205.0">campaigns</text></g><g class="node " data-k="k:stock"><rect x="859.3" y="1331.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="1331.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="1349.0">stock</text></g><g class="node " data-k="k:tickets"><rect x="859.3" y="1475.0" width="250.0" height="26"/><rect class="bar" x="859.3" y="1475.0" width="4" height="26" style="fill:#8a63f2"/><text x="873.3" y="1493.0">tickets</text></g><text class="hd" x="1214.0" y="22">gold</text><text class="hd2" x="1214.0" y="46">24 tables</text><g class="node " data-k="g:dim_customers"><rect x="1214.0" y="147.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="147.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="165.0">dim_customers</text></g><g class="node " data-k="g:fact_orders"><rect x="1214.0" y="219.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="219.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="237.0">fact_orders</text></g><g class="node stale" data-k="g:dim_promotions_old"><rect x="1214.0" y="291.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="291.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="309.0">dim_promotions_old</text></g><g class="node stale" data-k="g:rpt_daily_sales_wide"><rect x="1214.0" y="355.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="355.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="373.0">rpt_daily_sales_wide</text></g><g class="node " data-k="g:metric_trading"><rect x="1214.0" y="387.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="387.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="405.0">metric_trading</text></g><g class="node " data-k="g:obt_order_lines"><rect x="1214.0" y="419.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="419.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="437.0">obt_order_lines</text></g><g class="node " data-k="g:fact_order_lines"><rect x="1214.0" y="456.3" width="330.0" height="26"/><rect class="bar" x="1214.0" y="456.3" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="474.3">fact_order_lines</text></g><g class="node " data-k="g:fact_shipments"><rect x="1214.0" y="523.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="523.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="541.0">fact_shipments</text></g><g class="node " data-k="g:rpt_margin_by_family"><rect x="1214.0" y="555.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="555.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="573.0">rpt_margin_by_family</text></g><g class="node " data-k="g:fact_returns"><rect x="1214.0" y="603.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="603.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="621.0">fact_returns</text></g><g class="node " data-k="g:dim_products"><rect x="1214.0" y="635.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="635.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="653.0">dim_products</text></g><g class="node " data-k="g:dim_carriers"><rect x="1214.0" y="755.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="755.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="773.0">dim_carriers</text></g><g class="node " data-k="g:rpt_delivery_sla"><rect x="1214.0" y="787.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="787.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="805.0">rpt_delivery_sla</text></g><g class="node " data-k="g:dim_return_reasons"><rect x="1214.0" y="819.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="819.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="837.0">dim_return_reasons</text></g><g class="node " data-k="g:rpt_returns_by_reason"><rect x="1214.0" y="851.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="851.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="869.0">rpt_returns_by_reason</text></g><g class="node " data-k="g:fact_stock_daily"><rect x="1214.0" y="939.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="939.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="957.0">fact_stock_daily</text></g><g class="node " data-k="g:dim_suppliers"><rect x="1214.0" y="979.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="979.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="997.0">dim_suppliers</text></g><g class="node " data-k="g:metric_service"><rect x="1214.0" y="1011.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1011.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1029.0">metric_service</text></g><g class="node " data-k="g:fact_purchases"><rect x="1214.0" y="1043.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1043.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1061.0">fact_purchases</text></g><g class="node stale" data-k="g:rpt_supplier_fill_rate"><rect x="1214.0" y="1075.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1075.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1093.0">rpt_supplier_fill_rate</text></g><g class="node " data-k="g:dim_campaigns"><rect x="1214.0" y="1187.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1187.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1205.0">dim_campaigns</text></g><g class="node " data-k="g:dim_date"><rect x="1214.0" y="1219.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1219.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1237.0">dim_date</text></g><g class="node " data-k="g:dim_countries"><rect x="1214.0" y="1251.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1251.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1269.0">dim_countries</text></g><g class="node " data-k="g:dim_channels"><rect x="1214.0" y="1283.0" width="330.0" height="26"/><rect class="bar" x="1214.0" y="1283.0" width="4" height="26" style="fill:#ffd23f"/><text x="1228.0" y="1301.0">dim_channels</text></g></svg></div></div>
  </section>
  <section class="s">
    <h2>What it is built from</h2>
    <p class="one">3 bronze tables and the daily feed, cleaned into 3 silver_clean tables.</p>
    <div class="vis"><table class="t fixed"><colgroup><col style="width:220px"><col style="width:360px"><col style="width:auto"></colgroup><tr><th>Layer</th><th>Table</th><th>Arrives as</th></tr><tr><td class="dim">bronze</td><td class="m col"><span class="id">commerce_orders</span></td><td class="why">the full extract, then the daily changes</td></tr><tr><td class="dim">bronze</td><td class="m col"><span class="id">commerce_order_status_history</span></td><td class="why">the full extract, then the daily changes</td></tr><tr><td class="dim">bronze</td><td class="m col"><span class="id">commerce_codes</span></td><td class="why">the full extract, the code list of the statuses</td></tr><tr><td class="dim">bronze</td><td class="m col"><span class="id">deliveries_changes</span></td><td class="why">the daily feed that carries the changes of the day</td></tr><tr><td class="dim">silver_clean</td><td class="m col"><span class="id">orders</span></td><td class="why">one row per order, typed</td></tr><tr><td class="dim">silver_clean</td><td class="m col"><span class="id">order_status_history</span></td><td class="why">one row per status change, typed</td></tr><tr><td class="dim">silver_clean</td><td class="m col"><span class="id">codes</span></td><td class="why">one row per code, typed</td></tr></table></div>
  </section>
  <section class="s">
    <h2>What reads it</h2>
    <p class="one">7 gold tables in 4 data products. 2 of them are stale, and dim_promotions_old has no owner.</p>
    <div class="vis"><table class="t fixed"><colgroup><col style="width:330px"><col style="width:200px"><col style="width:200px"><col style="width:auto"></colgroup><tr><th>Gold table</th><th>Kind</th><th>Data product</th><th>Status</th></tr><tr><td class="m col"><span class="id">fact_orders</span></td><td class="dim">fact</td><td class="">Trading</td><td class="why">rebuilt every day</td></tr><tr><td class="m col"><span class="id">fact_order_lines</span></td><td class="dim">fact</td><td class="">Trading</td><td class="why">rebuilt every day</td></tr><tr><td class="m col"><span class="id">obt_order_lines</span></td><td class="dim">one big table</td><td class="">Trading</td><td class="why">rebuilt every day, the most read table of 2026-08</td></tr><tr><td class="m col"><span class="id">metric_trading</span></td><td class="dim">metric</td><td class="">Trading</td><td class="why">rebuilt every day</td></tr><tr><td class="m col"><span class="id">fact_shipments</span></td><td class="dim">fact</td><td class="">Delivery</td><td class="why">rebuilt every day</td></tr><tr><td class="m col"><span class="id">rpt_daily_sales_wide</span></td><td class="dim">report table</td><td class="">Daily sales</td><td class="why">deprecated, 31 days behind</td></tr><tr><td class="m col"><span class="id">dim_promotions_old</span></td><td class="dim">dimension</td><td class="">Campaigns</td><td class="why">stale, run by hand, no owner</td></tr></table></div>
  </section>
  <section class="s">
    <h2>Who reads them</h2>
    <p class="one">6 roles in the query logs, with 1,412 queries on the 7 gold tables in 2026-08.</p>
    <div class="vis"><table class="t fixed"><colgroup><col style="width:330px"><col style="width:220px"><col style="width:auto"></colgroup><tr><th>Role</th><th>Team</th><th>What for</th></tr><tr><td class="m col"><span class="id">finance_analyst</span></td><td class="">Finance</td><td class="why">net revenue, margin and the month end</td></tr><tr><td class="m col"><span class="id">commercial_analyst</span></td><td class="">Commercial</td><td class="why">sales by brand, category and SKU</td></tr><tr><td class="m col"><span class="id">marketing_analyst</span></td><td class="">Marketing</td><td class="why">new, returning and guest orders, and the campaign offers</td></tr><tr><td class="m col"><span class="id">data_scientist</span></td><td class="">Data Science</td><td class="why">the detail behind a model, read-only</td></tr><tr><td class="m col"><span class="id">monday_pack</span></td><td class="">the BI service</td><td class="why">the Monday trading pack, and 5 queries on rpt_daily_sales_wide</td></tr><tr><td class="m col"><span class="id">operations_analyst</span></td><td class="">Operations</td><td class="why">shipments against promises, by carrier</td></tr></table></div>
  </section>
  <section class="s">
    <h2>The checks that cover it</h2>
    <p class="one">6 checks read orders or a table built from it. A change to the key of orders breaks 4 of them until they are updated.</p>
    <div class="vis"><table class="t fixed"><colgroup><col style="width:300px"><col style="width:200px"><col style="width:90px"><col style="width:auto"><col style="width:200px"></colgroup><tr><th>Check</th><th>Table</th><th>Gate</th><th>What it checks</th><th>On a key change</th></tr><tr><td class="m col"><span class="id">unique_sequence</span></td><td class="m dim">orders</td><td class="num">3</td><td class="why">the changes arrive without a gap in their sequence</td><td class="dim">passes</td></tr><tr><td class="m col"><span class="id">known_code</span></td><td class="m dim">orders</td><td class="num">3</td><td class="why">every status code is in the code list</td><td class="dim">passes</td></tr><tr><td class="m col"><span class="id">unique_key</span></td><td class="m dim">orders</td><td class="num">4</td><td class="why">one row per order_id</td><td class=""><span class="vd care">breaks</span></td></tr><tr><td class="m col"><span class="id">known_order</span></td><td class="m dim">shipments</td><td class="num">3</td><td class="why">every shipment points at a known order</td><td class=""><span class="vd care">breaks</span></td></tr><tr><td class="m col"><span class="id">known_parent</span></td><td class="m dim">order_lines</td><td class="num">4</td><td class="why">every order line has its order</td><td class=""><span class="vd care">breaks</span></td></tr><tr><td class="m col"><span class="id">row_count_matches</span></td><td class="m dim">fact_orders</td><td class="num">4</td><td class="why">one row in fact_orders per order</td><td class=""><span class="vd care">breaks</span></td></tr></table></div>
  </section>
  <section class="s">
    <h2>The safe order of the change</h2>
    <p class="one">Change it on a branch, prove it on a test run, tell the readers, then release.</p>
    <div class="stepsbox"><ol class="chg-steps">
      <li>Change orders and the 4 checks that break, on a branch, never on the production tables.</li>
      <li>Rebuild silver_core.orders and the 7 gold tables in a test run.</li>
      <li>Compare the 7 gold tables before and after, row by row where a number moves.</li>
      <li>Tell the 6 roles that read them, with a release note on Trading and Delivery.</li>
      <li>Release with the daily run, and watch the 6 checks on the first day.</li>
    </ol>
    <p class="chg-note">rpt_daily_sales_wide and dim_promotions_old are stale, and dim_promotions_old has no owner. Ask before you rebuild them, or retire them first.</p></div>
  </section>
</main>
<script>
  (function () {
    document.querySelectorAll('.lin').forEach(function (root) {
      var nodes = Array.prototype.slice.call(root.querySelectorAll('.node'));
      var wires = Array.prototype.slice.call(root.querySelectorAll('.wire'));
      var up = {}, down = {};
      wires.forEach(function (w) { var a = w.dataset.a, b = w.dataset.b; (down[a] = down[a] || []).push(b); (up[b] = up[b] || []).push(a); });
      function walk(start, map) { var seen = {}, stack = [start]; while (stack.length) { var k = stack.pop(); (map[k] || []).forEach(function (n) { if (!seen[n]) { seen[n] = true; stack.push(n); } }); } return seen; }
      function clear() { nodes.forEach(function (n) { n.classList.remove('on', 'up', 'down', 'off'); }); wires.forEach(function (w) { w.classList.remove('up', 'down', 'off'); }); }
      nodes.forEach(function (n) { n.addEventListener('click', function (ev) {
        ev.stopPropagation(); clear(); var k = n.dataset.k, u = walk(k, up), d = walk(k, down);
        nodes.forEach(function (o) { var ok = o.dataset.k; o.classList.add(ok === k ? 'on' : u[ok] ? 'up' : d[ok] ? 'down' : 'off'); });
        wires.forEach(function (w) { var a = w.dataset.a, b = w.dataset.b; w.classList.add((u[a] || a === k) && (u[b] || b === k) ? 'up' : (d[a] || a === k) && (d[b] || b === k) ? 'down' : 'off'); });
      }); });
      document.addEventListener('click', clear); document.addEventListener('keydown', function (ev) { if (ev.key === 'Escape') clear(); });
      var h = decodeURIComponent(location.hash.slice(1)) || 'orders', hits = h ? nodes.filter(function (n) { return n.dataset.k.split(':').pop() === h; }) : [], n0 = hits[hits.length - 1];
      if (n0 && !root.dataset.lit) { root.dataset.lit = '1'; n0.dispatchEvent(new MouseEvent('click', {bubbles: true, cancelable: true})); }
    });
  })();</script>
</body>
</html>
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 197kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall