Comment for Table KDR_HARM_DNI
Comment
Harmonogram z dniami. Harmonogramy z tej tabeli przypisuje sie do harmonogramow pracownikow.

Columns of Table KDR_HARM_DNI
Column ID Column Name Datatype Not Null Data Default Comments
1 DATA1 DATE Y   Dzień
2 ID_HARM2 NUMBER Y   ID harmonogramu
3 ID_ZMIANY3 NUMBER Y   ID zmiany
4 UWAGI VARCHAR2(250 BYTE)     Uwagi

Indexes on Table KDR_HARM_DNI
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_KDR_HARM_DNI_DATA NORMAL ID_HARM, DATA, ID_ZMIANY <none>        
NON-UNIQUE IDX_KDR_HARM_DNI_PK NORMAL DATA, ID_HARM, ID_ZMIANY <none>        
NON-UNIQUE IX_KDRHARRHARM_IDZMIANY NORMAL ID_ZMIANY <none>        

Foreign Key Constraints on Table KDR_HARM_DNI
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_HARM_DNI_HARM ID_HARM F_54 KDR_HARM ID_HARM NO ACTION ENABLED No No
FK_KDR_HARM_DNI_ZMIANY ID_ZMIANY F_54 KDR_ZMIANY ID_ZMIANY NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_HARM_DNI
Constraint Name Type Condition Status Columns
NN_KDR_HARM_DNI_DATA Check "DATA" IS NOT NULL ENABLED DATA
NN_KDR_HARM_DNI_ID_HARM Check "ID_HARM" IS NOT NULL ENABLED ID_HARM
NN_KDR_HARM_DNI_ID_ZMIANY Check "ID_ZMIANY" IS NOT NULL ENABLED ID_ZMIANY
PK_KDR_HARM_DNI Primary Key   ENABLED DATA, ID_HARM, ID_ZMIANY

Table KDR_HARM_DNI does not have...
Partitions
Redaction Policies