Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table DEKRETY_MAN | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | TYP_SRC | CHAR(1 BYTE) | |||
2 | ID_SRC_POZ | NUMBER(8) | |||
3 | ID_KONTA | NUMBER(8) | |||
4 | KONTO | VARCHAR2(32 BYTE) | |||
5 | STRONA | CHAR(1 BYTE) | |||
6 | KWOTA | NUMBER(16,2) | |||
7 | OPIS | VARCHAR2(60 BYTE) | |||
8 | OBSZAR | VARCHAR2(8 BYTE) | |||
9 | AKTYWNOSC | VARCHAR2(8 BYTE) | |||
10 | RM_PK | DATE | |||
11 | ID_AKTYWNOSCI | VARCHAR2(19 BYTE) | |||
12 | KONTO_LICZBA | VARCHAR2(32 BYTE) | REPLACE("KONTO",'-','') | Kolumna funkcyjna na podstawie KONTO, bez znaku "-" |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_DEKRETKRETY_IDAKTYWNOSCI | NORMAL | ID_AKTYWNOSCI | <none> | ||||
NON-UNIQUE | IX_DEKRETKRETY_IDKONTA | NORMAL | ID_KONTA | <none> | ||||
NON-UNIQUE | IX_DEKRETKRETY_OBSZAR | NORMAL | OBSZAR | <none> | ||||
NON-UNIQUE | IX_DEKRETKRETY_OBSZARAKTYWNO | NORMAL | OBSZAR, AKTYWNOSC | <none> | ||||
NON-UNIQUE | IX_DEKRETKRETY_STRONA | NORMAL | STRONA | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_DEKRETYMAN_AKTYWNOSCI | OBSZAR, AKTYWNOSC | F_54 | AKTYWNOSCI | OBSZAR,AKTYWNOSC | NO ACTION | ENABLED | No | No |
FK_DEKRETY_MAN_AKTYWNOSCI2 | ID_AKTYWNOSCI | F_54 | AKTYWNOSCI | ID | NO ACTION | ENABLED | No | No |
FK_DEKRETYMAN_KONTA | ID_KONTA | F_54 | KONTA | ID_KONTA | NO ACTION | ENABLED | No | No |
FK_DEKRETYMAN_OBSZARY | OBSZAR | F_54 | OBSZARY | OBSZAR | NO ACTION | ENABLED | No | No |
FK_DEKRETYMAN_SLSTRON | STRONA | F_54 | SL_STRON | STRONA | NO ACTION | ENABLED | No | No |
Comments |
Partitions |
Primary Key, Unique, or Check Constraints |
Redaction Policies |