I'll start by loading the established procedure skill and the current state of the target pages.
🔧 Skill
💭 사고 과정
Following my usual startup routine, I'll read index.md and the four wiki files while running the corpus snapshot queries in parallel, along with checking the inbox and log tail as memory #151 suggests.
⚡ 명령 · cd C:/Users/user/lax-brain && echo "=== INDEX (판례 항목) ===" && grep -n "판례" company/index.m…
cd C:/Users/user/lax-brain && echo "=== INDEX (판례 항목) ===" && grep -n "판례" company/index.md && echo "=== INBOX ===" && ls -la _inbox/ 2>/dev/null && echo "=== LOG tail ===" && tail -12 company/log.md && echo "=== WIKI sizes ===" && wc -l company/wiki/판례-*.md
⚡ 명령 · cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "SELECT 'A_tag' k, query_tag, COUNT…
cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "SELECT 'A_tag' k, query_tag, COUNT(*) n FROM precedents WHERE workspace_id IS NULL GROUP BY query_tag ORDER BY n DESC; SELECT 'B_total' k, COUNT(*) total, SUM(CASE WHEN body IS NOT NULL AND length(body)>0 THEN 1 ELSE 0 END) with_body FROM precedents; SELECT 'C_src' k, source, CASE WHEN workspace_id IS NULL THEN 'null' ELSE 'ws' END w, COUNT(*) n FROM precedents GROUP BY source, w ORDER BY n DESC; SELECT 'D_edge' k, (SELECT COUNT(*) FROM precedent_statutes) statutes, (SELECT COUNT(*) FROM precedent_citations) citations, (SELECT COUNT(*) FROM precedent_citations WHERE internal_serial IS NOT NULL) internal_edges"
💭 사고 과정
The corpus counts remain unchanged across the board—still no petition-brief cases found. Now I'll read through the four wiki types and recompute E1 through E4.
코퍼스 스냅샷은 전량 무변동입니다. 이제 기준 스펙과 대상 3종을 읽고 E1~E4를 재산출합니다.
⚡ 명령 · cd C:/Users/user/lax-brain/company/wiki && echo "########## 지식층 ##########" && cat 판례-지식층.…
cd C:/Users/user/lax-brain/company/wiki && echo "########## 지식층 ##########" && cat 판례-지식층.md && echo "########## 키워드축 ##########" && cat 판례-키워드축.md
⚡ 명령 · cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "WITH dom AS (SELECT prec_serial FR…
cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "WITH dom AS (SELECT prec_serial FROM precedents WHERE query_tag IN ('구상금','보증채무','대위변제','신용보증')) SELECT 'E1' k, s.statute_key, COUNT(DISTINCT s.prec_serial) n FROM precedent_statutes s JOIN dom d ON d.prec_serial=s.prec_serial GROUP BY s.statute_key ORDER BY n DESC LIMIT 20; SELECT 'CHK' k, COUNT(DISTINCT s.prec_serial) with_statute, COUNT(*) rows FROM precedent_statutes s WHERE s.prec_serial IN (SELECT prec_serial FROM precedents WHERE query_tag IN ('구상금','보증채무','대위변제','신용보증'))"
💭 사고 과정
statute_key가 실제 컬럼명이 아닌 것 같으니 스키마를 다시 확인해봐야겠다.
컬럼명 확인이 필요합니다.
⚡ 명령 · cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "SELECT sql FROM sqlite_master WHER…
cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "SELECT sql FROM sqlite_master WHERE name IN ('precedent_statutes','precedent_citations','precedents') AND type='table'" 2>&1 | head -40
💭 사고 과정
I'll build the statute key by concatenating the law name and article number, then rerun E1. I should also check the statute cluster and leading case pages while I'm at it.
⚡ 명령 · cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "SELECT 'E1' k, s.statute_law||' '|…
cd C:/Users/user/LAX-site && node daemon/tools/d1q.mjs "SELECT 'E1' k, s.statute_law||' '||s.statute_art sk, COUNT(DISTINCT s.prec_serial) n FROM precedent_statutes s WHERE s.prec_serial IN (SELECT prec_serial FROM precedents WHERE query_tag IN ('구상금','보증채무','대위변제','신용보증')) GROUP BY sk ORDER BY n DESC, sk LIMIT 20; SELECT 'CHK' k, COUNT(DISTINCT prec_serial) with_statute, COUNT(*) rowsn FROM precedent_statutes WHERE prec_serial IN (SELECT prec_serial FROM precedents WHERE query_tag IN ('구상금','보증채무','대위변제','신용보증'))" 2>&1 | grep -v Deprecat
⚡ 명령 · cd C:/Users/user/lax-brain/company/wiki && sed -n '1,90p' 판례-조문클러스터.md
[[THINK]]I'm tallying exact matches for E1, with 민법105 leading at 153 occurrences, followed by 상법682, 민법428, and various other civil and commercial code articles. The article coverage rate stands at 1,287.
Now I'm noting a tie-break detail: 민법750 and 민법760 both show 86 occurrences on the page table, ranking 4th and 5th, and since the query's alphabetical sort happened to list 750 first among the tied values, I'll keep that as curated ordering.
Next I need to compute representative cases per cluster — taking the top 3 by total in-degree across the full 51k citation graph, deduplicated by case number using MAX, plus a tie map for ranks up to 4 across all 20 clusters. After that comes the E2 membership table, E3 leading cases, and E4 ego-network.
I'm designing the query to count citations grouped by internal serial, then join against case numbers to deduplicate by taking the maximum degree per case, filtering down to cluster members by matching against the relevant article-key domain tags.
Writing SQL for representative case selection...