Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table SL_WALUTY | Next Table |
Comment |
---|
slownik walut |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | WALUTA | VARCHAR2(3 BYTE) | Y | Skrot nazwy waluty | |
2 | OPIS_WALUTY | VARCHAR2(127 BYTE) | Pelna nazwa waluty | ||
3 | ODM_POJ | VARCHAR2(63 BYTE) | Odmiana calosci waluty dla ilosci rownej 1 | ||
4 | ODM_JED | VARCHAR2(63 BYTE) | Odmiana calosci waluty dla ilosci pomiedzy 2 a 4 | ||
5 | ODM_NAS | VARCHAR2(63 BYTE) | Odmiana calosci waluty dla ilosci wiekszej od 4 | ||
6 | ODM_DRO_POJ | VARCHAR2(63 BYTE) | Odmiana czesci waluty dla ilosci rownej 1 | ||
7 | ODM_DRO_JED | VARCHAR2(63 BYTE) | Odmiana czesci waluty dla ilosci pomiedzy 2 a 4 | ||
8 | ODM_DRO_NAS | VARCHAR2(63 BYTE) | Odmiana czesci waluty dla ilosci wiekszej od 4 | ||
9 | NR_RACH | NUMBER | Nr rachunku do przenoszenia i zwrotow zaplat |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_SLWALUSLWAL_NRRACH | NORMAL | NR_RACH | <none> | ||||
UNIQUE | PK_SL_WALUTY_WAL | NORMAL | WALUTA | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_SL_WALUTY_NR_RACH | NR_RACH | F_54 | RACHUNKI | NR_RACH | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_SL_WALUTY_WAL | Primary Key | ENABLED | WALUTA |
Partitions |
Redaction Policies |