Comment for Table POSESJA_USLUGI_ODPADY
Comment
Tabela z kodami odpadów zadeklarowanymi do usługi

Columns of Table POSESJA_USLUGI_ODPADY
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_USLUGI NUMBER(8) Y   ID usługi z Tabeli POSESJA_USLUGI
2 ID_ODPADU NUMBER(8) Y   ID odpadu z tabeli SL_KODPADOW

Indexes on Table POSESJA_USLUGI_ODPADY
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_POSESJGIODP_IDODPADU NORMAL ID_ODPADU <none>        
NON-UNIQUE IX_POSESJGIODP_IDUSLUGI NORMAL ID_USLUGI <none>        

Foreign Key Constraints on Table POSESJA_USLUGI_ODPADY
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_POSESJAODPADY_IDODPADU ID_ODPADU F_54 SL_KODPADOW ID_ODPADU NO ACTION ENABLED No No
FK_POSESJAODPADY_IDUSLUGI ID_USLUGI F_54 POSESJA_USLUGI ID_USLUGI NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table POSESJA_USLUGI_ODPADY
Constraint Name Type Condition Status Columns
SYS_C0054726 Check "ID_USLUGI" IS NOT NULL ENABLED ID_USLUGI
SYS_C0054727 Check "ID_ODPADU" IS NOT NULL ENABLED ID_ODPADU

Table POSESJA_USLUGI_ODPADY does not have...
Partitions
Redaction Policies