Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table KDR_EXCEPTION_LIST | Next Table |
Comment |
---|
Tabela z wszystkimi exceptionami uzywanymi w kdr |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | NUMER | VARCHAR2(20 BYTE) | Y | Numer exceptiona. Wyglada nastepujaco:[nr_obiektu z kdr_sl_obiekty]-[kolejny numer bledu na obiekcie] | |
2 | KOD | VARCHAR2(20 BYTE) | Kod komunikatu z kdr_komunikaty. | ||
3 | MIEJSCE | VARCHAR2(100 BYTE) | Dokladne miejsce wystapienia bledu (np. ktora funkcja na pakiecie). | ||
4 | UWAGI | VARCHAR2(250 BYTE) | Dodatkowe uwagi do bledu. |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_PK_KDR_EXCEPTION_LIST | NORMAL | NUMER | <none> | ||||
NON-UNIQUE | IX_KDREXCTIONL_KOD | NORMAL | KOD | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_KDR_EXCEPTION_LIST_KOMUNIKA | KOD | F_54 | KDR_KOMUNIKATY | KOD | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_KDR_EXCEPTION_LIST | Primary Key | ENABLED | NUMER |
Partitions |
Redaction Policies |