Columns of Table PRAC_PZATR
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_PRAC NUMBER(8)      
2 NAZWA VARCHAR2(60 BYTE)      
3 ZATR_OD DATE      
4 ZATR_DO DATE      
5 ID_STAN NUMBER(8)      
6 CZY_STAZ CHAR(1 BYTE)      
7 CZY_JUBI CHAR(1 BYTE)      
8 CZY_EMER CHAR(1 BYTE)      
9 ID_ETATU NUMBER(8)      
10 ID_PROZW NUMBER(8)      
11 CZY_URLOP CHAR(1 BYTE)      
12 STAWKA NUMBER      
13 CZY_ODPR CHAR(1 BYTE)      
14 ID_PZATR NUMBER Y    

Indexes on Table PRAC_PZATR
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX1_PRACPZATR NORMAL ID_PRAC <none>        
NON-UNIQUE IX_PRACPZRACPZ_IDETATU NORMAL ID_ETATU <none>        
NON-UNIQUE IX_PRACPZRACPZ_IDPROZW NORMAL ID_PROZW <none>        
NON-UNIQUE IX_PRACPZRACPZ_IDSTAN NORMAL ID_STAN <none>        
UNIQUE PRAC_PZATR_PK NORMAL ID_PZATR <none>        

Foreign Key Constraints on Table PRAC_PZATR
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_PRACPZATR_PRACOWNICY ID_PRAC F_54 PRACOWNICY ID_PRAC NO ACTION ENABLED No No
FK_PRACPZATR_SLETATY ID_ETATU F_54 SL_ETATY ID_ETATU NO ACTION ENABLED No No
FK_PRACPZATR_SLPROZUM ID_PROZW F_54 SL_PROZUM ID_PROZW NO ACTION ENABLED No No
FK_PRACPZATR_SLSTANOWISKA ID_STAN F_54 SL_STANOWISKA ID_STAN NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table PRAC_PZATR
Constraint Name Type Condition Status Columns
SYS_C0054783 Check "ID_PZATR" IS NOT NULL ENABLED ID_PZATR
PRAC_PZATR_PK Primary Key   ENABLED ID_PZATR

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