Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table STALE_TABELE | Next Table |
Comment |
---|
Ksiega glowna, tabela pozwalajaca przy dekretowaniu danego modulu odwolac sie do roznych tabel |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | MODUL | VARCHAR2(2 BYTE) | Y | Modul | |
2 | TABELA | VARCHAR2(32 BYTE) | Y | Tabela doa ktorej chcemy uzyskac dostep | |
3 | ID_TAB | VARCHAR2(32 BYTE) | Y | Nazwa kolumny ktora jest kluczem w tabeli | |
4 | KLUCZSQL | VARCHAR2(1024 BYTE) | Wzor zapytania pozwalajacy |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_STALE_TAB_MOD | NORMAL | MODUL | <none> | ||||
UNIQUE | UQ_STALE_TABELE_MOD_TAB | NORMAL | MODUL, TABELA | <none> |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054881 | Check | "MODUL" IS NOT NULL | ENABLED | MODUL |
SYS_C0054882 | Check | "TABELA" IS NOT NULL | ENABLED | TABELA |
SYS_C0054883 | Check | "ID_TAB" IS NOT NULL | ENABLED | ID_TAB |
UQ_STALE_TABELE_MOD_TAB | Unique | ENABLED | MODUL, TABELA |
Partitions |
Foreign Key Constraints |
Redaction Policies |