Comment for Table KDR_KARTY
Comment
Karty pracy

Columns of Table KDR_KARTY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_KARTY NUMBER Y   ID
2 ID_UMOWY NUMBER Y   ID umowy pracownika
3 ID_ZLEC NUMBER     ID zlecenia
4 OD DATE     Obowiązuje od (data, godzina)
5 DO DATE     Obowiązuje do (data, godzina)
6 ID_KODY NUMBER Y   ID kodu karty pracy

Indexes on Table KDR_KARTY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_KDR_KARTY1 NORMAL ID_UMOWY, OD, DO <none>        
NON-UNIQUE IDX_KDR_KARTY2 NORMAL ID_UMOWY, ID_KODY, OD, DO <none>        
NON-UNIQUE IDX_KDR_KARTY_PK NORMAL ID_KARTY <none>        
NON-UNIQUE IDX_KDR_KARTY_UMOWY NORMAL ID_UMOWY <none>        
NON-UNIQUE IX_KDRKARKDRKA_IDKODY NORMAL ID_KODY <none>        
NON-UNIQUE IX_KDRKARKDRKA_IDZLEC NORMAL ID_ZLEC <none>        

Foreign Key Constraints on Table KDR_KARTY
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_KARTY_KODY ID_KODY F_54 KDR_KODY ID_KODY NO ACTION ENABLED No No
FK_KDR_KARTY_UMOWY ID_UMOWY F_54 KDR_UMOWY ID_UMOWY NO ACTION ENABLED No No
FK_KDR_KARTY_ZLEC ID_ZLEC F_54 ZLECENIA_WEW ID_ZLECENIA NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_KARTY
Constraint Name Type Condition Status Columns
NN_KDR_KARTY_ID_KARTY Check "ID_KARTY" IS NOT NULL ENABLED ID_KARTY
NN_KDR_KARTY_ID_KODY Check "ID_KODY" IS NOT NULL ENABLED ID_KODY
NN_KDR_KARTY_ID_UMOWY Check "ID_UMOWY" IS NOT NULL ENABLED ID_UMOWY
PK_KDR_KARTY Primary Key   ENABLED ID_KARTY

Table KDR_KARTY does not have...
Partitions
Redaction Policies