Columns of Table SKLADNIKI_P
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_SKL1 |
NUMBER(8) |
Y |
|
|
2 |
NR_KOL2 |
NUMBER(8) |
Y |
|
|
3 |
SKROT |
VARCHAR2(12 BYTE) |
|
|
|
4 |
WARTOSC |
VARCHAR2(30 BYTE) |
|
|
|
5 |
WARUNEK |
CHAR(1 BYTE) |
|
'N' |
|
Indexes on Table SKLADNIKI_P
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX_SKLADNLADNI_SKROT |
NORMAL |
SKROT |
<none> |
|
|
|
|
UNIQUE |
PK_SKLADNIKIP |
NORMAL |
ID_SKL, NR_KOL |
<none> |
|
|
|
|
Foreign Key Constraints on Table SKLADNIKI_P
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_SKLADNIKIP_SKLADNIKI |
ID_SKL |
F_54 |
SKLADNIKI |
ID_SKL |
NO ACTION |
ENABLED |
No |
No |
FK_SKLADNIKIP_SKLADNIKI1 |
SKROT |
F_54 |
SKLADNIKI |
SKROT |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table SKLADNIKI_P
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_SKLADNIKIP |
Primary Key |
|
ENABLED |
ID_SKL, NR_KOL |
Table SKLADNIKI_P does not have...
Comments |
Partitions |
Redaction Policies |