Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table AZ_ULICE | Next Table |
Comment |
---|
SĹ?ownik ulic dla prgramu oczyszczanie Ĺ?Ä?czÄ?cy nazwy ulic z ich opisem |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | ||
2 | ID_ULICY | NUMBER | Y | ||
3 | OPIS | VARCHAR2(1023 BYTE) | |||
4 | TYP | VARCHAR2(1 BYTE) |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
UNIQUE | AZ_ULICE_PK | NORMAL | ID | <none> | ||||
NON-UNIQUE | IX_AZULIC_TYP | NORMAL | TYP | <none> | ||||
UNIQUE | UQ_AZ_ULICE | NORMAL | ID_ULICY, OPIS | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_AZ_ULICE_AZ_SL_TYPY_ULIC | TYP | F_54 | AZ_SL_TYPY_ULIC | SKROT | NO ACTION | ENABLED | No | No |
FK_AZ_ULICE_ULICE | ID_ULICY | F_54 | ULICE | ID_UL | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054557 | Check | "ID" IS NOT NULL | ENABLED | ID |
SYS_C0054558 | Check | "ID_ULICY" IS NOT NULL | ENABLED | ID_ULICY |
AZ_ULICE_PK | Primary Key | ENABLED | ID | |
UQ_AZ_ULICE | Unique | ENABLED | ID_ULICY, OPIS |
Partitions |
Redaction Policies |