Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table TMP_68494_PRZYPISY_DOKOREKTY | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | NUMER | VARCHAR2(100 BYTE) | |||
2 | ID_FAK | NUMBER(16) | |||
3 | ID_FAK2 | NUMBER(16) | |||
4 | TYP_FAK | VARCHAR2(128 BYTE) | |||
5 | DATA_FAK | DATE | |||
6 | OKRES_OBCIAZENIA | VARCHAR2(100 BYTE) | |||
7 | DATA_ZAP | DATE | |||
8 | NR_KONTR | NUMBER(16) | |||
9 | REJESTR | VARCHAR2(26 BYTE) | |||
10 | NAZWA_KONTRAHENTA | VARCHAR2(1000 BYTE) | |||
11 | ADRES_POSESJI | VARCHAR2(1000 BYTE) | |||
12 | TERMIN | DATE | |||
13 | WARTOSC | NUMBER(16,2) | |||
14 | NETTO | NUMBER(16,2) | |||
15 | WARTOSC_PK | NUMBER(16,2) | |||
16 | WARTOSC_ZAP | NUMBER(16,2) | |||
17 | WALUTA | VARCHAR2(26 BYTE) | |||
18 | STATUS | VARCHAR2(30 BYTE) | 'NIEPRZETWORZONE' | ||
19 | UWAGI | VARCHAR2(4000 BYTE) | |||
20 | ID_FAK_KOR | NUMBER |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_TMP_68494_PD_ID_FAK | NORMAL | ID_FAK | <none> | ||||
NON-UNIQUE | IDX_TMP_68494_PD_ID_FAK2 | NORMAL | ID_FAK2 | <none> | ||||
NON-UNIQUE | IDX_TMP_68494_PD_NR_KONTR | NORMAL | NR_KONTR | <none> |
Comments |
Partitions |
Foreign Key Constraints |
Primary Key, Unique, or Check Constraints |
Redaction Policies |