Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table KDR_PRAC_KARIERA_WYLACZENIA | Next Table |
Comment |
---|
Tabela o zawiera informacje o okresach, ktore nie sa brane pod uwage podczas obliczanaia np. stazu pracy |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_WYLACZENIA | NUMBER | Y | id wylaczenia | |
2 | ID_PRAC_KARIERA | NUMBER | id z tabeli kdr_prac_kariera | ||
3 | OPIS | VARCHAR2(255 BYTE) | Y | ospis wylaczenia | |
4 | DATA_OD | DATE | Y | data od wylaczenia | |
5 | DATA_DO | DATE | Y | data do wylaczenia |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX_KDR_PRAC_KARIERA_WYLACZ_PK | NORMAL | ID_WYLACZENIA | <none> | ||||
NON-UNIQUE | IX_KDRPRALACZE_IDPRACKARIERA | NORMAL | ID_PRAC_KARIERA | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_KDR_PRAC_KARIERA_WYLACZEN | ID_PRAC_KARIERA | F_54 | KDR_PRAC_KARIERA | ID_PRAC_KARIERA | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
CH_KDR_PRAC_KARIERA_WYLACZE | Check | DATA_OD <= DATA_DO | ENABLED | DATA_DO, DATA_OD |
NN_KDR_PRAC_KARIERA_WYLACZ_DO | Check | "DATA_DO" IS NOT NULL | ENABLED | DATA_DO |
NN_KDR_PRAC_KARIERA_WYLACZ_ID | Check | "ID_WYLACZENIA" IS NOT NULL | ENABLED | ID_WYLACZENIA |
NN_KDR_PRAC_KARIERA_WYLACZ_OD | Check | "DATA_OD" IS NOT NULL | ENABLED | DATA_OD |
NN_KDR_PRAC_KARIERA_WYLACZ_OPI | Check | "OPIS" IS NOT NULL | ENABLED | OPIS |
PK_KDR_PRAC_KARIERA_WYLACZEN | Primary Key | ENABLED | ID_WYLACZENIA |
Partitions |
Redaction Policies |