Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table POSESJA_EWIDENCJA_PESEL | Next Table |
Comment |
---|
Informacje o osobach zamieszkałych na danej posesji |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_POSESJI | VARCHAR2(15 BYTE) | ID posesji z tabeli POSEJA | ||
2 | ID_EWP | NUMBER | ID z tabeli EWIDENCJA_PESEL | ||
3 | DATA_OD | DATE | Data od kiedy osoba zamieszkiwała posesje | ||
4 | DATA_DO | DATE | data do kiedy osoba zamieszkiwała posesje | ||
5 | ID_POS_EDP | NUMBER | PK dla tabli krzyżowej pomiędzy posesjami a ewidencja pesel | ||
6 | ID | NUMBER | Y | PK tabeli |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_POSESJCJAPE_IDEWP | NORMAL | ID_EWP | <none> | ||||
NON-UNIQUE | IX_POSESJCJAPE_IDPOSESJI | NORMAL | ID_POSESJI | <none> | ||||
UNIQUE | PK_POSESJA_EWID_PESEL_ID | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_POSESJAPESEL_IDEWP | ID_EWP | F_54 | EWIDENCJA_PESEL | ID_EWP | NO ACTION | ENABLED | No | No |
FK_POSESJAPESEL_IDPOS | ID_POSESJI | F_54 | POSESJA | ID_POSESJI | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
PK_POSESJA_EWID_PESEL_ID | Primary Key | ENABLED | ID |
Partitions |
Redaction Policies |