Columns of Table WYPOS_P
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_POZ |
NUMBER(8) |
Y |
|
|
2 |
ID_WYP |
NUMBER(8) |
|
|
|
3 |
NR_USLUGI |
NUMBER(9) |
|
|
|
4 |
PRZEL |
NUMBER(8,3) |
|
|
|
5 |
CZESTOSC |
NUMBER(5,2) |
|
|
|
6 |
OKRES |
VARCHAR2(10 BYTE) |
|
|
|
7 |
POJEMNIK |
VARCHAR2(10 BYTE) |
|
|
|
8 |
CZY_OPEKS |
CHAR(1 BYTE) |
|
|
|
Indexes on Table WYPOS_P
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX_WYPOSP_IDWYP |
NORMAL |
ID_WYP |
<none> |
|
|
|
|
NON-UNIQUE |
IX_WYPOSP_NRUSLUGI |
NORMAL |
NR_USLUGI |
<none> |
|
|
|
|
NON-UNIQUE |
IX_WYPOSP_OKRES |
NORMAL |
OKRES |
<none> |
|
|
|
|
NON-UNIQUE |
IX_WYPOSP_POJEMNIK |
NORMAL |
POJEMNIK |
<none> |
|
|
|
|
UNIQUE |
PK_WYPOSP |
NORMAL |
ID_POZ |
<none> |
|
|
|
|
Foreign Key Constraints on Table WYPOS_P
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_WYPOSP_KIT |
NR_USLUGI |
F_54 |
KIT |
NR_KATAL |
NO ACTION |
ENABLED |
No |
No |
FK_WYPOSP_SLOKRESY |
OKRES |
F_54 |
SL_OKRESY |
OKRES |
NO ACTION |
ENABLED |
No |
No |
FK_WYPOSP_SLPOJEMNIKI |
POJEMNIK |
F_54 |
SL_POJEMNIKI |
POJEMNIK |
NO ACTION |
ENABLED |
No |
No |
FK_WYPOSP_WYPOS |
ID_WYP |
F_54 |
WYPOS |
ID_WYP |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table WYPOS_P
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_WYPOSP |
Primary Key |
|
ENABLED |
ID_POZ |
Table WYPOS_P does not have...
Comments |
Partitions |
Redaction Policies |