:root{
  --bg:#f7f6f2; --panel:#fff; --ink:#1c2226; --muted:#69737a; --line:#e3e1da; --line2:#efede7;
  --accent:#1f4e5f; --accent-soft:#e6eef0; --warn:#8a5a00; --warn-bg:#fbf3e2;
  --mono:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace;
  --sans:-apple-system,BlinkMacSystemFont,"Segoe UI",Inter,Roboto,"Helvetica Neue",Arial,sans-serif;
}
*{box-sizing:border-box}
[hidden]{display:none!important}
html,body{margin:0;background:var(--bg);color:var(--ink);font:14px/1.45 var(--sans);-webkit-font-smoothing:antialiased}
a{color:var(--accent)}
code{font-family:var(--mono);font-size:.92em;background:var(--line2);padding:.05em .3em;border-radius:3px}
.sr{position:absolute;left:-9999px}
.muted{color:var(--muted)}
.top{display:flex;justify-content:space-between;align-items:flex-start;gap:16px;padding:18px 24px 10px}
.brand{font-size:20px;font-weight:600;letter-spacing:-.01em}
.brand .crumb-db{text-decoration:none;color:var(--muted);font-weight:500}
.brand .sep{color:var(--line);margin:0 6px}
.tag{margin:2px 0 0;font-size:13px;font-weight:400;color:var(--muted)}
.engine{font-size:12px;color:var(--muted);display:flex;align-items:center;gap:6px;white-space:nowrap;padding-top:6px}
.engine .dot{width:8px;height:8px;border-radius:50%;background:#c9a227;display:inline-block}
.engine.ready .dot{background:#3c8d5a}
.engine.err .dot{background:#b23b3b}
.tables{display:flex;gap:10px;padding:0 24px 14px;flex-wrap:wrap}
.tcard{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:11px 14px 12px;text-decoration:none;color:var(--ink);min-width:240px;max-width:340px;flex:1 1 240px;cursor:pointer;text-align:left;font:inherit}
.tcard:hover{border-color:#c8c5bb}
.tcard.on{border-color:var(--accent);box-shadow:0 0 0 1px var(--accent) inset;background:var(--accent-soft)}
.tcard .ttl{display:block;font-size:14.5px;font-weight:650;letter-spacing:-.01em;line-height:1.25}
.tcard .meta{display:block;color:var(--accent);font-variant-numeric:tabular-nums;font-weight:600;font-size:12.5px;margin-top:2px}
.tcard small{display:block;color:var(--muted);font-size:12px;margin-top:4px;line-height:1.35;white-space:normal}
.layout{display:grid;grid-template-columns:270px minmax(0,1fr);gap:18px;padding:0 24px 24px}
.facets{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:12px 14px;align-self:start;position:sticky;top:12px;max-height:calc(100vh - 24px);overflow:auto}
.facets-head{display:flex;justify-content:space-between;align-items:center;margin-bottom:6px}
.facet{border-top:1px solid var(--line2);padding:10px 0 8px}
.facet h4{margin:0 0 6px;font-size:12px;text-transform:uppercase;letter-spacing:.05em;color:var(--muted);font-weight:600;display:flex;justify-content:space-between}
.facet h4 span{text-transform:none;letter-spacing:0;font-weight:400}
.facet ul{list-style:none;margin:0;padding:0}
.facet li{display:flex;justify-content:space-between;gap:8px;padding:2px 4px;border-radius:5px;cursor:pointer;font-size:13px}
.facet li:hover{background:var(--line2)}
.facet li .v{overflow:hidden;text-overflow:ellipsis;white-space:nowrap}
.facet li .c{color:var(--muted);font-variant-numeric:tabular-nums;font-size:12px}
.facet li.sel{background:var(--accent-soft);color:var(--accent);font-weight:600}
.facet li.sel .v::before{content:"✓ ";}
.facet li.blank .v{color:var(--muted);font-style:italic}
.facet input{width:100%;padding:5px 8px;border:1px solid var(--line);border-radius:6px;font:inherit;font-size:12.5px;margin-bottom:5px;background:#fcfcfa}
.facet .more{font-size:12px;margin-top:3px}
button.link{background:none;border:0;padding:0;color:var(--accent);cursor:pointer;font:inherit;font-size:12px}
.results{min-width:0}
.toolbar{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:12px;display:flex;flex-direction:column;gap:10px}
.search input{width:100%;padding:10px 12px;font:inherit;font-size:15px;border:1px solid var(--line);border-radius:8px;background:#fcfcfa}
.search input:focus,.ranges input:focus,textarea:focus{outline:2px solid var(--accent-soft);border-color:var(--accent)}
.ranges{display:flex;flex-wrap:wrap;gap:10px 16px;align-items:center;font-size:12.5px;color:var(--muted)}
.ranges label{display:flex;align-items:center;gap:6px}
.ranges input{font:inherit;font-size:13px;padding:5px 7px;border:1px solid var(--line);border-radius:6px;background:#fcfcfa;color:var(--ink)}
.ranges input[type=number]{width:96px}
.dash{color:var(--muted)}
.btn{font:inherit;font-size:13px;padding:6px 12px;border-radius:7px;border:1px solid var(--accent);background:var(--accent);color:#fff;cursor:pointer;white-space:nowrap;list-style:none}
.btn:hover{filter:brightness(1.08)}
.btn.ghost{background:var(--panel);color:var(--ink);border-color:var(--line)}
.btn.ghost:hover{border-color:#c8c5bb;filter:none}
.btn[disabled]{opacity:.55;cursor:wait}
.chips{display:flex;flex-wrap:wrap;gap:6px;margin:10px 0 0}
.chip{background:var(--accent-soft);color:var(--accent);border-radius:999px;padding:3px 6px 3px 10px;font-size:12.5px;display:inline-flex;gap:6px;align-items:center}
.chip b{font-weight:600}
.chip button{border:0;background:none;color:var(--accent);cursor:pointer;font-size:14px;line-height:1;padding:0 3px}
.summary{display:flex;justify-content:space-between;align-items:center;gap:10px;margin:12px 0 8px;flex-wrap:wrap}
.count{font-size:15px}
.count b{font-variant-numeric:tabular-nums}
.actions{display:flex;gap:8px;align-items:center;flex-wrap:wrap}
.actions.left{justify-content:flex-start;margin:8px 0}
.cols{position:relative}
.cols summary::-webkit-details-marker{display:none}
.cols-menu{position:absolute;right:0;top:34px;z-index:5;background:var(--panel);border:1px solid var(--line);border-radius:8px;padding:8px 10px;box-shadow:0 8px 24px rgba(0,0,0,.08);columns:2;column-gap:18px;width:380px;font-size:12.5px}
.cols-menu label{display:block;padding:2px 0;white-space:nowrap}
.note{background:var(--warn-bg);color:var(--warn);border-radius:8px;padding:8px 12px;font-size:13px;margin-bottom:8px}
.tablewrap{background:var(--panel);border:1px solid var(--line);border-radius:10px;overflow:auto;max-height:calc(100vh - 120px)}
table{border-collapse:separate;border-spacing:0;width:100%;font-size:13px}
th,td{padding:7px 10px;border-bottom:1px solid var(--line2);text-align:left;white-space:nowrap;max-width:280px;overflow:hidden;text-overflow:ellipsis}
th{position:sticky;top:0;background:#fbfaf7;z-index:2;font-size:12px;font-weight:600;color:#444c52;border-bottom:1px solid var(--line);cursor:pointer;user-select:none}
th:hover{color:var(--accent)}
th.sorted{color:var(--accent)}
th .arr{font-size:10px;margin-left:3px}
td.num,th.num{text-align:right;font-variant-numeric:tabular-nums}
td.mono{font-family:var(--mono);font-size:12px}
td.null{color:#b5b9bb}
tbody tr:hover td{background:#faf9f5}
td a.rowlink{color:var(--accent);text-decoration:none;cursor:pointer}
td a.rowlink:hover{text-decoration:underline}
.loading tbody{opacity:.45;transition:opacity .15s}
.pager{display:flex;justify-content:space-between;align-items:center;gap:10px;margin-top:10px;font-size:13px;color:var(--muted);flex-wrap:wrap}
.pager .pg{display:flex;gap:6px;align-items:center}
.pager select,.pager input{font:inherit;font-size:13px;padding:4px 6px;border:1px solid var(--line);border-radius:6px;background:var(--panel)}
.pager input{width:70px}
.sqlview{padding:0 24px 24px}
textarea{width:100%;font:13px/1.5 var(--mono);padding:12px;border:1px solid var(--line);border-radius:10px;background:var(--panel);color:var(--ink)}
.examples{display:flex;gap:6px;flex-wrap:wrap;margin:4px 0 12px}
.examples button{font:inherit;font-size:12px;border:1px solid var(--line);background:var(--panel);border-radius:999px;padding:3px 10px;cursor:pointer;color:var(--ink)}
.ask-hero{margin:0 0 4px}
.ask-hero h2{margin:0 0 4px;font-size:18px;font-weight:650;letter-spacing:-.01em}
.ask-hero p{margin:0 0 8px;max-width:720px}
.ask-prompts{display:grid;grid-template-columns:repeat(auto-fill,minmax(250px,1fr));gap:8px;margin:10px 0 16px}
.aprompt{font:inherit;text-align:left;background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:11px 13px;cursor:pointer;color:var(--ink);display:flex;flex-direction:column;gap:3px}
.aprompt:hover{border-color:var(--accent);background:var(--accent-soft)}
.aprompt b{font-size:13.5px;font-weight:600;letter-spacing:-.01em}
.aprompt span{font-size:12px;color:var(--muted);line-height:1.35}
.aprompt .kind{font-size:11px;color:var(--accent);font-weight:600;text-transform:uppercase;letter-spacing:.04em}
.adv-sql{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:0;margin:0 0 14px}
.adv-sql > summary{cursor:pointer;list-style:none;padding:12px 14px;font-weight:600;font-size:13.5px;user-select:none}
.adv-sql > summary::-webkit-details-marker{display:none}
.adv-sql > summary::before{content:"▸";display:inline-block;width:1em;color:var(--muted);transition:transform .12s}
.adv-sql[open] > summary::before{transform:rotate(90deg)}
.adv-sql > summary .muted{font-weight:400;font-size:12px}
.adv-body{padding:0 14px 14px}
.adv-body textarea{margin-top:2px}

.prov{padding:18px 24px 36px;color:var(--muted);font-size:12.5px;border-top:1px solid var(--line);background:#f2f1ec;line-height:1.6}
.prov h3{color:var(--ink);font-size:13px;margin:0 0 6px}
.prov .grid{display:grid;grid-template-columns:repeat(auto-fit,minmax(280px,1fr));gap:12px 28px;max-width:1300px}
.prov p{margin:0 0 6px}
dialog{border:1px solid var(--line);border-radius:12px;padding:18px;max-width:640px;width:calc(100% - 32px);box-shadow:0 20px 50px rgba(0,0,0,.15)}
dialog::backdrop{background:rgba(20,25,28,.35)}
dialog table td{white-space:normal;max-width:none}
dialog table td:first-child{color:var(--muted);width:40%;font-family:var(--mono);font-size:12px}
dialog .btn{margin-top:12px}
.mobile-only{display:none}
@media (max-width:860px){
  .top{padding:14px 14px 8px;flex-direction:column;gap:4px}
  .engine{padding-top:0}
  .tables{padding:0 14px 10px}
  .tables{flex-wrap:nowrap;overflow-x:auto;-webkit-overflow-scrolling:touch;padding-bottom:12px}
  .tcard{min-width:0;flex:0 0 auto;max-width:82vw;padding:8px 12px}
  .tcard small{display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;overflow:hidden}
  .ranges label{flex-wrap:wrap}
  .layout{grid-template-columns:1fr;padding:0 14px 18px}
  .facets{position:static;max-height:none;display:none}
  .facets.open{display:block}
  .mobile-only{display:inline-block}
  .ranges input[type=number]{width:80px}
  .cols-menu{width:300px;right:auto;left:0}
  .tablewrap{max-height:none}
  .sqlview{padding:0 14px 18px}
  .prov{padding:16px 14px 30px}
}

/* smart search: famflix-style instant suggestions */
.search{position:relative}
.search label{display:block}
.search input{padding-right:40px}
.search .kbd{position:absolute;right:10px;top:9px;font:11px/1.6 var(--mono);color:var(--muted);border:1px solid var(--line);border-radius:5px;padding:0 6px;background:#fff;pointer-events:none}
.search:focus-within .kbd{display:none}
.search input::-webkit-search-cancel-button{cursor:pointer}
.sugg{display:none;position:absolute;top:44px;left:0;right:0;z-index:30;background:#fff;border:1px solid var(--line);border-radius:12px;box-shadow:0 18px 50px rgba(20,30,35,.16);padding:6px;max-height:min(70vh,560px);overflow-y:auto;overscroll-behavior:contain}
.search.open .sugg{display:block}
.sg-h{display:flex;justify-content:space-between;padding:9px 10px 3px;font-size:11px;letter-spacing:.1em;text-transform:uppercase;color:var(--muted);font-weight:600}
.sg-r{display:flex;align-items:center;gap:12px;padding:7px 10px;border-radius:8px;cursor:pointer}
.sg-r.on,.sg-r:hover{background:var(--accent-soft)}
.sg-r .t{flex:1 1 auto;min-width:0;white-space:nowrap;overflow:hidden;text-overflow:ellipsis;font-size:14px}
.sg-r .t mark{background:none;color:var(--accent);font-weight:700}
.sg-r .m{flex:0 0 auto;font-size:12px;color:var(--muted);font-variant-numeric:tabular-nums}
.sg-all .t{color:var(--ink)}
.sg-all b.mono{font-family:var(--mono);font-size:13px}
.sg-e{padding:10px;color:var(--muted);font-size:13px}
.sg-f{padding:7px 10px 4px;font-size:11.5px;color:var(--muted);border-top:1px solid var(--line2);margin-top:4px}
.qhint{display:flex;flex-wrap:wrap;gap:6px;margin-top:7px;font-size:12px;color:var(--muted)}
.qhint[hidden]{display:none}
.qh{background:var(--line2);border-radius:999px;padding:2px 9px}
.qh b{color:var(--ink);font-weight:600}
.qh.alias,.qh.split{background:var(--accent-soft);color:var(--accent)}
.qh.typo{background:var(--warn-bg);color:var(--warn)}
.qh.filter,.qh.id{background:#eef2e8;color:#3d5a1f}
.qh.rule{background:none;padding-left:2px}
@media (max-width:700px){.sugg{max-height:60vh}.search .kbd{display:none}}

/* ---------- UX v3: grid key columns, insights, hierarchy, trails, roll-ups, drawer ---------- */
td.place{max-width:300px}
td.place .pl{display:block;overflow:hidden;text-overflow:ellipsis}
td.place small{display:block;color:var(--muted);font-size:11.5px;line-height:1.2;overflow:hidden;text-overflow:ellipsis}
tr.rowclick{cursor:pointer}
.gtag{display:inline-block;font-size:10.5px;line-height:1.5;padding:0 6px;margin-right:6px;border-radius:999px;background:var(--warn-bg);color:var(--warn);font-weight:600;vertical-align:1px;text-transform:lowercase}
.insights{margin:12px 0 4px;display:flex;flex-direction:column;gap:10px;transition:opacity .15s}
.insights.loading .strip,.insights.loading .panel{opacity:.5}
.crumbs{display:flex;flex-wrap:wrap;align-items:center;gap:4px;font-size:13px}
.cr{font:inherit;background:none;border:0;padding:2px 4px;border-radius:5px;color:var(--accent);cursor:pointer}
button.cr:hover{background:var(--accent-soft);text-decoration:underline}
.cr.cur{color:var(--ink);font-weight:600;cursor:default}
.crsep{color:#b0b3ad}
.answer{font-size:16.5px;line-height:1.45;background:var(--panel);border:1px solid var(--line);border-left:4px solid var(--accent);border-radius:10px;padding:11px 14px}
.answer b{font-variant-numeric:tabular-nums}
.answer .q{color:var(--muted);font-size:14px}
.strip{display:grid;grid-template-columns:repeat(auto-fit,minmax(130px,1fr));gap:8px}
.strip:empty{display:none}
.kpi{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:8px 12px;display:flex;flex-direction:column;min-width:0}
.kpi span{font-size:11px;letter-spacing:.06em;text-transform:uppercase;color:var(--muted);font-weight:600}
.kpi b{font-size:18px;font-variant-numeric:tabular-nums;white-space:nowrap;overflow:hidden;text-overflow:ellipsis}
.kpi small{color:var(--muted);font-size:11.5px}
.panel{background:var(--panel);border:1px solid var(--line);border-radius:10px;padding:10px 12px}
.ph{display:flex;justify-content:space-between;align-items:baseline;gap:10px;flex-wrap:wrap;margin-bottom:6px}
.ph h3{margin:0;font-size:14px}
.ph h3 .muted{font-weight:400;font-size:12.5px;margin-left:4px}
.ph .hint{font-size:12px}
.hwrap{overflow:auto;max-height:420px}
table.mini{font-size:12.5px}
table.mini th{position:sticky;top:0;cursor:default;background:#fbfaf7}
table.mini td,table.mini th{padding:5px 8px}
table.mini td.nm{max-width:360px;font-weight:500}
table.mini td.go{color:var(--muted);width:16px}
table.hl tbody tr{cursor:pointer}
table.hl tbody tr:hover td{background:var(--accent-soft)}
.panel .link{margin-top:6px}
.ugroup{margin:4px 0 10px}
.ugh{display:flex;gap:10px;align-items:baseline;margin-bottom:5px;font-size:13px}
.units{display:grid;grid-template-columns:repeat(auto-fill,minmax(150px,1fr));gap:6px}
.unit{font:inherit;text-align:left;background:#fcfcfa;border:1px solid var(--line);border-radius:8px;padding:6px 9px;cursor:pointer;display:flex;flex-direction:column;gap:1px;color:var(--ink)}
.unit:hover{border-color:var(--accent);background:var(--accent-soft)}
.unit .usz{font-weight:600;font-variant-numeric:tabular-nums}
.unit .un,.unit .ud{font-size:11.5px;color:var(--muted)}
.unit .up{font-size:12.5px;font-variant-numeric:tabular-nums}
.unit.more{align-items:center;justify-content:center;color:var(--accent)}
em.up,em.dn{font-style:normal;font-size:11.5px;font-weight:600}
em.up{color:#2f7a4a} em.dn{color:#b23b3b}
.tcap{font-size:12px;color:var(--muted);margin:4px 0 8px}
.trails{display:grid;grid-template-columns:minmax(0,1.2fr) minmax(0,1fr);gap:16px}
.tcol h4{margin:0 0 6px;font-size:12.5px}
.tcol h4 .muted{font-weight:400}
ol.trail{list-style:none;margin:0;padding:0 0 0 14px;border-left:2px solid var(--line)}
ol.trail li{position:relative;display:grid;grid-template-columns:86px minmax(0,1fr) auto;column-gap:10px;row-gap:0;padding:5px 6px;border-radius:6px;cursor:pointer;font-size:12.5px}
ol.trail li:hover{background:var(--accent-soft)}
ol.trail li::before{content:"";position:absolute;left:-20px;top:10px;width:10px;height:10px;border-radius:50%;background:var(--accent);border:2px solid var(--panel)}
ol.trail li.other::before{background:#c9c6bc}
ol.trail li.other{color:var(--muted)}
ol.trail li.hi{background:var(--warn-bg)}
ol.trail .tproc{overflow:hidden;text-overflow:ellipsis;white-space:nowrap}
ol.trail .tproc small,.tamt small{color:var(--muted)}
ol.trail .tamt{text-align:right;font-variant-numeric:tabular-nums;font-weight:600}
ol.trail .tpsm{grid-column:2;font-size:11.5px;color:var(--muted)}
ol.trail em{grid-column:3;text-align:right}
.rrow{display:flex;gap:10px;align-items:flex-start;margin-bottom:6px}
.rlab{flex:0 0 86px;font-size:11px;letter-spacing:.06em;text-transform:uppercase;color:var(--muted);font-weight:600;padding-top:8px}
.rcards{display:flex;gap:6px;overflow-x:auto;padding-bottom:4px;min-width:0}
.rcard{position:relative;font:inherit;flex:0 0 auto;min-width:92px;text-align:left;background:#fcfcfa;border:1px solid var(--line);border-radius:8px;padding:5px 9px 8px;cursor:pointer;display:flex;flex-direction:column;color:var(--ink);overflow:hidden}
.rcard.p{max-width:220px}
.rcard:hover{border-color:#c8c5bb}
.rcard.on{border-color:var(--accent);box-shadow:0 0 0 1px var(--accent) inset;background:var(--accent-soft)}
.rcard .rk{font-size:11.5px;color:var(--muted);white-space:nowrap;overflow:hidden;text-overflow:ellipsis}
.rcard b{font-size:15px;font-variant-numeric:tabular-nums}
.rcard small{font-size:11px;color:var(--muted);white-space:nowrap}
.rcard .bar{position:absolute;left:0;bottom:0;height:3px;background:var(--accent);opacity:.55}
.rollx{border-top:1px solid var(--line2);margin-top:6px;padding-top:8px}
dialog.drawer{margin:0 0 0 auto;height:100vh;max-height:100vh;width:min(560px,100vw);max-width:100vw;border-radius:0;border:0;border-left:1px solid var(--line);padding:18px 20px;overflow:auto}
dialog.drawer[open]{animation:slidein .18s ease-out}
@keyframes slidein{from{transform:translateX(40px);opacity:.4}to{transform:none;opacity:1}}
.dh{display:flex;justify-content:space-between;gap:10px;align-items:flex-start}
.dbig{font-size:22px;font-weight:700;font-variant-numeric:tabular-nums}
.dmeta{color:var(--muted);font-size:13px;margin-top:2px}
.dwhere{font-size:14px;font-weight:600;margin-top:4px}
.dx{font:inherit;font-size:24px;line-height:1;background:none;border:0;cursor:pointer;color:var(--muted);padding:0 4px}
.dact{display:flex;gap:6px;flex-wrap:wrap;margin:12px 0 4px}
.dsec{margin:16px 0 6px;font-size:12px;letter-spacing:.06em;text-transform:uppercase;color:var(--muted)}
table.dfields td{white-space:normal;max-width:none;padding:5px 8px}
table.dfields td:first-child{color:var(--muted);width:44%;font-size:12.5px}
table.dfields td:first-child code{font-size:10.5px;background:none;color:#a0a5a8}
@media (max-width:860px){
  .trails{grid-template-columns:1fr}
  .rrow{flex-direction:column;gap:2px}
  .rlab{flex:none;padding-top:0}
  .answer{font-size:15px}
  .strip{grid-template-columns:repeat(2,minmax(0,1fr))}
}
.dact .btn{margin-top:0}
table.dfields td:first-child{font-family:var(--sans)}
