Columns of Table KDR_PRAC_AKTA_OSOBOWE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y    
2 ID_PRAC NUMBER Y    
3 ID_KDR_SL_AKTA_OSOBOWE NUMBER Y    
4 OPIS VARCHAR2(4000 BYTE) Y    
5 DATA_OD DATE      
6 DATA_DO DATE      
7 DATA_DOKUMENTU DATE      
8 DATA_DODANIA DATE Y sysdate  
9 UZYTKOWNIK VARCHAR2(50 BYTE) Y user  

Indexes on Table KDR_PRAC_AKTA_OSOBOWE
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE PK_KDR_PRAC_AKTA_OSOBOWE NORMAL ID <none>        

Foreign Key Constraints on Table KDR_PRAC_AKTA_OSOBOWE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_PRAC_AKTA_ID_PRAC ID_PRAC F_54 KDR_PRAC ID_PRAC NO ACTION ENABLED No No
FK_KDR_PRAC_AKTA_ID_SL ID_KDR_SL_AKTA_OSOBOWE F_54 KDR_SL_AKTA_OSOBOWE ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_PRAC_AKTA_OSOBOWE
Constraint Name Type Condition Status Columns
NN_KDR_PRAC_AKTA_OSOB_OPIS Check "OPIS" IS NOT NULL ENABLED OPIS
NN_KDR_PRAC_AKT_OSOB_DATA_DOD Check "DATA_DODANIA" IS NOT NULL ENABLED DATA_DODANIA
NN_KDR_PRAC_AKT_OSOB_ID_PRAC Check "ID_PRAC" IS NOT NULL ENABLED ID_PRAC
NN_KDR_PRAC_AKT_OSOB_ID_SL Check "ID_KDR_SL_AKTA_OSOBOWE" IS NOT NULL ENABLED ID_KDR_SL_AKTA_OSOBOWE
NN_KDR_PRAC_AKT_OSOB_UZYTK Check "UZYTKOWNIK" IS NOT NULL ENABLED UZYTKOWNIK
PK_KDR_PRAC_AKTA_OSOBOWE Primary Key   ENABLED ID

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