# Desk log NMD-DSC-20260822

**Status:** First-party InfiniSynapse desk log (sanitized composite; not a customer extract)  
**Page:** https://infinisynapse.com/en/blog/database-schema  
**Run ID:** `NMD-DSC-20260822`  
**Date:** 2026-08-22 (Saturday)  
**Operator:** InfiniSynapse Data Team  
**Attestor:** William Zhu, InfiniSynapse cofounder ([GitHub @allwefantasy](https://github.com/allwefantasy))  
**Contact for contradictions:** zhuhl@infinisynapse.com

## What this file is

A downloadable record of opening a wiki catalog versus binding three field notes on the live columns an agent will recall. It is **not** a named-logo customer case, a vendor bake-off, or a W3C / IETF / Unicode experiment.

## Four-step method (reproducible)

1. Connect a SELECT-only role. Recall tables, keys, and types.
2. Bind three notes: status, join key, and exclude flag.
3. Ask one goal twice: Q2 refund rate by channel, paid orders as denominator, exclude test accounts.
4. Inspect SQL. Confirm the bound join and filter.

## Source and goal

| Field | Value |
|---|---|
| Sources | Read-only Postgres; 12 order-related tables; ~1.9 million paid-order rows |
| Standing goal | Q2 refund rate by channel, paid orders as denominator, exclude test accounts |
| Contrast | Wiki-only vs bound notes |

## Results

| Retrieval state | Three notes bound | Repeat-ask match | SQL inspectable |
|---|---|---|---|
| Wiki-only | 0 | 0 | 0 |
| Bound notes | 1 | 1 | 1 |

Wall-clock for the successful bind rerun: 10 minutes (warehouse time excluded). The clock started when the operator opened the standing goal and ended when the three notes, the matched repeat ask, and the inspectable SQL sat side by side.

## What you may cite

- Artifact counts 0/0/0 → 1/1/1, 12 tables + ~1.9M paid-order rows on this run, ~10 min wall-clock, run ID

## What you may not claim

- Customer uplift %, a faster remodel, official EEAT score, named-logo case, or that W3C / IETF / Unicode / PostgreSQL / Gartner / WAIC scored this run

## Independent context (not this run)

- [DID Core](https://www.w3.org/TR/did-core/) (retrieved 2026-08-29)
- [RFC 6902](https://www.rfc-editor.org/rfc/rfc6902.html) (retrieved 2026-08-29)
- [RFC 7807](https://datatracker.ietf.org/doc/html/rfc7807) (retrieved 2026-08-29)
- [Unicode character charts](https://www.unicode.org/charts/) (retrieved 2026-08-29)
- [GDAL Vector Data Model](https://gdal.org/en/stable/user/vector_data_model.html) (retrieved 2026-08-29)
- [PostgreSQL System Catalogs](https://www.postgresql.org/docs/current/catalogs.html) (retrieved 2026-08-29)
- [PostgreSQL Information Schema](https://www.postgresql.org/docs/current/information-schema.html) (retrieved 2026-08-29)
- [Wikipedia schema overview](https://en.wikipedia.org/wiki/Database_schema) (retrieved 2026-08-29)
- [ISO/IEC 9075](https://www.iso.org/standard/76583.html) (retrieved 2026-08-29)
- [W3C DCAT](https://www.w3.org/TR/vocab-dcat-3/) (retrieved 2026-08-29)
- [DataCite](https://datacite.org/) (retrieved 2026-08-29)
- First-party homepage recognition only (self-described; not independently verified here): [2026 WAIC Future Tech OPC Excellence Award](https://infinisynapse.com/#recognition)

## Machine-readable aggregate

- [aggregate-NMD-DSC-20260822.csv](https://infinisynapse.com/blog-media/database-schema/downloads/aggregate-NMD-DSC-20260822.csv)
- [verify-NMD-DSC-20260822.py](https://infinisynapse.com/blog-media/database-schema/downloads/verify-NMD-DSC-20260822.py)

**Last verified:** 2026-08-29