Comment for Table RACHUNKI_TYPK
Comment
Finanse, tabela z przypisanymi typami kontrahentow do rachunkow banowych

Columns of Table RACHUNKI_TYPK
Column ID Column Name Datatype Not Null Data Default Comments
1 NR_RACH NUMBER(2)     Nr rachunku z tabeli RACHUNKI
2 TYP_KONTR VARCHAR2(5 BYTE) Y   Typ kontrahenta z TYPYKON

Indexes on Table RACHUNKI_TYPK
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE IX1_RACHUNKITYPK NORMAL TYP_KONTR <none>        
NON-UNIQUE IX_RACHUNUNKIT_NRRACH NORMAL NR_RACH <none>        

Foreign Key Constraints on Table RACHUNKI_TYPK
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_RACHUNKITYPK_RACHUNKI NR_RACH F_54 RACHUNKI NR_RACH NO ACTION ENABLED No No
FK_RACHUNKI_TYPYKON TYP_KONTR F_54 TYPYKON TYP NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table RACHUNKI_TYPK
Constraint Name Type Condition Status Columns
NN_RACHUNKITYPK_TYP_KONTR Check "TYP_KONTR" IS NOT NULL ENABLED TYP_KONTR

Table RACHUNKI_TYPK does not have...
Partitions
Redaction Policies