Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table PRAC_PIT_WARTOSCI | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_PRAC | NUMBER | Y | id pracownika | |
2 | K36 | NUMBER | Wartosc pola nr 36 | ||
3 | K37 | NUMBER | |||
4 | K39 | NUMBER | |||
5 | K40 | NUMBER | |||
6 | K41 | NUMBER | |||
7 | K42 | NUMBER | |||
8 | K44 | NUMBER | |||
9 | K45 | NUMBER | |||
10 | K47 | NUMBER | |||
11 | K48 | NUMBER | |||
12 | K50 | NUMBER | |||
13 | K51 | NUMBER | |||
14 | K53 | NUMBER | |||
15 | K54 | NUMBER | |||
16 | K55 | NUMBER | |||
17 | K57 | NUMBER | |||
18 | K58 | NUMBER | |||
19 | K59 | NUMBER | |||
20 | K61 | NUMBER | |||
21 | K62 | NUMBER | |||
22 | K63 | NUMBER | |||
23 | K65 | NUMBER | |||
24 | K66 | NUMBER | |||
25 | K67 | NUMBER | |||
26 | K69 | NUMBER | |||
27 | K70 | NUMBER | |||
28 | K71 | NUMBER | |||
29 | K73 | NUMBER | |||
30 | K74 | NUMBER | |||
31 | K75 | NUMBER | |||
32 | K77 | NUMBER | |||
33 | K78 | NUMBER | |||
34 | K80 | NUMBER | |||
35 | K81 | NUMBER | |||
36 | K82 | NUMBER | |||
37 | K83 | NUMBER | |||
38 | K84 | NUMBER | |||
39 | ROK | NUMBER | Y | 2008 | Za ktory rok sa te wartosci |
40 | DT_OD | DATE | pole 4 - za okres | ||
41 | DT_DO | DATE | pole 5 - data do |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX_PRACPIWARTO_IDPRAC | NORMAL | ID_PRAC | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_PRACPITWART_PRACOWNICY | ID_PRAC | F_54 | PRACOWNICY | ID_PRAC | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0054767 | Check | "ID_PRAC" IS NOT NULL | ENABLED | ID_PRAC |
SYS_C0054768 | Check | "ROK" IS NOT NULL | ENABLED | ROK |
Comments |
Partitions |
Redaction Policies |