Columns of Table DOWODY_PSU
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_DOWODU1 |
NUMBER(8) |
Y |
|
|
2 |
ID_POZ2 |
NUMBER(8) |
Y |
|
|
3 |
MAGAZYN |
NUMBER(3) |
|
|
|
4 |
DATA_DO |
DATE |
|
|
|
5 |
DATA_AKCEPT |
DATE |
|
|
|
6 |
NR_KATAL |
NUMBER(9) |
|
|
|
7 |
ILOSC |
NUMBER(10,3) |
|
|
|
8 |
JM_PODST |
NUMBER(3) |
|
|
|
9 |
ILOSC_BPZ |
NUMBER(10,3) |
|
|
|
10 |
ID_DOWODU_PZ |
NUMBER(8) |
|
|
|
Indexes on Table DOWODY_PSU
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX1_DOWODYPSU |
NORMAL |
NR_KATAL |
<none> |
|
|
|
|
NON-UNIQUE |
IX_DOWODYOWODY_JMPODST |
NORMAL |
JM_PODST |
<none> |
|
|
|
|
UNIQUE |
PK_DOWODYPSU |
NORMAL |
ID_DOWODU, ID_POZ |
<none> |
|
|
|
|
Foreign Key Constraints on Table DOWODY_PSU
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_DOWODYPSU_DOWODY |
ID_DOWODU |
F_54 |
MAG_DOWODY |
ID_DOWODU |
NO ACTION |
ENABLED |
No |
No |
FK_DOWODYPSU_JM |
JM_PODST |
F_54 |
JM |
KOD_JM |
NO ACTION |
ENABLED |
No |
No |
FK_DOWODYPSU_KIT |
NR_KATAL |
F_54 |
KIT |
NR_KATAL |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table DOWODY_PSU
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_DOWODYPSU |
Primary Key |
|
ENABLED |
ID_DOWODU, ID_POZ |
Table DOWODY_PSU does not have...
Comments |
Partitions |
Redaction Policies |