Columns of Table WYPOS
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_WYP |
NUMBER(8) |
Y |
|
|
2 |
OPIS |
VARCHAR2(60 BYTE) |
|
|
|
3 |
UM_INFO |
VARCHAR2(60 BYTE) |
|
|
|
4 |
KOD_UMOWY |
CHAR(2 BYTE) |
|
|
|
5 |
OKRES |
VARCHAR2(10 BYTE) |
|
|
|
Indexes on Table WYPOS
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX_WYPOS_KODUMOWY |
NORMAL |
KOD_UMOWY |
<none> |
|
|
|
|
NON-UNIQUE |
IX_WYPOS_OKRES |
NORMAL |
OKRES |
<none> |
|
|
|
|
UNIQUE |
PK_WYPOS |
NORMAL |
ID_WYP |
<none> |
|
|
|
|
Foreign Key Constraints on Table WYPOS
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_WYPOS_SLOKRESY |
OKRES |
F_54 |
SL_OKRESY |
OKRES |
NO ACTION |
ENABLED |
No |
No |
FK_WYPOS_SLUMOWYWYPOS |
KOD_UMOWY |
F_54 |
SL_UMOWY_WYPOS |
KOD_UMOWY |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table WYPOS
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_WYPOS |
Primary Key |
|
ENABLED |
ID_WYP |
Table WYPOS does not have...
Comments |
Partitions |
Redaction Policies |