Comment for Table KDR_PRAC_PARAM
Comment
Cechy pracowników

Columns of Table KDR_PRAC_PARAM
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_PRAC_PARAM NUMBER Y   ID
2 ID_PRAC NUMBER     ID pracownika
3 ID_PARAM_TYP NUMBER     ID typu cechy
4 ID_PARAM_WARTOSCI NUMBER     Id parametru wartosci z Kdr_PARAM_WARTOSCI
5 WARTOSC_RECZNIE NUMBER     Wartosc wprowadzona recznie. Jesli wybrana jest wartosc z tabeli kdr_param_wartosc, to bierze i tak wartos wprowadzona recznie do wyliczen.
6 WAZNY_OD DATE     Od kiedy wazny parametr.
7 WAZNY_DO DATE     Do kiedy wazny parametr.

Indexes on Table KDR_PRAC_PARAM
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_KDR_PRAC_CECHY_PK NORMAL ID_PRAC_PARAM <none>        
NON-UNIQUE IX_KDRPRARACPA_IDPARAMTYP NORMAL ID_PARAM_TYP <none>        
NON-UNIQUE IX_KDRPRARACPA_IDPARAMWARTOSC NORMAL ID_PARAM_WARTOSCI <none>        

Foreign Key Constraints on Table KDR_PRAC_PARAM
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_PRAC_PARAM_PARAM_TYP ID_PARAM_TYP F_54 KDR_PARAM_TYP ID_PARAM_TYP NO ACTION ENABLED No No
FK_KDR_PRAC_PARAM_PARAM_WART ID_PARAM_WARTOSCI F_54 KDR_PARAM_WARTOSCI ID_PARAM_WARTOSCI NO ACTION ENABLED No No
FK_KDR_PRAC_PARAM_PRAC ID_PRAC F_54 KDR_PRAC ID_PRAC NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_PRAC_PARAM
Constraint Name Type Condition Status Columns
CH_KDR_PRAC_PARAM Check ID_PARAM_WARTOSCI IS NOT NULL OR WARTOSC_RECZNIE IS NOT NULL ENABLED ID_PARAM_WARTOSCI, WARTOSC_RECZNIE
NN_KDR_PRAC_PARAM_ID Check "ID_PRAC_PARAM" IS NOT NULL ENABLED ID_PRAC_PARAM
PK_KDR_PRAC_CECHY Primary Key   ENABLED ID_PRAC_PARAM

Table KDR_PRAC_PARAM does not have...
Partitions
Redaction Policies