Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FK_ZMKONTA | Next Table |
Comment |
---|
Ksiega glowna, tabela przechowujaca zmiany w planie kont |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_KONTA | NUMBER(8) | Id konta z KONTA | ||
2 | KONTO_STARE | VARCHAR2(32 BYTE) | Stary numer konta | ||
3 | KONTO_NOWE | VARCHAR2(32 BYTE) | Nowy numer konta | ||
4 | STATUS_S | CHAR(1 BYTE) | Stary status konta | ||
5 | STATUS_N | CHAR(1 BYTE) | Nowy status konta | ||
6 | DL_NAST_S | NUMBER | Stara dlugosc nastepnego rozwiniecia | ||
7 | DL_NAST_N | NUMBER | Nowa dlugosc nastepnego rozwiniecia | ||
8 | DT_OPERACJI | DATE | Data zmiany | ||
9 | OPERATOR | VARCHAR2(30 BYTE) | Uzytkownik ktory dokonal zmiany |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX1_FKZMKONTA | NORMAL | ID_KONTA, DT_OPERACJI | <none> |
Partitions |
Foreign Key Constraints |
Primary Key, Unique, or Check Constraints |
Redaction Policies |