Columns of Table MAG_ZAMOWIENIA_P_ROZKLADY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER(11) Y    
2 ILOSC NUMBER(10,3) Y    
3 MAGAZYN NUMBER(11) Y    
4 ZAMOWIENIE_POZYCJA NUMBER(11) Y    

Indexes on Table MAG_ZAMOWIENIA_P_ROZKLADY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_MAG_ZAM_P_ROZKLADY_MAG NORMAL MAGAZYN <none>        
NON-UNIQUE IDX_MAG_ZAM_P_ROZKLADY_ZAMPOZ NORMAL ZAMOWIENIE_POZYCJA <none>        
UNIQUE SYS_C0057744 NORMAL ID <none>        

Foreign Key Constraints on Table MAG_ZAMOWIENIA_P_ROZKLADY
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
SYS_C0059515 ZAMOWIENIE_POZYCJA F_54 MAG_ZAMOWIENIA_P ID NO ACTION ENABLED Yes Yes

PK, UK, & Check Constraints on Table MAG_ZAMOWIENIA_P_ROZKLADY
Constraint Name Type Condition Status Columns
SYS_C0055209 Check "ID" IS NOT NULL ENABLED ID
SYS_C0055210 Check "ILOSC" IS NOT NULL ENABLED ILOSC
SYS_C0055211 Check "MAGAZYN" IS NOT NULL ENABLED MAGAZYN
SYS_C0055212 Check "ZAMOWIENIE_POZYCJA" IS NOT NULL ENABLED ZAMOWIENIE_POZYCJA
SYS_C0057744 Primary Key   ENABLED ID

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