Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table DW_STATUSY_DZIKIE_WYSYP_HIST | Next Table |
Comment |
---|
Historia zmian statusów dzikich wysypisk. |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_POZ | NUMBER | Y | Id pozycji z sekwencji seq_dw_statusy_dw_hist_id_poz. | |
2 | ID_WYSYPISKA | NUMBER(10) | Y | Id wysypiska, któremu zmieniono status. Fk do dw_dzikie_wysypiska.id_wysypiska. | |
3 | CZAS | TIMESTAMP(6) | Czas zmiany statusu. | ||
4 | STARY_STATUS_ID | NUMBER(10) | Identyfikator poprzedniego statusu. FK do dw_sl_statusy.id_statusu. | ||
5 | NOWY_STATUS_ID | NUMBER(10) | Identyfikator nowego statusu. FK do dw_sl_statusy.id_statusu. | ||
6 | UZYTKOWNIK | VARCHAR2(30 BYTE) | Użytkownik, który zmienił status. |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | INDX_DW_STATUSY_IDWYSYPISKA | NORMAL | ID_WYSYPISKA | <none> | ||||
NON-UNIQUE | INDX_DW_STATUSY_NOWYSTATUSID | NORMAL | NOWY_STATUS_ID | <none> | ||||
NON-UNIQUE | INDX_DW_STATUSY_STARYSTATUSID | NORMAL | STARY_STATUS_ID | <none> | ||||
UNIQUE | PK_DW_STATUSY_DW_HIST_ID_POZ | NORMAL | ID_POZ | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_DW_STAT_DW_HIST_ID_WYSYP | ID_WYSYPISKA | F_54 | DW_DZIKIE_WYSYPISKA | ID_WYSYPISKA | NO ACTION | ENABLED | No | No |
FK_DW_STAT_DW_HIST_NOWY_ST_ID | NOWY_STATUS_ID | F_54 | DW_SL_STATUSY | ID_STATUSU | NO ACTION | ENABLED | No | No |
FK_DW_STAT_DW_HIST_STARY_ST_ID | STARY_STATUS_ID | F_54 | DW_SL_STATUSY | ID_STATUSU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_DW_STATUSY_DW_HIST_ID_WYS | Check | "ID_WYSYPISKA" IS NOT NULL | ENABLED | ID_WYSYPISKA |
PK_DW_STATUSY_DW_HIST_ID_POZ | Primary Key | ENABLED | ID_POZ |
Partitions |
Redaction Policies |