Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table PRAC_ADRESY_DZIALANIA | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ADR_DZIAL_EMAIL | VARCHAR2(30 BYTE) | |||
2 | ADR_DZIAL_FAX | VARCHAR2(12 BYTE) | |||
3 | ADR_DZIAL_TELEFON | VARCHAR2(12 BYTE) | |||
4 | ADR_DZIAL_NR_LOKALU | VARCHAR2(7 BYTE) | |||
5 | ADR_DZIAL_NR_BUDYNKU | VARCHAR2(7 BYTE) | |||
6 | ADR_DZIAL_ULICA | VARCHAR2(30 BYTE) | |||
7 | ADR_DZIAL_POCZTA | VARCHAR2(26 BYTE) | |||
8 | ADR_DZIAL_MIEJSCOWOSC | VARCHAR2(26 BYTE) | |||
9 | ADR_DZIAL_KOD_POCZTOWY | VARCHAR2(5 BYTE) | |||
10 | ID_ADRESU | NUMBER | Y | ||
11 | ADR_NOWY_KONIEC | NUMBER | |||
12 | ADR_DZIAL_ID_MIEJSCOWOSC | NUMBER | Siedziba: id miejscowosci | ||
13 | ADR_DZIAL_ID_ULICA | NUMBER | Siedziba: id ulicy |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_PRACADZIALA_ADRDZIALIDMIEJ | NORMAL | ADR_DZIAL_ID_MIEJSCOWOSC | <none> | ||||
NON-UNIQUE | IX_PRACADZIALA_ADRDZIALIDULIC | NORMAL | ADR_DZIAL_ID_ULICA | <none> | ||||
UNIQUE | PK_PRAC_ADRESY_DZIALANIA | NORMAL | ID_ADRESU | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_PRAC_ADR_DZIAL_ID_DZI_MIA | ADR_DZIAL_ID_MIEJSCOWOSC | F_54 | MIASTA | ID_MSC | NO ACTION | ENABLED | No | No |
FK_PRAC_ADR_DZIAL_ID_DZI_UL | ADR_DZIAL_ID_ULICA | F_54 | ULICE | ID_UL | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054731 | Check | "ID_ADRESU" IS NOT NULL | ENABLED | ID_ADRESU |
PK_PRAC_ADRESY_DZIALANIA | Primary Key | ENABLED | ID_ADRESU |
Comments |
Partitions |
Redaction Policies |