Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MV_REK_ZGLOSZENIA_LISTA | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | UR_ROWID | ROWID | |||
2 | URS_ROWID | ROWID | |||
3 | SRS_ROWID | ROWID | |||
4 | SPR_ROWID | ROWID | |||
5 | SSZ_ROWID | ROWID | |||
6 | SLD_ROWID | ROWID | |||
7 | POS_ROWID | ROWID | |||
8 | KW_ROWID | ROWID | |||
9 | KW2_ROWID | ROWID | |||
10 | ID | NUMBER(11) | |||
11 | TEMAT | VARCHAR2(512 CHAR) | |||
12 | OPIS | VARCHAR2(3000 BYTE) | |||
13 | ID_POWODU_REKL | NUMBER(11) | Y | ||
14 | POWOD | VARCHAR2(255 BYTE) | |||
15 | ID_FAK | NUMBER(19) | |||
16 | ID_PSZOK | NUMBER(11) | |||
17 | ID_POSESJI | VARCHAR2(15 BYTE) | |||
18 | POS_ID_SEKTORA | NUMBER | |||
19 | CZY_ZABLOKOWANA | VARCHAR2(1 BYTE) | |||
20 | ID_SPOSOBU_ZGLOSZENIA | NUMBER | |||
21 | SPOSOB_ZGLOSZENIA_NAZWA | VARCHAR2(256 BYTE) | |||
22 | AUTOR | NUMBER | |||
23 | AUTOR_NAZWA | VARCHAR2(513 CHAR) | |||
24 | ZGL_NAZWA | VARCHAR2(256 CHAR) | |||
25 | ZGL_TEL | VARCHAR2(40 BYTE) | |||
26 | ZGL_EMAIL | VARCHAR2(500 CHAR) | |||
27 | SCHEMAT | VARCHAR2(30 BYTE) | |||
28 | PRIORYTET | NUMBER(1) | |||
29 | ODPOWIEDZIALNY | VARCHAR2(513 CHAR) | |||
30 | ODPOWIEDZIALNY_NR_KONTR | NUMBER(11) | |||
31 | ID_SLREKSTAT | NUMBER | |||
32 | STATUS_DATA | TIMESTAMP(6) | Y | ||
33 | STATUS_SYMBOL | VARCHAR2(5 BYTE) | Y | ||
34 | STATUS_NAZWA | VARCHAR2(50 CHAR) | Y | ||
35 | ID_STATUS_FIRMY | NUMBER(11) | |||
36 | ID_POPRZEDNIEGO_STATUSU | NUMBER | |||
37 | KOGO_DOTYCZY | CHAR(1 BYTE) | Y | ||
38 | CZY_ZAMKNIETY | CHAR(1 BYTE) | Y | ||
39 | CZY_ZAMKNIETY_SLOWNIE | VARCHAR2(22 BYTE) | |||
40 | NA_CO_ZMIANA_CSV | VARCHAR2(500 BYTE) | |||
41 | DATA_UTW | TIMESTAMP(6) | Y | ||
42 | TERMIN_FIRMA | DATE | |||
43 | TERMIN_FIRMA_ODP | DATE | |||
44 | TERMIN_PLAN_REAL | DATE | |||
45 | TERMIN_WYKONANIA | DATE | |||
46 | TERMIN_GMINA | DATE | |||
47 | NAZWA_DZIALU | VARCHAR2(1059 CHAR) | |||
48 | ID_DZIALU | VARCHAR2(32 CHAR) | |||
49 | VARCHAR2(100 BYTE) | ||||
50 | DATA_PRZEKAZANIA_FIRMIE | DATE | |||
51 | DATA_ZWROCENIA_PRZEZ_FIRME | DATE | |||
52 | FIRMA_NR_KONTR | NUMBER | |||
53 | SL_FRAKCJE_KOMBINACJE_ID | NUMBER | |||
54 | BLOKADA_DO | TIMESTAMP(6) | |||
55 | KIEDY_OST_AKTYWNOSC | TIMESTAMP(6) | |||
56 | AUTOR_EMAIL | VARCHAR2(256 CHAR) | |||
57 | AUTOR_TELEFON | VARCHAR2(40 BYTE) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_MVREKLISTA_AUTOR | NORMAL | AUTOR | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_AUTOR_EMAIL | NORMAL | AUTOR_EMAIL | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_AUTOR_TELEFON | NORMAL | AUTOR_TELEFON | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_BLOKADADO | NORMAL | BLOKADA_DO | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_CZYZABLOK | NORMAL | CZY_ZABLOKOWANA | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_DATAUTW | NORMAL | DATA_UTW | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_FIRMANRKONTR | NORMAL | FIRMA_NR_KONTR | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_FLT_EMAIL | FUNCTION-BASED NORMAL | "F_54"."FORMS_VIEWS"."FLT_EMAIL"("EMAIL") | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_FLT_ZGL_EMAIL | FUNCTION-BASED NORMAL | "F_54"."FORMS_VIEWS"."FLT_EMAIL"("ZGL_EMAIL") | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_FLT_ZGL_NAZWA | FUNCTION-BASED NORMAL | "F_54"."FORMS_VIEWS"."FLT_NAZWA"("P_NAZWA1"=>"ZGL_NAZWA") | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_FLT_ZGL_TEL | FUNCTION-BASED NORMAL | "F_54"."FORMS_VIEWS"."FLT_TELEFON"("ZGL_TEL") | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_ID | NORMAL | ID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDDZIALU | NORMAL | ID_DZIALU | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDPOPSTAT | NORMAL | ID_POPRZEDNIEGO_STATUSU | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDPOSES | NORMAL | ID_POSESJI | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDPOWREKL | NORMAL | ID_POWODU_REKL | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDSEKTOR | NORMAL | POS_ID_SEKTORA | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDSLREK | NORMAL | ID_SLREKSTAT | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDSPOSZGL | NORMAL | ID_SPOSOBU_ZGLOSZENIA | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_IDSTATFIR | NORMAL | ID_STATUS_FIRMY | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_KIEDYOSTAKT | NORMAL | KIEDY_OST_AKTYWNOSC | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_KW2_ROWID | NORMAL | KW2_ROWID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_KW_ROWID | NORMAL | KW_ROWID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_NRKONTR | NORMAL | ODPOWIEDZIALNY_NR_KONTR | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_POSROWID | NORMAL | POS_ROWID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_SCHEMAT | NORMAL | SCHEMAT | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_SLFRAKCJEKOMBID | NORMAL | SL_FRAKCJE_KOMBINACJE_ID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_SRSROWID | NORMAL | SRS_ROWID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_TERMIN | FUNCTION-BASED NORMAL | TRUNC("TERMIN_FIRMA") | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_URROWID | NORMAL | UR_ROWID | <none> | ||||
NON-UNIQUE | IDX_MVREKLISTA_URSROWID | NORMAL | URS_ROWID | <none> |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C00212413 | Check | "ID_POWODU_REKL" IS NOT NULL | ENABLED | ID_POWODU_REKL |
SYS_C00212414 | Check | "STATUS_DATA" IS NOT NULL | ENABLED | STATUS_DATA |
SYS_C00212415 | Check | "STATUS_SYMBOL" IS NOT NULL | ENABLED | STATUS_SYMBOL |
SYS_C00212416 | Check | "STATUS_NAZWA" IS NOT NULL | ENABLED | STATUS_NAZWA |
SYS_C00212417 | Check | "KOGO_DOTYCZY" IS NOT NULL | ENABLED | KOGO_DOTYCZY |
SYS_C00212418 | Check | "CZY_ZAMKNIETY" IS NOT NULL | ENABLED | CZY_ZAMKNIETY |
SYS_C00212419 | Check | "DATA_UTW" IS NOT NULL | ENABLED | DATA_UTW |
Comments |
Partitions |
Foreign Key Constraints |
Redaction Policies |