Columns of Table PALIWO_OT
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_OT NUMBER(9) Y    
2 ID_ZLECENIA NUMBER(8) Y    
3 DATA DATE Y    
4 ID_TYPU_OT NUMBER(7) Y    
5 STAN_LICZNIKA NUMBER(13,2)      
6 ID_JEDNOSTKI NUMBER(6) Y    

Indexes on Table PALIWO_OT
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_PALIWOPALIW_IDJEDNOSTKI NORMAL ID_JEDNOSTKI <none>        
NON-UNIQUE IX_PALIWOPALIW_IDTYPUOT NORMAL ID_TYPU_OT <none>        
NON-UNIQUE IX_PALIWOPALIW_IDZLECENIA NORMAL ID_ZLECENIA <none>        
UNIQUE PALIWO_OT_PK NORMAL ID_OT <none>        

Foreign Key Constraints on Table PALIWO_OT
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_PALIWO_OT_SL_OT ID_TYPU_OT F_54 PALIWO_SL_OT ID_TYPU_OT NO ACTION ENABLED No No
FK_PALIWO_OT_SL_TYP_LICZNIKA ID_JEDNOSTKI F_54 PALIWO_SL_TYP_LICZNIKA ID_JEDNOSTKI NO ACTION ENABLED No No
FK_PALIWO_OT_ZLECENIA ID_ZLECENIA F_54 ZLECENIA_WEW ID_ZLECENIA NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table PALIWO_OT
Constraint Name Type Condition Status Columns
SYS_C0054643 Check "ID_OT" IS NOT NULL ENABLED ID_OT
SYS_C0054644 Check "ID_ZLECENIA" IS NOT NULL ENABLED ID_ZLECENIA
SYS_C0054645 Check "DATA" IS NOT NULL ENABLED DATA
SYS_C0054646 Check "ID_TYPU_OT" IS NOT NULL ENABLED ID_TYPU_OT
SYS_C0054647 Check "ID_JEDNOSTKI" IS NOT NULL ENABLED ID_JEDNOSTKI
PALIWO_OT_PK Primary Key   ENABLED ID_OT

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