flag_rules: micro_supplier_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
micro_supplier_large_contract Mikro dodavatel, velka zmluva Dodavatel ma 0-1 zamestnancov podla RUZ, ale zmluva presahuje 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 organization_size_id IN (1, 2) AND cin IS NOT NULL AND terminated_on IS NULL) 0 1 2026-03-07 20:16:08

Links from other tables