Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table T_KURSOW_BANKI | Next Table |
Comment |
---|
Tabela z kursami dla banku |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_KURSOW_BANKI | NUMBER | Y | PK, sekwencja | |
2 | DATA | DATE | Y | Data/dzeń danego kursu | |
3 | WALUTA | VARCHAR2(3 BYTE) | Y | Waluta, FK do sl_waluty | |
4 | PRZELICZNIK | NUMBER(12) | Y | ||
5 | KURS | NUMBER(12,4) | Y | Kurs na dzień | |
6 | ID_TYP_KURSU | VARCHAR2(1 BYTE) | Y | FK do sl_typ_kursu, typ kursu S/Z/A | |
7 | ID_BANKU | NUMBER | Y | FK do sl_banki, dla jakiego baku to kurs |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_T_KURSOW_B_IDBANKU | NORMAL | ID_BANKU | <none> | ||||
NON-UNIQUE | INDX_T_KURSOW_B_IDTYPKURSU | NORMAL | ID_TYP_KURSU | <none> | ||||
NON-UNIQUE | INDX_T_KURSOW_B_WALUTA | NORMAL | WALUTA | <none> | ||||
UNIQUE | PK_T_KURSOW_BANKI | NORMAL | ID_KURSOW_BANKI | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_T_KURS_BANKI_ID_BANKU | ID_BANKU | F_54 | SL_BANKI | ID_BANKU | NO ACTION | ENABLED | No | No |
FK_T_KURS_BANKI_ID_TYP_KURSU | ID_TYP_KURSU | F_54 | SL_TYP_KURSU | ID_TYP_KURSU | NO ACTION | ENABLED | No | No |
FK_T_KURS_BANKI_WALUTA | WALUTA | F_54 | SL_WALUTY | WALUTA | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_T_KURSOW_BANKI_DATA | Check | "DATA" IS NOT NULL | ENABLED | DATA |
NN_T_KURSOW_BANKI_ID_BANKU | Check | "ID_BANKU" IS NOT NULL | ENABLED | ID_BANKU |
NN_T_KURSOW_BANKI_ID_TYP_KURS | Check | "ID_TYP_KURSU" IS NOT NULL | ENABLED | ID_TYP_KURSU |
NN_T_KURSOW_BANKI_KURS | Check | "KURS" IS NOT NULL | ENABLED | KURS |
NN_T_KURSOW_BANKI_PRZELICZNIK | Check | "PRZELICZNIK" IS NOT NULL | ENABLED | PRZELICZNIK |
NN_T_KURSOW_BANKI_WALUTA | Check | "WALUTA" IS NOT NULL | ENABLED | WALUTA |
PK_T_KURSOW_BANKI | Primary Key | ENABLED | ID_KURSOW_BANKI |
Partitions |
Redaction Policies |