flag_rules: terminated_company

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
terminated_company Zrusena firma Dodavatel je zruseny/zaniknuty podla registra uctovnych zavierok (RUZ) danger z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE terminated_on IS NOT NULL AND cin IS NOT NULL) 0 1 2026-03-07 20:16:08

Links from other tables