Columns of Table MAG_ZAMOWIENIA_P
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER(11) Y    
2 ILOSC NUMBER(10,3) Y    
3 ILOSC_ZAAKCEPTOWANA NUMBER(10,3)      
4 CENA_NETTO NUMBER(12,2) Y    
5 CENA_NETTO_ZAAKCEPTOWANA NUMBER(12,2)      
6 NAZWA_KIT VARCHAR2(300 BYTE)      
7 ZAMOWIENIE NUMBER(11) Y    
8 NR_KATAL NUMBER(11) Y    
9 WYMAGANA VARCHAR2(1 CHAR) Y 'T'  
10 PR_VAT NUMBER(4,2) Y    

Indexes on Table MAG_ZAMOWIENIA_P
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_MAGZAMOWIEN_ZAMOWIENIE NORMAL ZAMOWIENIE <none>        
UNIQUE SYS_C0057741 NORMAL ID <none>        

Foreign Key Constraints on Table MAG_ZAMOWIENIA_P
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
SYS_C0059514 ZAMOWIENIE F_54 MAG_ZAMOWIENIA ID NO ACTION ENABLED Yes Yes

PK, UK, & Check Constraints on Table MAG_ZAMOWIENIA_P
Constraint Name Type Condition Status Columns
CHK_MAG_ZAMOWIENIA_P_WYMAGANA Check WYMAGANA IN ('T', 'N') ENABLED WYMAGANA
SYS_C0055199 Check "ID" IS NOT NULL ENABLED ID
SYS_C0055200 Check "ILOSC" IS NOT NULL ENABLED ILOSC
SYS_C0055201 Check "CENA_NETTO" IS NOT NULL ENABLED CENA_NETTO
SYS_C0055202 Check "ZAMOWIENIE" IS NOT NULL ENABLED ZAMOWIENIE
SYS_C0055203 Check "NR_KATAL" IS NOT NULL ENABLED NR_KATAL
SYS_C0055204 Check "WYMAGANA" IS NOT NULL ENABLED WYMAGANA
SYS_C0055205 Check "PR_VAT" IS NOT NULL ENABLED PR_VAT
SYS_C0057741 Primary Key   ENABLED ID

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