Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table AB_USTAWIENIA_DOMYSLNE | Next Table |
Comment |
---|
Pamięta, które ustawienie jest domyślnym dla danego usera. |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_ABUSDO | NUMBER | Y | PK (z SEQ_ABUSDO_ID) | |
2 | ID_ABUS | NUMBER | FK do AB_FORMS_USTAWIENIA. Id domyślnego ustawienia. | ||
3 | SCHEMAT | VARCHAR2(30 BYTE) | FK do UZYTKOWNICY. Jeśli NULL, to domyślne ustawienie systemowe (ustawienie domyślne dla wszystkich, którzy nie mają własnego domyślnego). |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_ABUSDO_ID_ABUS | NORMAL | ID_ABUS | <none> | ||||
NON-UNIQUE | IDX_ABUSDO_SCHEMAT | NORMAL | SCHEMAT | <none> | ||||
UNIQUE | PK_ABUSDO | NORMAL | ID_ABUSDO | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_ABUSDO_USTAWIENIA | ID_ABUS | F_54 | AB_USTAWIENIA | ID_ABUS | NO ACTION | ENABLED | No | No |
FK_ABUSDO_UZYTKOWNICY | SCHEMAT | F_54 | UZYTKOWNICY | SCHEMAT | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_ABUSDO | Primary Key | ENABLED | ID_ABUSDO |
Partitions |
Redaction Policies |