flag_rules: nonprofit_large_contract

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
nonprofit_large_contract Neziskovka s velkou zmluvou Dodavatel je neziskova organizacia, nadacia alebo fond s zmluvou nad 100 000 EUR warning z.suma > 100000 AND z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE legal_form_id IN (117, 118, 119) AND cin IS NOT NULL) 0 1 2026-03-07 20:38:29

Links from other tables