flag_rules: not_in_ruz

Definicie pravidiel pre cervene vlajky (red flags). Kazde pravidlo obsahuje SQL podmienku, ktora sa vyhodnocuje voci zmluvam. Nove pravidla je mozne pridat cez CLI alebo priamo do tabulky.

This data as json

id	label	description	severity	sql_condition	needs_extraction	enabled	created_at
not_in_ruz	Dodavatel nie je v RUZ	Dodavatel s ICO nie je evidovany v registri uctovnych zavierok	info	z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND length(z.dodavatel_ico) = 8 AND z.dodavatel_ico NOT IN (SELECT cin FROM ruz_entities WHERE cin IS NOT NULL)	0	1	2026-03-07 20:16:08

Links from other tables

30,360 rows from flag_type in red_flags