Columns of Table PUNKTY_ODBIORU_POSESJA_USLUG
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER(11) Y   klucz glowny - PK
2 PUNKTODBIORU_ID NUMBER(11) Y   klucz obcy do tabeli punkty_odbioru
3 POSESJAUSLUGA_ID NUMBER(11) Y   klucz obcy posesja_uslugi wskazujacy na usluge posesji

Indexes on Table PUNKTY_ODBIORU_POSESJA_USLUG
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_PUNKTYSJAUS_POSESJAUSLUGAI NORMAL POSESJAUSLUGA_ID <none>        
UNIQUE PK_PUNKTY_ODBIORU_POS_USL NORMAL ID <none>        
UNIQUE UQ_PKT_OBD_POS_PKTODB_POSUS NORMAL PUNKTODBIORU_ID, POSESJAUSLUGA_ID <none>        

Foreign Key Constraints on Table PUNKTY_ODBIORU_POSESJA_USLUG
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_PKTOBDPOSUS_PKTODB_PKTODBID PUNKTODBIORU_ID F_54 PUNKTY_ODBIORU ID NO ACTION ENABLED Yes Yes
FK_PKTOBDPOSUS_POSUSL_POSUSLID POSESJAUSLUGA_ID F_54 POSESJA_USLUGI ID_USLUGI NO ACTION ENABLED Yes Yes

PK, UK, & Check Constraints on Table PUNKTY_ODBIORU_POSESJA_USLUG
Constraint Name Type Condition Status Columns
NN_PKT_OBD_POS_US_PKTODBID Check "PUNKTODBIORU_ID" IS NOT NULL ENABLED PUNKTODBIORU_ID
NN_PKT_OBD_POS_US_POSUSID Check "POSESJAUSLUGA_ID" IS NOT NULL ENABLED POSESJAUSLUGA_ID
PK_PUNKTY_ODBIORU_POS_USL Primary Key   ENABLED ID
UQ_PKT_OBD_POS_PKTODB_POSUS Unique   ENABLED PUNKTODBIORU_ID, POSESJAUSLUGA_ID

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