Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table POSESJA_OBREBY | Next Table |
Comment |
---|
Zawiera informację o tym, w jakich obrębach znajduje się posesja. |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | PK; Number z sekwencji (sq_posesja_obreby_id). | |
2 | ID_POSESJI | VARCHAR2(15 BYTE) | Y | Id posesji - FK do tabeli posesja. | |
3 | KOD_OBREBU | NUMBER | Y | Kod obrębu - FK do tabeli sl_obreby (PK w tabeli SL_OBREBY). |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_POSESJJAOBR_KODOBREBU | NORMAL | KOD_OBREBU | <none> | ||||
UNIQUE | PK_POSESJA_OBREBY_ID | NORMAL | ID | <none> | ||||
UNIQUE | UQ_POS_OBREBY_ID_POS_KOD_OBREB | NORMAL | ID_POSESJI, KOD_OBREBU | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_POSESJA_OBREBY_ID_POSESJI | ID_POSESJI | F_54 | POSESJA | ID_POSESJI | NO ACTION | ENABLED | No | No |
FK_POSESJA_OBREBY_KOD_OBREBU | KOD_OBREBU | F_54 | SL_OBREBY | KOD_OBREBU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_POSESJA_OBREBY_ID_POSESJI | Check | "ID_POSESJI" IS NOT NULL | ENABLED | ID_POSESJI |
NN_POSESJA_OBREBY_KOD_OBREBU | Check | "KOD_OBREBU" IS NOT NULL | ENABLED | KOD_OBREBU |
PK_POSESJA_OBREBY_ID | Primary Key | ENABLED | ID | |
UQ_POS_OBREBY_ID_POS_KOD_OBREB | Unique | ENABLED | ID_POSESJI, KOD_OBREBU |
Partitions |
Redaction Policies |