Columns of Table ULICE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_UL NUMBER(8) Y    
2 ID_MSC NUMBER(8)      
3 PNU CHAR(3 BYTE)      
4 ULICA VARCHAR2(80 BYTE)      
5 ID_OSIEDLA NUMBER(8)      
6 ULICA_WARIANT2 VARCHAR2(80 BYTE)      

Indexes on Table ULICE
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IDX_ULICE_FLT_ULICA FUNCTION-BASED NORMAL "F_54"."FORMS_VIEWS"."FLT_ULICA"("ULICA") <none>        
NON-UNIQUE IDX_ulice_upper_ulica FUNCTION-BASED NORMAL UPPER("ULICA") <none>        
NON-UNIQUE IX1_ULICE NORMAL ULICA <none>        
NON-UNIQUE IX_ULICE_IDMSC NORMAL ID_MSC <none>        
NON-UNIQUE IX_ULICE_IDOSIEDLA NORMAL ID_OSIEDLA <none>        
NON-UNIQUE IX_ULICE_PNU NORMAL PNU <none>        
UNIQUE PK_ULICE NORMAL ID_UL <none>        

Foreign Key Constraints on Table ULICE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_ULICE_MIASTA ID_MSC F_54 MIASTA ID_MSC NO ACTION ENABLED No No
FK_ULICE_SLPNULIC PNU F_54 SL_PNULIC PNU NO ACTION ENABLED No No
UL_FK_SL_OS ID_OSIEDLA F_54 SL_OSIEDLA ID_OSIEDLA NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table ULICE
Constraint Name Type Condition Status Columns
PK_ULICE Primary Key   ENABLED ID_UL

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