Columns of Table PRZYCHODY_WALUT
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
KB2 |
CHAR(1 BYTE) |
Y |
|
|
2 |
NR_KB |
NUMBER(2) |
|
|
|
3 |
ID_POZYCJI1 |
NUMBER(8) |
Y |
|
|
4 |
DATA |
DATE |
|
|
|
5 |
WALUTA |
VARCHAR2(3 BYTE) |
|
|
|
6 |
WARTOSC_WAL |
NUMBER(16,2) |
|
|
|
7 |
WARTOSC_PLN |
NUMBER(16,2) |
|
|
|
8 |
KURS |
NUMBER(22,4) |
|
|
|
9 |
POZOST_WAL |
NUMBER(16,2) |
|
|
|
10 |
JEDNOSTKA |
NUMBER(4) |
|
|
|
11 |
POZOST_WAL_PLN |
NUMBER(16,2) |
|
|
|
Indexes on Table PRZYCHODY_WALUT
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX_PRZYCHODYWA_WALUTA |
NORMAL |
WALUTA |
<none> |
|
|
|
|
UNIQUE |
PK_PRZYCHODYWALUT |
NORMAL |
ID_POZYCJI, KB |
<none> |
|
|
|
|
Foreign Key Constraints on Table PRZYCHODY_WALUT
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_PRZYCHODYWALUT_WAL |
WALUTA |
F_54 |
SL_WALUTY |
WALUTA |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table PRZYCHODY_WALUT
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_PRZYCHODYWALUT |
Primary Key |
|
ENABLED |
ID_POZYCJI, KB |
Table PRZYCHODY_WALUT does not have...
Comments |
Partitions |
Redaction Policies |