Columns of Table PRAC_ANGAZE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_ANGAZU NUMBER(8) Y    
2 ID_UMOWY NUMBER(8)      
3 ID_PRAC NUMBER(8)      
4 DT_ANGAZU DATE      
5 ID_STORG NUMBER(8)      
6 ID_STAN NUMBER(8)      
7 KAT_ZASZ VARCHAR2(10 BYTE)      
8 STAWKA NUMBER(14,2)      
9 PREMIA NUMBER(14,2)      
10 PR_PREMII NUMBER(5,2)      
11 D_FUNKC NUMBER(14,2)      
12 KOD_SYSPL CHAR(1 BYTE)      
13 CZY_STROBOT CHAR(1 BYTE)      
14 CZY_PRNAKLA CHAR(1 BYTE)      
15 ROK_NAUKI NUMBER(1)      

Indexes on Table PRAC_ANGAZE
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX1_PRACANGAZE NORMAL ID_UMOWY <none>        
NON-UNIQUE IX2_PRACANGAZE NORMAL ID_PRAC <none>        
NON-UNIQUE IX_PRACANACANG_IDSTAN NORMAL ID_STAN <none>        
NON-UNIQUE IX_PRACANACANG_IDSTORG NORMAL ID_STORG <none>        
NON-UNIQUE IX_PRACANACANG_KODSYSPL NORMAL KOD_SYSPL <none>        
UNIQUE PK_PRACANGAZE NORMAL ID_ANGAZU <none>        

Foreign Key Constraints on Table PRAC_ANGAZE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_PRACANGAZE_PRACETATY ID_UMOWY F_54 PRAC_ETATY ID_UMOWY NO ACTION ENABLED No No
FK_PRACANGAZE_PRACOWNICY ID_PRAC F_54 PRACOWNICY ID_PRAC NO ACTION ENABLED No No
FK_PRACUMOWY_SLKODPLAC KOD_SYSPL F_54 SL_SYSPLAC KOD_SYSPL NO ACTION ENABLED No No
FK_PRACUMOWY_SLSTANOWISKA ID_STAN F_54 SL_STANOWISKA ID_STAN NO ACTION ENABLED No No
FK_PRACUMOWY_STRUFIRMY ID_STORG F_54 STRUKTURA_FIRMY ID_STORG NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table PRAC_ANGAZE
Constraint Name Type Condition Status Columns
PK_PRACANGAZE Primary Key   ENABLED ID_ANGAZU

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