Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table ZALICZKI_FIN | Next Table |
Comment |
---|
Finanse, tabela z zaplatami podpietymi pod zaliczki |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_ZA | NUMBER(8) | Id zaliczki z tabeli ZALICZKI | ||
2 | TYP_ZAPLATY | CHAR(1 BYTE) | Typ zaplaty, K <- Kasa, B <- Bank, Z <- Zaliczka | ||
3 | ID_ZAPLATY | NUMBER(8) | Id zaplaty z tabeli RKASY_P, BANKI_P lub ZALICZKI | ||
4 | WARTOSC | NUMBER(12,2) | Wartosc | ||
5 | WARTOSC_WAL | NUMBER(12,2) | Wartosc walutowa | ||
6 | RODZAJ | CHAR(1 BYTE) | Rodzaj W <- Wyplata, R <- Rozliczenie, P<- Przeniesienie | ||
7 | KIERUNEK | CHAR(1 BYTE) | Kierunek P <- Przychod, R <- Rozchod | ||
8 | WALUTA | VARCHAR2(3 BYTE) | Waluta |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX1_ZALICZKIFIN | NORMAL | ID_ZA | <none> | ||||
NON-UNIQUE | IX_ZALICZICZKI_WALUTA | NORMAL | WALUTA | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_ZALICZKIFIN_WAL | WALUTA | F_54 | SL_WALUTY | WALUTA | NO ACTION | ENABLED | No | No |
FK_ZALICZKIFIN_ZALICZKI | ID_ZA | F_54 | ZALICZKI | ID_ZA | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
CH_ZALICZKI_FIN_KIER | Check | "KIERUNEK" IN ('P', 'R') | ENABLED | KIERUNEK |
CH_ZALICZKI_FIN_RODZAJ | Check | "RODZAJ" IN ('W', 'R', 'P') | ENABLED | RODZAJ |
NN_ZALICZKIFIN_IDZAPLATY | Check | "ID_ZAPLATY" IS NOT NULL | ENABLED | ID_ZAPLATY |
NN_ZALICZKIFIN_KIERUNEK | Check | "KIERUNEK" IS NOT NULL | ENABLED | KIERUNEK |
NN_ZALICZKIFIN_RODZAJ | Check | "RODZAJ" IS NOT NULL | ENABLED | RODZAJ |
NN_ZALICZKIFIN_TYPZAPLATY | Check | "TYP_ZAPLATY" IS NOT NULL | ENABLED | TYP_ZAPLATY |
Partitions |
Redaction Policies |