Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table SKAZANI_SPRAWY | Next Table |
Comment |
---|
sprawy przypisane do skazanych |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_SPRAWY | NUMBER(6) | Y | id sprawy | |
2 | ID_SKAZ | NUMBER(8) | Y | id skazanego, z ktoreym zwiazana jest sprawa | |
3 | NR_SPRAWY | VARCHAR2(100 BYTE) | numer sprawy | ||
4 | SYGNATURA | VARCHAR2(100 BYTE) | sygnatura sprawy | ||
5 | WYMIAR_KARY_MIESIACE | NUMBER(6) | ilosc miesiecy kary | ||
6 | WYMIAR_KARY_GODZINY | NUMBER(6) | ilosc godzin kary w miesiacu | ||
7 | DATA_ROZP_WYKONYWANIA | DATE | data rozpoczecia wykonywania kary | ||
8 | DATA_ZAK_WYKONYWANIA | DATE | data zakonczenia wykonywania kary | ||
9 | ID_STANU | NUMBER(6) | Y | stan sprawy (aktualne, zakonczone, przedawnione) (z tabeli stany) | |
10 | UWAGI | VARCHAR2(200 CHAR) | uwagi dotyczace sprawy | ||
11 | LP | VARCHAR2(10 CHAR) | numer sprawy nadawany przez wprowadzajacego |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_SKAZANNISPR_IDSKAZ | NORMAL | ID_SKAZ | <none> | ||||
NON-UNIQUE | IX_SKAZANNISPR_IDSTANU | NORMAL | ID_STANU | <none> | ||||
UNIQUE | SKAZANI_SPRAWY_PK | NORMAL | ID_SPRAWY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_SPRAWY_SKAZANI | ID_SKAZ | F_54 | SKAZANI | ID_SKAZ | NO ACTION | ENABLED | No | No |
FK_SPRAWY_STANY | ID_STANU | F_54 | SKAZANI_SPRAWY_STANY | ID_STANU | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054827 | Check | "ID_SPRAWY" IS NOT NULL | ENABLED | ID_SPRAWY |
SYS_C0054828 | Check | "ID_SKAZ" IS NOT NULL | ENABLED | ID_SKAZ |
SYS_C0054829 | Check | "ID_STANU" IS NOT NULL | ENABLED | ID_STANU |
SKAZANI_SPRAWY_PK | Primary Key | ENABLED | ID_SPRAWY |
Partitions |
Redaction Policies |