Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |
Trigger Name | Status | Validity | Type | Event | Base Object Type | Base Object |
---|---|---|---|---|---|---|
TRG_BANKI_P_ZALICZKI_FIN | ENABLED | Valid | AFTER EACH ROW | DELETE | Table | BANKI_P |
TRG_BANKI_P_ZAP_AU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | BANKI_P |
TRG_BANKI_P_ZAP_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | BANKI_P |
TRG_BANKI_P_ZAP_KLAS_AU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | BANKI_P |
TRG_BANKI_P_ZAP_KLAS_BD | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | BANKI_P |
TRG_BANKI_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | BANKI |
TRG_BANKI_ZAP_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | BANKI |
TRG_BANKI_ZAP_KLAS_AU | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | BANKI |
TRG_BR_BLOBY_0 | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | BR_BLOBY |
TRG_BUDZET_IMPEKS_BESTIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | BUDZET_IMPEKS_BESTIA |
TRG_CENNIK_ID_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CENNIK |
TRG_CRM_KLIENCI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_KLIENCI |
TRG_CRM_KLIENCI_OSOBY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_KLIENCI_OSOBY |
TRG_CRM_KOMENTARZE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_KOMENTARZE |
TRG_CRM_KONTAKTY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_KONTAKTY |
TRG_CRM_KONTAKTY_PLIKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_KONTAKTY_PLIKI |
TRG_CRM_KONTAKTY_TAGI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_KONTAKTY_TAGI |
TRG_CRM_OBSERWATORZY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | CRM_OBSERWATORZY |
TRG_DEK_ADRESY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_ADRESY |
TRG_DEK_DEC_HIST_TYPOW_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DECYZJE_HISTORIA_TYPOW |
TRG_DEK_DECYZJE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DECYZJE |
TRG_DEK_DECYZJE_POZYCJE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DECYZJE_POZYCJE |
TRG_DEK_DECYZJE_UP | ENABLED | Valid | AFTER EACH ROW | UPDATE | Table | DEK_DECYZJE |
TRG_DEK_DEKLARACJA_SEKCJE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DEKLARACJA_SEKCJE |
TRG_DEK_DEKLARACJE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DEKLARACJE |
TRG_DEK_DEKLARACJE_POZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DEKLARACJE_POZ |
TRG_DEK_DEKL_SEKCJE_POZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_DEKLARACJA_SEKCJE_POZ |
TRG_DEK_GOSPODARSTWA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_GOSPODARSTWA |
TRG_DEK_KDR_ID_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_KARTY_DUZEJ_RODZINY |
TRG_DEKLARACJE_STR_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKLARACJE_STR |
TRG_DEKL_KG_BIL_POZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKLARACJE_KG_BILANS_POZ |
TRG_DEKL_KONTA_WYL_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKLARACJE_KONTA_WYL |
TRG_DEK_MIESIACE_UZYTKOWANIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_MIESIACE_UZYTKOWANIA |
TRG_DEK_NAGL_HIST_DAT_KZU_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_NAGLOWKI_HISTORIA_DAT_KZU |
TRG_DEK_NAGL_NOTATKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_NAGLOWKI_NOTATKI |
TRG_DEK_NAGLOWKI_HISTORIA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_NAGLOWKI_HISTORIA |
TRG_DEK_NAGLOWKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_NAGLOWKI |
TRG_DEK_NAGLOWKI_LOG | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_NAGLOWKI_LOG |
TRG_DEK_OSOBY_REPREZENT_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_OSOBY_REPREZENTUJACE |
TRG_DEK_OSOBY_ZAMIESZKALE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_OSOBY_ZAMIESZKALE |
TRG_DEK_POJEMNIKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_POJEMNIKI |
TRG_DEKRETY2_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKRETY |
TRG_DEKRETY2_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DEKRETY |
TRG_DEKRETY_MAN_ID_AKT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEKRETY_MAN |
TRG_DEKRETY_MAN_ID_AKTYW_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DEKRETY_MAN |
TRG_DEK_SEKCJE_WART_DOMYS_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_SEKCJE_WART_DOMYS |
TRG_DEK_SPOSOBY_ODPROW_CIEK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_SPOSOBY_ODPROW_CIEK |
TRG_DEK_SPOSOBY_OGRZEWANIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_SPOSOBY_OGRZEWANIA |
TRG_DEK_SPOS_ZAGOS_BIO_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_SPOSOBY_ZAGOSPO_BIO |
TRG_DEK_TAGI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_TAGI |
TRG_DEK_TYPY_NIER_NZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_TYPY_NIERUCHOM_NIEZAM |
TRG_DEK_TYPY_NIER_Z_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_TYPY_NIERUCHOM_ZAM |
TRG_DEK_TYPY_OSWIAD_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_TYPY_OSWIADCZEN |
TRG_DEK_WYPELNIONE_SEKCJE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WYPELNIONE_SEKCJE |
TRG_DEK_WZORCE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE |
TRG_DEK_WZORCE_MAPER_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_MAPER |
TRG_DEK_WZORCE_MAPER_SKROT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DEK_WZORCE_MAPER |
TRG_DEK_WZORCE_PARAMETRY_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_PARAMETRY |
TRG_DEK_WZORCE_POZ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_POZ |
TRG_DEK_WZORCE_SL_MAPER_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_SL_MAPER |
TRG_DEK_WZORCE_SL_OGR_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_SL_OGRANICZONE |
TRG_DEK_WZORCE_SL_OGR_UPPER | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DEK_WZORCE_SL_OGRANICZONE |
TRG_DEK_WZORCE_SL_PARAMETRY_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_SL_PARAMETRY |
TRG_DEK_WZORCE_SL_WARTOSCI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_WZORCE_SL_WARTOSCI |
TRG_DEK_WZOR_SL_MAPER_SKROT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DEK_WZORCE_SL_MAPER |
TRG_DEK_ZALACZNIKI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DEK_ZALACZNIKI |
TRG_DOKUMENTY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DOKUMENTY |
TRG_DOWODY_P_UWAGI_INSERT_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DOWODY_P_UWAGI |
TRG_DOWODY_P_UWAGI_TRASA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DOWODY_P_UWAGI |
TRG_DW_DW_CZAS_ZMIANY_STATUSU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DW_DZIKIE_WYSYPISKA |
TRG_DW_DW_ID_DATA_UTW_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DW_DZIKIE_WYSYPISKA |
TRG_DW_DW_ID_STATUSU_AIU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | DW_DZIKIE_WYSYPISKA |
TRG_DW_SL_STATUSY_ID_STATUSU | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DW_SL_STATUSY |
TRG_DW_STATUSY_DW_HIST_ID_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DW_STATUSY_DZIKIE_WYSYP_HIST |
TRG_DW_ZADANIA_WERYF_ID_ZAD_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DW_ZADANIA_WERYFIKACJI |
TRG_DW_ZADWER_CZAS_ZM_STAT_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DW_ZADANIA_WERYFIKACJI |
TRG_DW_ZALACZNIKI_ID_ZALACZ_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DW_ZALACZNIKI |
TRG_DW_ZGLOSZ_CZAS_ZM_STAT_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | DW_ZGLOSZENIA |
TRG_DW_ZGLOSZ_ID_DATA_UTW_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | DW_ZGLOSZENIA |
TRG_EGOSOBADRE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_OSOBY_ADRESY |
TRG_EGOSOBDANE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_OSOBY_DANE |
TRG_EGOSOB_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_OSOBY |
TRG_EGOSOBRODZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_OSOBY_RODZAJ |
TRG_EG_OSOBY_ADRESY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_OSOBY_ADRESY |
TRG_EG_OSOBY_DANE_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_OSOBY_DANE |
TRG_EG_OSOBY_RODZAJ_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_OSOBY_RODZAJ |
TRG_EG_OSOBY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_OSOBY |
TRG_EGSLRETFPP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_SL_REJESTR_TYPFAK_PDST_PRAW |
TRG_EGSLRETFPP_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_SL_REJESTR_TYPFAK_PDST_PRAW |
TRG_EG_SL_RODZAJE_OSOBY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_SL_RODZAJE_OSOBY |
TRG_EGSLRODZOS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_SL_RODZAJE_OSOBY |
TRG_EGSLRONARPOP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_SL_RODZ_NAL_REF_PODST_PRAWN |
TRG_EGSLVARIA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_SL_VARIA |
TRG_EG_SL_VARIA_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_SL_VARIA |
TRG_EGTECZ_ID_EGTECZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TECZKI_TYTULOW |
TRG_EGTECZPOZY_ID_EGTECZPOZY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TECZKI_TYT_POZY |
TRG_EGTECZPOZY_NIERUSZ_WYEKSP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TECZKI_TYT_POZY |
TRG_EGTYTUAKPO_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_AKTU_POZY |
TRG_EGTYTUAKPOPRZY_ID_PRZY_ZM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | EG_TYTULY_AKTU_POZY_PRZYCZYNY |
TRG_EGTYTUAKPOPRZY_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | EG_TYTULY_AKTU_POZY_PRZYCZYNY |