t66tajad-kontaktandmed-mihkel.md

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
FROM t66tajad 
WHERE UPPER(perekonnanimi) LIKE '%PUTRIN%'
ORDER BY t66taja_id

Results

T66TAJA_ID	KASUTAJANIMI	PEREKONNANIMI	STAATUS	AMETINIMETUS	JAAM	KA_ADMIN	KA_VAATAJA	LA_ADMIN	BLOK_ALATES	BLOK_KUNI	BLOKEERIJA
3759	(NULL)	Putrinsh	A	Administraator	99999	E	E	E	—	—	—
3761	T_MIHKEL_PUTRINSH	Putrinsh	A	Statistikagrupi töötaja	99999	J	J	J	—	2026-06-25	—
3783	MIHKEL_PUTRINSH	Putrinš	K	full-stack arendaja	99999	E	E	E	—	—	—
3794	A777666	Putrinsh	B	Statistikagrupi töötaja	99999	J	J	J	2026-06-11	—	ANNA

Status codes: A = active, B = blocked, K = kustutatud (deleted)

Note: MIHKEL_PUTRINSH (3783) has perekonnanimi = 'Putrinš' (with š) while the others have 'Putrinsh' (ASCII). This caused it to be missed with LIKE '%PUTRINSH%' -- only caught with LIKE '%PUTRIN%'.

Observations

• T_MIHKEL_PUTRINSH (3761) -- our DB research account. Active but BLOK_KUNI = 2026-06-25 (expired). Has KA/LA admin rights. Role: "Statistikagrupi töötaja" (statistics group worker).
• MIHKEL_PUTRINSH (3783) -- real EVR identity. Status K (deleted). Role: "full-stack arendaja". No admin flags. Note: š vs sh in surname.
• A777666 (3794) -- previous test account. Blocked by ANNA (Anna Voronina) on 2026-06-11 15:14. Same admin rights as T_MIHKEL_PUTRINSH.
• NULL username (3759) -- ghost entry. Active, "Administraator" role, no login possible (no username). Same person (Putrinsh).

---

Query 2: KONTAKTANDMED (joined)

SELECT k.kontakt_id, k.liik, k.andmed, k.t66taja_t66taja_id,
       t.kasutajanimi, t.staatus
FROM kontaktandmed k
JOIN t66tajad t ON k.t66taja_t66taja_id = t.t66taja_id
WHERE k.t66taja_t66taja_id IN (3759, 3761, 3783, 3794)
ORDER BY k.t66taja_t66taja_id, k.liik

Results

T66TAJA_ID	KASUTAJANIMI	LIIK	ANDMED
3759	(NULL)	e-mail	mihkel.putrinsh@evr.ee
3761	T_MIHKEL_PUTRINSH	e-mail	mihkel.putrinsh@evr.ee
3783	MIHKEL_PUTRINSH	e-mail	mihkel.putrinsh@evr.ee
3794	A777666	—	(no contact record)

Summary

Four T66TAJAD rows for one person. Three have contact records (same email). The real identity (MIHKEL_PUTRINSH) is deleted with š in surname, active work happens through a test account (T_MIHKEL_PUTRINSH) with a statistician role that expired 2026-06-25. Previous test account (A777666) was blocked by Anna Voronina. A ghost entry with NULL username exists with admin role but cannot log in.

(AR:Schliemann -- queried 2026-06-26)