Comment for Table KDR_RACHUNKI_SKLADN
Comment
Tabela łącząca dane rachunki pracownika z tabel kdr_skladn_typ, czyli tam gdzie ida wyplaty

Columns of Table KDR_RACHUNKI_SKLADN
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_RACHUNKI_SKLADN NUMBER Y   id_rachunki_skladn
2 ID_SKLADN_TYP NUMBER Y   Id skladnika w ktorym jest dana kwota majaca isc na rachunek
3 ID_PRAC_RACHUNKI NUMBER Y   id rachunku
4 ID_RACHUNKI_WAZNOSC NUMBER Y   Id do tabeli zawieracacej waznosc danych ustawien
5 PROC NUMBER     Procent wypłaty
6 KWOTA NUMBER     Kwota wypłaty

Indexes on Table KDR_RACHUNKI_SKLADN
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE IDX_KDR_RACHUNKI_SKLADN_UNIQ NORMAL ID_RACHUNKI_WAZNOSC, ID_PRAC_RACHUNKI, ID_SKLADN_TYP <none>        
UNIQUE IDX_KDR_RACHUNKI_SKLADN_UNIQ2 NORMAL ID_RACHUNKI_WAZNOSC, ID_PRAC_RACHUNKI <none>        
NON-UNIQUE IDX_PK_KDR_RACHUNKI_SKLADN NORMAL ID_RACHUNKI_SKLADN <none>        
NON-UNIQUE IX_KDRRACKISKL_IDPRACRACHUNKI NORMAL ID_PRAC_RACHUNKI <none>        
NON-UNIQUE IX_KDRRACKISKL_IDSKLADNTYP NORMAL ID_SKLADN_TYP <none>        

Foreign Key Constraints on Table KDR_RACHUNKI_SKLADN
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_RACHUNKI_SKLADN_PRAC ID_PRAC_RACHUNKI F_54 KDR_PRAC_RACHUNKI ID_RACHUNKU NO ACTION ENABLED No No
FK_KDR_RACHUNKI_SKLADN_TYP ID_SKLADN_TYP F_54 KDR_SKLADN_TYP ID_SKLADN_TYP NO ACTION ENABLED No No
FK_KDR_RACHUNKI_SKLADN_WAZ ID_RACHUNKI_WAZNOSC F_54 KDR_RACHUNKI_WAZNOSC ID_RACHUNKI_WAZNOSC NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_RACHUNKI_SKLADN
Constraint Name Type Condition Status Columns
SYS_C0055145 Check "ID_SKLADN_TYP" IS NOT NULL ENABLED ID_SKLADN_TYP
SYS_C0055146 Check "ID_PRAC_RACHUNKI" IS NOT NULL ENABLED ID_PRAC_RACHUNKI
SYS_C0055147 Check "ID_RACHUNKI_WAZNOSC" IS NOT NULL ENABLED ID_RACHUNKI_WAZNOSC
PK_KDR_RACHUNKI_SKLADN Primary Key   ENABLED ID_RACHUNKI_SKLADN
UQ_KDR_RACHUNKI_SKLADN_RW Unique   ENABLED ID_RACHUNKI_WAZNOSC, ID_PRAC_RACHUNKI
UQ_KDR_RACHUNKI_SKLADN_RWS Unique   ENABLED ID_RACHUNKI_WAZNOSC, ID_PRAC_RACHUNKI, ID_SKLADN_TYP

Table KDR_RACHUNKI_SKLADN does not have...
Partitions
Redaction Policies