Columns of Table USLUGI_SPRAWOZDANIA_POSESJE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER(11) Y    
2 SPRAWOZDANIE_ID NUMBER(11) Y    
3 POSESJA_ID VARCHAR2(15 BYTE) Y    

Indexes on Table USLUGI_SPRAWOZDANIA_POSESJE
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_USLUGIAPOSE_POSESJAID NORMAL POSESJA_ID <none>        
UNIQUE PK_USL_SPRAWOZDANIA_POSESJE NORMAL ID <none>        
UNIQUE UQ_USL_SPR_POS NORMAL SPRAWOZDANIE_ID, POSESJA_ID <none>        

Foreign Key Constraints on Table USLUGI_SPRAWOZDANIA_POSESJE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_USL_SPRAWO_POSESJE_POSESJA POSESJA_ID F_54 POSESJA ID_POSESJI NO ACTION ENABLED No No
SPRAWOZDANIE_ID_REFS_ID_C85B28 SPRAWOZDANIE_ID F_54 USLUGI_SPRAWOZDANIA ID NO ACTION ENABLED Yes Yes

PK, UK, & Check Constraints on Table USLUGI_SPRAWOZDANIA_POSESJE
Constraint Name Type Condition Status Columns
NN_USL_SPRAWO_POS_POSES_ID Check "POSESJA_ID" IS NOT NULL ENABLED POSESJA_ID
NN_USL_SPRAWO_POS_SPRAWO_ID Check "SPRAWOZDANIE_ID" IS NOT NULL ENABLED SPRAWOZDANIE_ID
PK_USL_SPRAWOZDANIA_POSESJE Primary Key   ENABLED ID
UQ_USL_SPR_POS Unique   ENABLED SPRAWOZDANIE_ID, POSESJA_ID

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