yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ 20-sys.db
systems/20-builder/data/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
← Back 20-sys decisions
Tables
decisions
27
domain
0
events
0
items
5
sessions
28
sqlite_sequence
4
transfers_log
2
decisions
27 rows
27
system: 02 Builder
tap
⌂ Builder Hub →
id
27
system
02 Builder
date
2026-07-21
subject
approved_by
USR369 David
se_id
—
tr_id
—
▼ Show timestamps
created_at
2026-07-21 15:29:37
⊞ Full detail →
26
system: 02 Builder
tap
⌂ Builder Hub →
id
26
system
02 Builder
date
2026-07-21
subject
approved_by
USR369 David
se_id
—
tr_id
—
▼ Show timestamps
created_at
2026-07-21 15:29:37
⊞ Full detail →
25
Bottom tab mobile size standard
system: 02 Builder
btab font-size:7px padding:3px 7px gap:2px — locked for all hub pages
tap
⌂ Builder Hub →
id
25
system
02 Builder
date
07/13/26
subject
Bottom tab mobile size standard
approved_by
USR369 David
se_id
—
tr_id
—
detail
btab font-size:7px padding:3px 7px gap:2px — locked for all hub pages
description
Bottom tab mobile size standard
▼ Show timestamps
created_at
2026-07-13 08:43:26
⊞ Full detail →
24
Gov reader panel standard locked
system: 02 Builder
readGov() with &raw=1 for all large shared text files. Panel shows text inline with Edit (purple, new tab), Download, Close buttons. Never link directly to file …
tap
⌂ Builder Hub →
id
24
system
02 Builder
date
07/13/26
subject
Gov reader panel standard locked
approved_by
USR369 David
se_id
—
tr_id
—
detail
readGov() with &raw=1 for all large shared text files. Panel shows text inline with Edit (purple, new tab), Download, Close buttons. Never link directly to file-editor.php.
description
Gov reader panel standard locked
▼ Show timestamps
created_at
2026-07-13 08:43:26
⊞ Full detail →
23
Hub Page Standard v1.1 locked
system: 02 Builder
Section order, labels (orange), Quick Access inline, gov reader Edit button, btab mobile sizing, sys-link dim color, Standards+Commands links — all 5 Core pag …
tap
⌂ Builder Hub →
id
23
system
02 Builder
date
07/13/26
subject
Hub Page Standard v1.1 locked
approved_by
USR369 David
se_id
—
tr_id
—
detail
Section order, labels (orange), Quick Access inline, gov reader Edit button, btab mobile sizing, sys-link dim color, Standards+Commands links — all 5 Core pages conform — standard at systems/20-builder/standards/HUB-PAGE-STANDARD-S.md
description
Hub Page Standard v1.1 locked
▼ Show timestamps
created_at
2026-07-13 08:43:26
⊞ Full detail →
22
Standard backend tab bar format locked
system: 02 Builder
Every backend system hub page uses identical tab bar. Order: ← Hub, Admin, Master, Builder, Server, Tech, Backend (current, highlighted), Frontend (links to t …
tap
⌂ Builder Hub →
id
22
system
02 Builder
date
07/13/26
subject
Standard backend tab bar format locked
approved_by
USR369 David
se_id
—
tr_id
—
detail
Every backend system hub page uses identical tab bar. Order: ← Hub, Admin, Master, Builder, Server, Tech, Backend (current, highlighted), Frontend (links to that systems frontend page).
description
Standard backend tab bar format locked
▼ Show timestamps
created_at
2026-07-13 06:39:00
⊞ Full detail →
21
Core Five — Tech [03] included in all backend tab bars
system: 02 Builder
Tech [03] is part of the Core Five alongside Core Four. All backend system hub pages include Tech in the tab bar. Standard: ← Hub | Admin | Master | Builder | …
tap
⌂ Builder Hub →
id
21
system
02 Builder
date
07/13/26
subject
Core Five — Tech [03] included in all backend tab bars
approved_by
USR369 David
se_id
—
tr_id
—
detail
Tech [03] is part of the Core Five alongside Core Four. All backend system hub pages include Tech in the tab bar. Standard: ← Hub | Admin | Master | Builder | Server | Tech | Backend | Frontend.
description
Core Five — Tech [03] included in all backend tab bars
▼ Show timestamps
created_at
2026-07-13 06:39:00
⊞ Full detail →
20
Gym Logger moved to frontend/70-Health/apps/Gym/
system: 02 Builder
Moved from frontend/70-Health/Gym/ to frontend/70-Health/apps/Gym/. All links updated. apps/ is the standard subdir for user-facing apps within each system.
tap
⌂ Builder Hub →
id
20
system
02 Builder
date
07/12/26
subject
Gym Logger moved to frontend/70-Health/apps/Gym/
approved_by
USR369 David
se_id
—
tr_id
—
detail
Moved from frontend/70-Health/Gym/ to frontend/70-Health/apps/Gym/. All links updated. apps/ is the standard subdir for user-facing apps within each system.
description
Gym Logger moved to frontend/70-Health/apps/Gym/
▼ Show timestamps
created_at
2026-07-12 16:52:56
⊞ Full detail →
19
System color identity — --sys and --text per domain system
system: 02 Builder
Each of 7 domain systems has --sys (primary color) and --text (lighter tint). Applied to page title, breadcrumb, section labels, card hover borders, active tab. …
tap
⌂ Builder Hub →
id
19
system
02 Builder
date
07/12/26
subject
System color identity — --sys and --text per domain system
approved_by
USR369 David
se_id
—
tr_id
—
detail
Each of 7 domain systems has --sys (primary color) and --text (lighter tint). Applied to page title, breadcrumb, section labels, card hover borders, active tab. Front Door cards show system name in its color.
description
System color identity — --sys and --text per domain system
▼ Show timestamps
created_at
2026-07-12 16:52:56
⊞ Full detail →
18
Gov file naming standard — type-decade.md
system: 02 Builder
All gov files named [type]-[decade].md — e.g. knowledge-20.md, todo-50.md. Applied to all 11 systems. Files live in systems/[dir]/gov/ only — no loose files …
tap
⌂ Builder Hub →
id
18
system
02 Builder
date
07/12/26
subject
Gov file naming standard — type-decade.md
approved_by
USR369 David
se_id
—
tr_id
—
detail
All gov files named [type]-[decade].md — e.g. knowledge-20.md, todo-50.md. Applied to all 11 systems. Files live in systems/[dir]/gov/ only — no loose files in system root.
description
Gov file naming standard — type-decade.md
▼ Show timestamps
created_at
2026-07-12 16:52:56
⊞ Full detail →
17
frontend/ is the user-facing root — replaces 05-Front_end
system: 02 Builder
Final name: frontend/. Contains 7 domain system dirs + index.html (Front Door). Each system has 7 dirs: apps/ media/ web/ temp/ cache/ exports/ assets/.
tap
⌂ Builder Hub →
id
17
system
02 Builder
date
07/12/26
subject
frontend/ is the user-facing root — replaces 05-Front_end
approved_by
USR369 David
se_id
—
tr_id
—
detail
Final name: frontend/. Contains 7 domain system dirs + index.html (Front Door). Each system has 7 dirs: apps/ media/ web/ temp/ cache/ exports/ assets/.
description
frontend/ is the user-facing root — replaces 05-Front_end
▼ Show timestamps
created_at
2026-07-12 16:52:56
⊞ Full detail →
16
TOOLS-INDEX.md deployed — stop sign for backend/tools/
system: 02 Builder
Machine-readable pointer at backend/tools/TOOLS-INDEX.md. Lists file-editor, ml-editor, file-reader, db-admin, db-viewer with URLs, params, common paths, and st …
tap
⌂ Builder Hub →
id
16
system
02 Builder
date
07/12/26
subject
TOOLS-INDEX.md deployed — stop sign for backend/tools/
approved_by
USR369 David
se_id
—
tr_id
—
detail
Machine-readable pointer at backend/tools/TOOLS-INDEX.md. Lists file-editor, ml-editor, file-reader, db-admin, db-viewer with URLs, params, common paths, and standard link markup. Referenced in OPEN/REFRESH/build.php as tools_index field.
description
TOOLS-INDEX.md deployed — stop sign for backend/tools/
▼ Show timestamps
created_at
2026-07-12 11:40:07
⊞ Full detail →
15
file-editor.php v1.2 — open all paths, mobile fix
system: 02 Builder
Removed path restriction whitelist — any path allowed, token still gates access. Fixed white-space:pre to pre-wrap + -webkit-user-modify:read-write for mobile …
tap
⌂ Builder Hub →
id
15
system
02 Builder
date
07/12/26
subject
file-editor.php v1.2 — open all paths, mobile fix
approved_by
USR369 David
se_id
—
tr_id
—
detail
Removed path restriction whitelist — any path allowed, token still gates access. Fixed white-space:pre to pre-wrap + -webkit-user-modify:read-write for mobile textarea input.
description
file-editor.php v1.2 — open all paths, mobile fix
▼ Show timestamps
created_at
2026-07-12 11:40:07
⊞ Full detail →
14
records.db file_events table — audit log for file writes
system: 02 Builder
Lightweight write event log. Fields: file_path, event_type, system, bytes, note, created_at. API actions: log_file_event, list_file_events. Logged on every ML e …
tap
⌂ Builder Hub →
id
14
system
02 Builder
date
07/12/26
subject
records.db file_events table — audit log for file writes
approved_by
USR369 David
se_id
—
tr_id
—
detail
Lightweight write event log. Fields: file_path, event_type, system, bytes, note, created_at. API actions: log_file_event, list_file_events. Logged on every ML editor save.
description
records.db file_events table — audit log for file writes
▼ Show timestamps
created_at
2026-07-12 11:40:07
⊞ Full detail →
13
records.db list_items table — R001+ record IDs for all list items
system: 02 Builder
New table in backend/records/db/records.db. Fields: record_id, label, detail, priority, status, list_file, added_by, added_at, completed_at. API actions: add_it …
tap
⌂ Builder Hub →
id
13
system
02 Builder
date
07/12/26
subject
records.db list_items table — R001+ record IDs for all list items
approved_by
USR369 David
se_id
—
tr_id
—
detail
New table in backend/records/db/records.db. Fields: record_id, label, detail, priority, status, list_file, added_by, added_at, completed_at. API actions: add_item, complete_item, update_item, get_item, list_items.
description
records.db list_items table — R001+ record IDs for all list items
▼ Show timestamps
created_at
2026-07-12 11:40:07
⊞ Full detail →
12
Master List Editor v2.0 — detail field, record IDs, DB logging
system: 02 Builder
ml-editor.html rebuilt with expandable detail per item, R001+ record IDs from DB, add_item logs to records.db, complete_item marks done with timestamp. Saves MD …
tap
⌂ Builder Hub →
id
12
system
02 Builder
date
07/12/26
subject
Master List Editor v2.0 — detail field, record IDs, DB logging
approved_by
USR369 David
se_id
—
tr_id
—
detail
ml-editor.html rebuilt with expandable detail per item, R001+ record IDs from DB, add_item logs to records.db, complete_item marks done with timestamp. Saves MD with Label — RXXX — Detail format.
description
Master List Editor v2.0 — detail field, record IDs, DB logging
▼ Show timestamps
created_at
2026-07-12 11:40:07
⊞ Full detail →
11
Standards Hub linked from backend nav
system: 02 Builder
Card added to backend/index.html (v6.2, orange). Tab added to backend/info/index.html bottom tabs.
tap
⌂ Builder Hub →
id
11
system
02 Builder
date
07/12/26
subject
Standards Hub linked from backend nav
approved_by
USR369 David
se_id
—
tr_id
—
detail
Card added to backend/index.html (v6.2, orange). Tab added to backend/info/index.html bottom tabs.
description
Standards Hub linked from backend nav
▼ Show timestamps
created_at
2026-07-12 10:22:16
⊞ Full detail →
10
standards_index pointer wired into OPEN/REFRESH/build.php
system: 02 Builder
All three command endpoints now return standards_index field with URL to STANDARDS-INDEX.md. Lightweight pointer only — no content injection.
tap
⌂ Builder Hub →
id
10
system
02 Builder
date
07/12/26
subject
standards_index pointer wired into OPEN/REFRESH/build.php
approved_by
USR369 David
se_id
—
tr_id
—
detail
All three command endpoints now return standards_index field with URL to STANDARDS-INDEX.md. Lightweight pointer only — no content injection.
description
standards_index pointer wired into OPEN/REFRESH/build.php
▼ Show timestamps
created_at
2026-07-12 10:22:16
⊞ Full detail →
9
STANDARDS-INDEX.md deployed as stop sign
system: 02 Builder
Machine-readable pointer at backend/standards/STANDARDS-INDEX.md — maps rule codes to URLs and build.php scope values. 12 sections, 4.7kb.
tap
⌂ Builder Hub →
id
9
system
02 Builder
date
07/12/26
subject
STANDARDS-INDEX.md deployed as stop sign
approved_by
USR369 David
se_id
—
tr_id
—
detail
Machine-readable pointer at backend/standards/STANDARDS-INDEX.md — maps rule codes to URLs and build.php scope values. 12 sections, 4.7kb.
description
STANDARDS-INDEX.md deployed as stop sign
▼ Show timestamps
created_at
2026-07-12 10:22:16
⊞ Full detail →
8
Standards Hub expanded to full rule set
system: 02 Builder
All 13 detail pages now have 5-10 rules each, up from skeleton 2-4. Categories: HTML/MD/System/PHP.
tap
⌂ Builder Hub →
id
8
system
02 Builder
date
07/12/26
subject
Standards Hub expanded to full rule set
approved_by
USR369 David
se_id
—
tr_id
—
detail
All 13 detail pages now have 5-10 rules each, up from skeleton 2-4. Categories: HTML/MD/System/PHP.
description
Standards Hub expanded to full rule set
▼ Show timestamps
created_at
2026-07-12 10:22:16
⊞ Full detail →
7
Standards Hub built — 17 pages
system: 02 Builder
Real branching pages at backend/standards/ (HTML/MD/System/PHP categories), standard card-button style reused from systems/hub/index.php, rollup format reserved …
tap
⌂ Builder Hub →
id
7
system
02 Builder
date
07/12/26
subject
Standards Hub built — 17 pages
approved_by
David
se_id
—
tr_id
—
detail
Real branching pages at backend/standards/ (HTML/MD/System/PHP categories), standard card-button style reused from systems/hub/index.php, rollup format reserved for in-page rule lists only per David direction.
description
Standards Hub built — 17 pages
▼ Show timestamps
created_at
2026-07-12 09:31:19
⊞ Full detail →
6
Gym Logger history-nav root cause found and fixed
system: 02 Builder
Two silent JS errors: field-name mismatch (timein/loc vs timeIn/location) between collectFormData and applyFormData, plus loadSessionIntoLog calling nonexistent …
tap
⌂ Builder Hub →
id
6
system
02 Builder
date
07/12/26
subject
Gym Logger history-nav root cause found and fixed
approved_by
David
se_id
—
tr_id
—
detail
Two silent JS errors: field-name mismatch (timein/loc vs timeIn/location) between collectFormData and applyFormData, plus loadSessionIntoLog calling nonexistent switchTab() function. Both fixed, v5.25 live.
description
Gym Logger history-nav root cause found and fixed
▼ Show timestamps
created_at
2026-07-12 09:31:19
⊞ Full detail →
5
D108 Multi-file output rule
system: 02 Builder
Any system generating multiple files must: (1) check current series letter, (2) increment to next letter for ALL systems, (3) ZIP all files into one package, (4 …
tap
⌂ Builder Hub →
id
5
system
02 Builder
date
—
subject
D108 Multi-file output rule
approved_by
USR369 David
se_id
—
tr_id
—
detail
Any system generating multiple files must: (1) check current series letter, (2) increment to next letter for ALL systems, (3) ZIP all files into one package, (4) drop ZIP in backend/369/ (David personal dropzone). Introduced in Series E EXEC_OPEN_Builder.20.E.txt 07/08/26.
description
D108 Multi-file output rule
▼ Show timestamps
created_at
2026-07-08 11:26:42
⊞ Full detail →
4
Timezone fix — PT across all system APIs
system: 02 Builder
Server TZ is UTC. Added date_default_timezone_set(America/Los_Angeles) to 10 system api.php files and dba_api.php. All DB timestamps now return PT (12-hour). Fi …
tap
⌂ Builder Hub →
id
4
system
02 Builder
date
07/07/26
subject
Timezone fix — PT across all system APIs
approved_by
USR369 David
se_id
—
tr_id
—
detail
Server TZ is UTC. Added date_default_timezone_set(America/Los_Angeles) to 10 system api.php files and dba_api.php. All DB timestamps now return PT (12-hour). Fixed 07/07/26.
description
Timezone fix — PT across all system APIs
▼ Show timestamps
created_at
2026-07-07 22:29:29
⊞ Full detail →
3
knowledge.md created — D091 compliance
system: 02 Builder
systems/20-builder/knowledge.md created 07/07/26. Environment, Patterns, Lessons, Open Questions populated. Written at session close per D091 mandatory rule.
tap
⌂ Builder Hub →
id
3
system
02 Builder
date
07/07/26
subject
knowledge.md created — D091 compliance
approved_by
USR369 David
se_id
—
tr_id
—
detail
systems/20-builder/knowledge.md created 07/07/26. Environment, Patterns, Lessons, Open Questions populated. Written at session close per D091 mandatory rule.
description
knowledge.md created — D091 compliance
▼ Show timestamps
created_at
2026-07-07 22:08:00
⊞ Full detail →
2
DB Admin v2.2 — perPage selector match highlighting
system: 02 Builder
Built perPage selector (25/50/100/All) and match highlighting into db-admin.html. Infinity-safe pagination. Resets to 50 on table switch. Deployed via bootstrap …
tap
⌂ Builder Hub →
id
2
system
02 Builder
date
07/07/26
subject
DB Admin v2.2 — perPage selector match highlighting
approved_by
USR369 David
se_id
—
tr_id
—
detail
Built perPage selector (25/50/100/All) and match highlighting into db-admin.html. Infinity-safe pagination. Resets to 50 on table switch. Deployed via bootstrap 07/07/26.
description
DB Admin v2.2 — perPage selector match highlighting
▼ Show timestamps
created_at
2026-07-07 22:07:59
⊞ Full detail →
1
Board v5.9 deployed
system: 02 Builder
Added DB Admin v2.2 and D091 knowledge.md as done tasks. Changelog updated. Deployed 07/07/26.
tap
⌂ Builder Hub →
id
1
system
02 Builder
date
07/07/26
subject
Board v5.9 deployed
approved_by
USR369 David
se_id
—
tr_id
—
detail
Added DB Admin v2.2 and D091 knowledge.md as done tasks. Changelog updated. Deployed 07/07/26.
description
Board v5.9 deployed
▼ Show timestamps
created_at
2026-07-07 22:07:59
⊞ Full detail →
Backend Domains Panel DB Viewer Transfers
Backend Tools DB Viewer DB Admin Server Map File Editor Backend Tools DB Viewer DB Admin Server Map File Editor