Columns of Table KDR_PRAC_BADANIA
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_PRAC_BADANIA NUMBER Y   id
2 ID_PRAC NUMBER     id pracownika
3 ID_BADANIA NUMBER     id badania ze slownika
4 DATA_OD DATE     data od badania / data wykonania
5 DATA_DO DATE     data do (data waznosci dla badan z okresem waznsoci)
6 UWAGI VARCHAR2(200 BYTE)     uwagi

Indexes on Table KDR_PRAC_BADANIA
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_KDRPRACBADA_IDBADANIA NORMAL ID_BADANIA <none>        
UNIQUE PK_KDR_PRAC_BADANIA NORMAL ID_PRAC_BADANIA <none>        

Foreign Key Constraints on Table KDR_PRAC_BADANIA
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_PRAC_BADANIA_PRAC ID_PRAC F_54 KDR_PRAC ID_PRAC NO ACTION ENABLED No No
FK_KDR_PRAC_BADANIA_SL_BADANIA ID_BADANIA F_54 KDR_SL_BADANIA ID_BADANIA NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_PRAC_BADANIA
Constraint Name Type Condition Status Columns
PK_KDR_PRAC_BADANIA Primary Key   ENABLED ID_PRAC_BADANIA

Table KDR_PRAC_BADANIA does not have...
Comments
Partitions
Redaction Policies