Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table USR_PRAWATABELE | Next Table |
Comment |
---|
Tabela określająca uprawnienia uzytkoników do tabel i widoków |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | SCHEMAT1 | VARCHAR2(30 BYTE) | Y | Nazwa uzytkownika | |
2 | NAZWA_TABELI2 | VARCHAR2(255 BYTE) | Y | Nazwa tabeli lub widoku | |
3 | PRAWO_SELECT | CHAR(1 BYTE) | Y | prawo dla select T/N | |
4 | PRAWO_INSERT | CHAR(1 BYTE) | Y | prawo dla insert T/N | |
5 | PRAWO_UPDATE | CHAR(1 BYTE) | Y | prawo dla update T/N | |
6 | PRAWO_DELETE | CHAR(1 BYTE) | Y | prawo dla insert T/N |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
UNIQUE | PK_PRAWATABELE | NORMAL | SCHEMAT, NAZWA_TABELI | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_PRAWATABELE_UZYTKOWNICY | SCHEMAT | F_54 | UZYTKOWNICY | SCHEMAT | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054895 | Check | "SCHEMAT" IS NOT NULL | ENABLED | SCHEMAT |
SYS_C0054896 | Check | "NAZWA_TABELI" IS NOT NULL | ENABLED | NAZWA_TABELI |
SYS_C0054897 | Check | "PRAWO_SELECT" IS NOT NULL | ENABLED | PRAWO_SELECT |
SYS_C0054898 | Check | "PRAWO_INSERT" IS NOT NULL | ENABLED | PRAWO_INSERT |
SYS_C0054899 | Check | "PRAWO_UPDATE" IS NOT NULL | ENABLED | PRAWO_UPDATE |
SYS_C0054900 | Check | "PRAWO_DELETE" IS NOT NULL | ENABLED | PRAWO_DELETE |
PK_PRAWATABELE | Primary Key | ENABLED | SCHEMAT, NAZWA_TABELI |
Partitions |
Redaction Policies |