Comment for Table POSESJA_SPOSOBY_ZAGOSP_BIO
Comment
Tabela określa sposoby zagospodarowania odpadów biodegradalnych na posesji

Columns of Table POSESJA_SPOSOBY_ZAGOSP_BIO
Column ID Column Name Datatype Not Null Data Default Comments
1 ID NUMBER Y   PK z sekwencji
2 ID_SL_DEK_SPOSOB_ZAGOSP_BIO VARCHAR2(4 CHAR) Y   FK sl_dek_sposoby_zagosp_bio
3 ID_POSESJI VARCHAR2(15 BYTE) Y   FK do posesja

Indexes on Table POSESJA_SPOSOBY_ZAGOSP_BIO
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_POSESJAGOSP_IDPOSESJI NORMAL ID_POSESJI <none>        
NON-UNIQUE IX_POSESJAGOSP_IDSLDEKSPOSOBZ NORMAL ID_SL_DEK_SPOSOB_ZAGOSP_BIO <none>        
UNIQUE PK_POS_SPOS_ZAGOSP_BIO NORMAL ID <none>        

Foreign Key Constraints on Table POSESJA_SPOSOBY_ZAGOSP_BIO
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_POS_SP_ZAG_BI_POSESJA ID_POSESJI F_54 POSESJA ID_POSESJI NO ACTION ENABLED No No
FK_POS_SP_ZAG_BI_SL_DEK_SP_ZAG ID_SL_DEK_SPOSOB_ZAGOSP_BIO F_54 SL_DEK_SPOSOBY_ZAGOSP_BIO ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table POSESJA_SPOSOBY_ZAGOSP_BIO
Constraint Name Type Condition Status Columns
NN_POS_SP_ZAG_BI_ID_POS Check "ID_POSESJI" IS NOT NULL ENABLED ID_POSESJI
NN_POS_SP_ZAG_BI_ID_SL_DEK_SP Check "ID_SL_DEK_SPOSOB_ZAGOSP_BIO" IS NOT NULL ENABLED ID_SL_DEK_SPOSOB_ZAGOSP_BIO
PK_POS_SPOS_ZAGOSP_BIO Primary Key   ENABLED ID

Table POSESJA_SPOSOBY_ZAGOSP_BIO does not have...
Partitions
Redaction Policies