Columns of Table FAKTURY_OKRESOWE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_FAK NUMBER(8) Y    
2 ID_UMOWY NUMBER(8)      
3 NR_KONTR NUMBER(6)      
4 MC_OD DATE      
5 MC_DO DATE      
6 OPER VARCHAR2(30 BYTE)      
7 DATA_WYG DATE      
8 SKORYGOWANA CHAR(1 BYTE)   'N'  

Indexes on Table FAKTURY_OKRESOWE
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE IX1_FAKTURYOKRESOWE NORMAL NR_KONTR, ID_UMOWY, MC_OD, ID_FAK <none>        
UNIQUE IX2_FAKTURYOKRESOWE NORMAL ID_FAK <none>        

Foreign Key Constraints on Table FAKTURY_OKRESOWE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_FAKTURYOKRESOWE_FAKTURY ID_FAK F_54 FAKTURY ID_FAK NO ACTION ENABLED No No
FK_FAKTURYOKRESOWE_KDO NR_KONTR F_54 KDO_WEW NR_KONTR NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table FAKTURY_OKRESOWE
Constraint Name Type Condition Status Columns
SYS_C0054590 Check "ID_FAK" IS NOT NULL ENABLED ID_FAK

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