Columns of Table SL_KL_ZADANIA
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID |
NUMBER |
Y |
|
|
2 |
ZADANIE |
VARCHAR2(50 BYTE) |
Y |
|
|
3 |
OPIS |
VARCHAR2(512 BYTE) |
Y |
|
|
4 |
OPIS_ROZSZERZONY |
CLOB |
|
|
|
5 |
CEL |
CLOB |
|
|
|
6 |
OSOBA_ODPOWIEDZIALNA |
VARCHAR2(128 BYTE) |
|
|
|
7 |
DOCHODY |
NUMBER |
|
|
|
8 |
WYDATKI |
NUMBER |
|
|
|
9 |
ID_N |
NUMBER |
|
|
|
10 |
RODZAJ |
VARCHAR2(1 BYTE) |
|
|
|
11 |
ROK |
VARCHAR2(4 BYTE) |
|
|
|
Indexes on Table SL_KL_ZADANIA
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
INDX_SL_KL_ZADA_IDN |
NORMAL |
ID_N |
<none> |
|
|
|
|
UNIQUE |
PK_SL_KL_ZADANIA |
NORMAL |
ID |
<none> |
|
|
|
|
Foreign Key Constraints on Table SL_KL_ZADANIA
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_SLKLZADANIA_ZADANIA |
ID_N |
F_54 |
SL_KL_ZADANIA |
ID |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table SL_KL_ZADANIA
Constraint Name |
Type |
Condition |
Status |
Columns |
SYS_C0056464 |
Check |
"ID" IS NOT NULL |
ENABLED |
ID |
SYS_C0056465 |
Check |
"ZADANIE" IS NOT NULL |
ENABLED |
ZADANIE |
SYS_C0056466 |
Check |
"OPIS" IS NOT NULL |
ENABLED |
OPIS |
PK_SL_KL_ZADANIA |
Primary Key |
|
ENABLED |
ID |
Table SL_KL_ZADANIA does not have...
Comments |
Partitions |
Redaction Policies |