Comment for Table KDR_SKLADN_IND_TYP_DEK
Comment
Tablica z przypisaniem kont i regul dekretujacych do skladnikow indywidualnych

Columns of Table KDR_SKLADN_IND_TYP_DEK
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_SKLADN_IND_TYP_DEK NUMBER Y   Klucz glowny z sekwencji SEQ_KDR_SKL_IND_DEK
2 KONTO_WN VARCHAR2(32 BYTE)     Konto po stronie WN
3 KONTO_MA VARCHAR2(32 BYTE)     Konto po stronie MA
4 ID_REGULY_WN NUMBER     Id reguly po stronie WN z REGULY_KS
5 ID_REGULY_MA NUMBER     Id reguly po stronie MA z REGULY_KS
6 ID_SKLADN_IND_TYP NUMBER      

Indexes on Table KDR_SKLADN_IND_TYP_DEK
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE IX_KDRSKLNDTYP_IDREGULYMA NORMAL ID_REGULY_MA <none>        
NON-UNIQUE IX_KDRSKLNDTYP_IDREGULYWN NORMAL ID_REGULY_WN <none>        
UNIQUE PK_KDR_SKL_IND_TYP_DEK NORMAL ID_SKLADN_IND_TYP_DEK <none>        

Foreign Key Constraints on Table KDR_SKLADN_IND_TYP_DEK
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KDR_SKL_IND_TYP_ID_SKL ID_SKLADN_IND_TYP F_54 KDR_SKLADN_IND_TYP ID_SKLADN_IND_TYP NO ACTION ENABLED No No
FK_KDR_SKL_IND_TYP_RM ID_REGULY_MA F_54 REGULY_KS ID_REGULY NO ACTION ENABLED No No
FK_KDR_SKL_IND_TYP_RW ID_REGULY_WN F_54 REGULY_KS ID_REGULY NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KDR_SKLADN_IND_TYP_DEK
Constraint Name Type Condition Status Columns
NN_KDR_SKL_IND_TYP_DEK_ID Check "ID_SKLADN_IND_TYP_DEK" IS NOT NULL ENABLED ID_SKLADN_IND_TYP_DEK
PK_KDR_SKL_IND_TYP_DEK Primary Key   ENABLED ID_SKLADN_IND_TYP_DEK

Table KDR_SKLADN_IND_TYP_DEK does not have...
Partitions
Redaction Policies