flag_rules: dodatok_price_inflation

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
dodatok_price_inflation Navysenie ceny dodatkami Celkova suma zmluvy je o viac ako 50% vyssia nez povodna suma a navysenie presahuje 50 000 EUR warning z.suma_celkom IS NOT NULL AND z.suma IS NOT NULL AND z.suma > 0 AND z.suma_celkom > z.suma * 1.5 AND (z.suma_celkom - z.suma) > 50000 0 1 2026-03-07 20:38:29

Links from other tables