Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table KDR_LOGS | Next Table |
Comment |
---|
tabela przechowuje wszystkie informacje niezbedne do zapisania aby pozniej zweryfikowac dzialanie systemu |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | ID | |
2 | DATEOF | DATE | data dodania komunikatu | ||
3 | MSOURCE | VARCHAR2(100 BYTE) | Y | zrodlo komunikatu | |
4 | MSG | VARCHAR2(4000 BYTE) | tresc komunikatu | ||
5 | LVL | NUMBER | poziom waznosci 0 - info ; 1 - warning; 2 - error | ||
6 | SUSER | VARCHAR2(20 BYTE) | system user od ktorego przyszedl msg | ||
7 | ADDR | VARCHAR2(16 CHAR) | Adres IP z ktorego przechwycono loga. |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_KDR_LOGS_PK | NORMAL | ID | <none> |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_KDR_LOGS_ID | Check | "ID" IS NOT NULL | ENABLED | ID |
NN_KDR_LOGS_MSOURCE | Check | "MSOURCE" IS NOT NULL | ENABLED | MSOURCE |
PK_KDR_LOGS | Primary Key | ENABLED | ID |
Partitions |
Foreign Key Constraints |
Redaction Policies |