flag_rules: fresh_micro_large

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
fresh_micro_large Nova mikro firma, velka zmluva Dodavatel bol zalozeny menej ako 1 rok pred podpisom, ma 0-1 zamestnancov a zmluva je nad 50 000 EUR danger z.suma > 50000 AND z.id IN (SELECT zmluva_id FROM red_flags WHERE flag_type = 'fresh_company') 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:38:29

Links from other tables