Comment for Table SOOKO_SPR_MSC_ODEBRANE
Comment
Tabela zawiera odpadach odebranych

Columns of Table SOOKO_SPR_MSC_ODEBRANE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   PK z Sekwencji
2 ID_SOOKO_SPR_MSC_NAGLOWEK NUMBER Y   FK do sooko_spr_msc_naglowki
3 ID_ODPADU NUMBER Y   Id Kodu odpadu, FK do sl_kodpadow
4 ID_ADRES_INST NUMBER     Nazwa i adres instalacji/firmy odbierającej odpady. FK do uslugi_instalacje_adresy
5 ID_ADRES_RDR NUMBER     Nazwa i adres wykonawcy. FK do uslugi_dzial_reg_wew_adresy
6 NR_KPO VARCHAR2(64 CHAR)     Numer karty przekazania odpadów
7 MASA NUMBER Y   Masa odpadów

Indexes on Table SOOKO_SPR_MSC_ODEBRANE
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE PK_SOOKO_SPR_MC_ODEB NORMAL ID <none>        

Foreign Key Constraints on Table SOOKO_SPR_MSC_ODEBRANE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_SOOKO_SPR_MC_ODEB_ADR_INST ID_ADRES_INST F_54 USLUGI_INSTALACJE_ADRESY ID_ADRES_INST NO ACTION ENABLED No No
FK_SOOKO_SPR_MC_ODEB_ADR_RDR ID_ADRES_RDR F_54 USLUGI_DZIAL_REG_WEW_ADRESY ID_ADRES_RDR NO ACTION ENABLED No No
FK_SOOKO_SPR_MC_ODEB_ID_ODPADU ID_ODPADU F_54 SL_KODPADOW ID_ODPADU NO ACTION ENABLED No No
FK_SOOKO_SPR_MC_ODEB_NG ID_SOOKO_SPR_MSC_NAGLOWEK F_54 SOOKO_SPR_MSC_NAGLOWKI ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table SOOKO_SPR_MSC_ODEBRANE
Constraint Name Type Condition Status Columns
NN_SOOKO_SPR_MC_ODEB_ID_ODP Check "ID_ODPADU" IS NOT NULL ENABLED ID_ODPADU
NN_SOOKO_SPR_MC_ODEB_MASA Check "MASA" IS NOT NULL ENABLED MASA
NN_SOOKO_SPR_MC_ODEB_NAG Check "ID_SOOKO_SPR_MSC_NAGLOWEK" IS NOT NULL ENABLED ID_SOOKO_SPR_MSC_NAGLOWEK
PK_SOOKO_SPR_MC_ODEB Primary Key   ENABLED ID

Table SOOKO_SPR_MSC_ODEBRANE does not have...
Partitions
Redaction Policies