Skip to content

Instantly share code, notes, and snippets.

View mitselek's full-sized avatar

Mihkel Putrinš mitselek

View GitHub Profile

T66TAJAD + KONTAKTANDMED -- Deep Dive

Queried 2026-06-26 from Oracle DEV (vjsdbtest.evr.ee)

1. The 2,079 "contact records" -- orphan client contacts

Not a person at all. The top entry by contact count has T66TAJA_T66TAJA_ID = NULL -- these are client/company contacts (KLIENT_KOOD4), not employee records.

Liik Count

T66TAJAD + KONTAKTANDMED -- Quantitative Analysis

Queried 2026-06-26 from Oracle DEV (vjsdbtest.evr.ee)

1. T66TAJAD population by status

Status Count Meaning
A 1,087 Active
B 2,170 Blocked

T66TAJAD + KONTAKTANDMED — Mihkel Putrinsh account investigation

Queried 2026-06-26 from Oracle DEV (vjsdbtest.evr.ee)

Query 1: T66TAJAD entries

SELECT t66taja_id, kasutajanimi, eesnimi, perekonnanimi, jaam_kood5, 
       staatus, ametinimetus, ka_admin, ka_vaataja, la_admin,
 blok_alates, blok_kuni, blokeerija, blokeerimise_kuupxev

Delo image options for stakeholders page

Free stock photos matching the Soviet-era dossier ("дело") aesthetic. For future use if CSS-only approach needs a real photo.

Best match

Search pages (browse for alternatives)

ARUANDED + ARUANDED_DO1 — Full Schema (Oracle DEV)

Queried 2026-06-19 from Oracle DEV. Source of truth for DO-1 migration spec.

ARUANDED (parent — daily report header)

PK: ARUANNE_PK on ARUANNE_ID FK: ARUANNE_JAAM_FKJAAMAD.KOOD5

| # | Column | Type | Nullable | Default | Notes |

WP5.14 ERA Document — Review & De-speculation Instructions

Run this in your Claude Code CLI session from the Eesti-Raudtee/Arhitecture repo (where the review-panel agent prompts and arch-docs MCP live).

What to review

The ERA-audience resynthesis of WP5.14 VJS2 IT Architecture Report:

VJS Logout Bookmarklet

The VJS legacy system (algus$.startup) uses HTTP Basic Auth via the nvagun DAD — which has no sign-out button. Clearing cookies doesn't help because Basic Auth credentials are cached in browser memory, not cookies.

This bookmarklet forces the browser to forget the cached credentials.

Install

Copy this code and create a bookmarklet in your browser's bookmarks bar:

Entu Sharing Model — Foundation Draft

Working document. Goal: clear, example-driven reference for how _sharing works across Entu's three entity tiers. Grounded in official docs (entu/www) and API source (entu/api).

1. Foundation: Everything Is an Entity

Entu has one building block: the entity. What distinguishes entities is their role in a three-tier hierarchy:

Tier Official term What it is Example
@mitselek
mitselek / hr-devs-ghost-bridge-setup.md
Created June 8, 2026 14:23
Ghost-bridge setup instructions for hr-devs team-lead

Ghost-bridge setup — hr-devs side

From: framework-research team (Aeneas / Mihkel) Purpose: Establish a bidirectional comms bridge between framework-research (FR) and hr-devs teams via the ghost-bridge daemon.

How it works

The ghost-bridge daemon polls inbox files over SSH every 2 seconds. Each team has a "ghost member" — a comm endpoint with no running agent. When FR's team-lead calls SendMessage(to="hr-devs-lead-ghost"), the daemon picks it up and SSH-appends it to your team-lead inbox. And vice versa.

The bridge runs on the FR side (Windows dev machine → SSH to dev@100.96.54.170:22).

@mitselek
mitselek / tmp-anderson-persona.md
Last active June 3, 2026 06:42
Ross Anderson — Security Architecture & Compliance Reviewer persona (Celes design for EVR architecture review team)

Ross Anderson — Security Architecture & Compliance Reviewer persona (Celes design for EVR architecture review team)

Ross Anderson — Security Architecture & Compliance Reviewer

You are Ross Anderson, the Security Architecture & Compliance lens in the EVR IT Architecture Review Team.

Historical Lore

Origin