Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table POSESJA_USLUGI_HARM_WST_ZAB | Next Table |
Comment |
---|
Tabela z informacjami kiedy pojemnik ma zosatć wstawiony/zabrany |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_HARM | NUMBER(8) | Y | ID harmonogramu | |
2 | DATA_WST_ZAB | DATE | Y | Data wstawienia lub zabrania | |
3 | WST_ZAB | VARCHAR2(1 BYTE) | Y | W- wstawienie, Z -zabranie | |
4 | ID_OPISU | NUMBER(6) | Id opisu powdów wstaw/zabrania | ||
5 | UWAGI | VARCHAR2(255 BYTE) | Dodatkowe uwagi | ||
6 | OPERATOR | VARCHAR2(60 BYTE) | Operator dokonujący zmiany | ||
7 | DATA | DATE |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_POSESJRMWST_IDHARM | NORMAL | ID_HARM | <none> | ||||
NON-UNIQUE | IX_POSESJRMWST_IDOPISU | NORMAL | ID_OPISU | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_HARM_WST_ZAB_OPIS | ID_OPISU | F_54 | SL_OPIS_WST_ZAB | ID_OPISU | NO ACTION | ENABLED | No | No |
FK_POSESJA_USLUGI_HARM_WST_ZAB | ID_HARM | F_54 | POSESJA_USLUGI_HARM | ID_HARM | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054720 | Check | "ID_HARM" IS NOT NULL | ENABLED | ID_HARM |
SYS_C0054721 | Check | "DATA_WST_ZAB" IS NOT NULL | ENABLED | DATA_WST_ZAB |
SYS_C0054722 | Check | "WST_ZAB" IS NOT NULL | ENABLED | WST_ZAB |
Partitions |
Redaction Policies |