Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table POSESJA_POJEMNIKI | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_POZ | NUMBER | Y | ||
2 | ID_POSESJI | VARCHAR2(15 BYTE) | |||
3 | POJEMNIK | VARCHAR2(10 BYTE) | |||
4 | ID_TYPODP | NUMBER | |||
5 | ID_KODODP | NUMBER | |||
6 | DATA_ROZSTAWIENIA | DATE | |||
7 | DATA_USUNIECIA | DATE | |||
8 | ID_POW_USUN_POJ | NUMBER | |||
9 | WLASCICIEL | VARCHAR2(1 BYTE) | 'M' | Selektywna: 'M' <- Pojemnik naleĹĽy do MPO, 'W' <- pojemniki wlasny klienta |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_POSESJOJEMN_IDKODODP | NORMAL | ID_KODODP | <none> | ||||
NON-UNIQUE | IX_POSESJOJEMN_IDPOSESJI | NORMAL | ID_POSESJI | <none> | ||||
NON-UNIQUE | IX_POSESJOJEMN_IDPOWUSUNPOJ | NORMAL | ID_POW_USUN_POJ | <none> | ||||
NON-UNIQUE | IX_POSESJOJEMN_IDTYPODP | NORMAL | ID_TYPODP | <none> | ||||
NON-UNIQUE | IX_POSESJOJEMN_POJEMNIK | NORMAL | POJEMNIK | <none> | ||||
UNIQUE | PK_POSESJA_POJEMNIKI_ID_POZ | NORMAL | ID_POZ | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_POSESJA_POJEMNIKI_ID_KODODP | ID_KODODP | F_54 | SL_KODPADOW | ID_ODPADU | NO ACTION | ENABLED | No | No |
FK_POSESJA_POJEMNIKI_ID_POSES | ID_POSESJI | F_54 | POSESJA | ID_POSESJI | NO ACTION | ENABLED | No | No |
FK_POSESJA_POJEMNIKI_ID_TYPODP | ID_TYPODP | F_54 | SL_TYPODP | ID_TYPU | NO ACTION | ENABLED | No | No |
FK_POSESJA_POJEMNIKI_POJ | POJEMNIK | F_54 | SL_POJEMNIKI | POJEMNIK | NO ACTION | ENABLED | No | No |
FK_POSES_POJEM_ID_POWUSUN | ID_POW_USUN_POJ | F_54 | SL_POW_USUNPOJ | ID | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_POSESJA_POJEMNIKI_ID_POZ | Primary Key | ENABLED | ID_POZ |
Comments |
Partitions |
Redaction Policies |