Comment for Table SOOKO_SPR_KW_ODEBRANE
Comment
Tabela zawiera informacje o odebranych odpadach dla nagłówka s

Columns of Table SOOKO_SPR_KW_ODEBRANE
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   PK z Sekwencji
2 ID_SOOKO_SPR_KW_NAGLOWEK NUMBER Y   FK do sooko_spr_kw_naglowki
3 NR_MC VARCHAR2(2 BYTE) Y   Miesiąc w którym odebrano odpady. FK do sl_miesiace
4 ID_ODPADU NUMBER Y   Rodzaj odebranych odpadów. FK do sl_kodpadow.
5 MASA NUMBER Y   Masa odebranych odpadów

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

Foreign Key Constraints on Table SOOKO_SPR_KW_ODEBRANE
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_SOOKO_SP_KW_ODEB_ID_ODPADU ID_ODPADU F_54 SL_KODPADOW ID_ODPADU NO ACTION ENABLED No No
FK_SOOKO_SP_KW_ODEB_NR_MC NR_MC F_54 SL_MIESIACE NR_MC NO ACTION ENABLED No No
FK_SOOKO_SP_KW_OD_ID_SPR_KW_NG ID_SOOKO_SPR_KW_NAGLOWEK F_54 SOOKO_SPR_KW_NAGLOWKI ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table SOOKO_SPR_KW_ODEBRANE
Constraint Name Type Condition Status Columns
NN_SOOKO_SP_KW_ODEB_ID_ODPADU Check "ID_ODPADU" IS NOT NULL ENABLED ID_ODPADU
NN_SOOKO_SP_KW_ODEB_MASA Check "MASA" IS NOT NULL ENABLED MASA
NN_SOOKO_SP_KW_ODEB_NR_MC Check "NR_MC" IS NOT NULL ENABLED NR_MC
NN_SOOKO_SP_KW_OD_ID_SPR_KW_NG Check "ID_SOOKO_SPR_KW_NAGLOWEK" IS NOT NULL ENABLED ID_SOOKO_SPR_KW_NAGLOWEK
PK_SOOKO_SPR_KW_ODEBRANE Primary Key   ENABLED ID

Table SOOKO_SPR_KW_ODEBRANE does not have...
Partitions
Redaction Policies