Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FAKTURY_KLASYFIKACJA_HISTORIA | Next Table |
Comment |
---|
Tabela historii klasyfikacji budżetowej dla faktur |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | PK kopiowane z tabeli faktury_klasyfikacja | |
2 | KWOTA | NUMBER | Kwota wpłaty | ||
3 | DATA_MOD | DATE | data modyfikacji | ||
4 | OPERATOR | VARCHAR2(30 BYTE) | operator modyfikujący | ||
5 | ID_FAK | NUMBER | Y | FK do id_fak z faktur | |
6 | ID_DOWODU | NUMBER | |||
7 | ID_POZ_DOW | NUMBER | |||
8 | KL_DZIAL | NUMBER | Y | FK do id dzialu ze slownika dzialów | |
9 | KL_ROZDZIAL | NUMBER | FK do id rozdzialu ze slownika rozdzialów | ||
10 | KL_PARAGRAF | NUMBER | FK do id paragrafu ze slownika paragrafów | ||
11 | KL_ZADANIE | NUMBER | FK do id zadania ze slownika zadan | ||
12 | KL_ZRODLO | NUMBER | FK do id zadania ze slownika źródel | ||
13 | DATA_HIST | DATE | data dodania do histori | ||
14 | OPERATOR_HIST | VARCHAR2(30 BYTE) | operator dodający do histori | ||
15 | ID_REJ_UMOW_KLAS | NUMBER | Fk do REJESTR_UMOW_KLASYFIKACJA |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_FAKKL_IDREJUMOWKLAS | NORMAL | ID_REJ_UMOW_KLAS | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_IDDOWODUIDPOZ | NORMAL | ID_DOWODU, ID_POZ_DOW | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_IDFAK | NORMAL | ID_FAK | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_KLDZIAL | NORMAL | KL_DZIAL | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_KLPARAGRAF | NORMAL | KL_PARAGRAF | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_KLROZDZIAL | NORMAL | KL_ROZDZIAL | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_KLZADANIE | NORMAL | KL_ZADANIE | <none> | ||||
NON-UNIQUE | IX_FAKTURHISTO_KLZRODLO | NORMAL | KL_ZRODLO | <none> | ||||
UNIQUE | PK_FAKTURY_KLASYFIKACJA_HIST | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_FAK_KLAS_HIST_FAKTURY | ID_FAK | F_54 | FAKTURY | ID_FAK | NO ACTION | ENABLED | No | No |
FK_FAK_KLAS_HIST_MAG_DOWODY_P | ID_DOWODU, ID_POZ_DOW | F_54 | MAG_DOWODY_P | ID_DOWODU,ID_POZ | NO ACTION | ENABLED | No | No |
FK_FAK_KLAS_HIST_SL_KL_DZIALY | KL_DZIAL | F_54 | SL_KL_DZIALY | ID | NO ACTION | ENABLED | No | No |
FK_FAK_KLAS_HIST_SL_KL_PARAGR | KL_PARAGRAF | F_54 | SL_KL_PARAGRAFY | ID | NO ACTION | ENABLED | No | No |
FK_FAK_KLAS_HIST_SL_KL_ROZDZI | KL_ROZDZIAL | F_54 | SL_KL_ROZDZIALY | ID | NO ACTION | ENABLED | No | No |
FK_FAK_KLAS_HIST_SL_KL_ZADANIE | KL_ZADANIE | F_54 | SL_KL_ZADANIA | ID | NO ACTION | ENABLED | No | No |
FK_FAK_KLAS_HIST_SL_KL_ZRODLA | KL_ZRODLO | F_54 | SL_KL_ZRODLA | ID | NO ACTION | ENABLED | No | No |
FK_FAKTURY_KLAS_HI_RU_KLAS | ID_REJ_UMOW_KLAS | F_54 | REJESTR_UMOW_KLASYFIKACJA | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0055375 | Check | "ID" IS NOT NULL | ENABLED | ID |
SYS_C0055376 | Check | "ID_FAK" IS NOT NULL | ENABLED | ID_FAK |
SYS_C0055377 | Check | "KL_DZIAL" IS NOT NULL | ENABLED | KL_DZIAL |
PK_FAKTURY_KLASYFIKACJA_HIST | Primary Key | ENABLED | ID |
Partitions |
Redaction Policies |