Columns of Table OBCIAZENIA
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_POZ |
NUMBER(8) |
Y |
|
|
2 |
ID_ANEKSU |
NUMBER(8) |
|
|
|
3 |
NR_KATAL |
NUMBER(9) |
|
|
|
4 |
ILOSC |
NUMBER(10,3) |
|
|
|
5 |
CENA_NETTO |
NUMBER |
|
|
|
6 |
WART_NETTO |
NUMBER(12,2) |
|
|
|
7 |
KWOTA_VAT |
NUMBER(12,2) |
|
|
|
8 |
PR_VAT |
NUMBER(4,2) |
|
|
|
9 |
ID_WYPOS |
NUMBER(8) |
|
|
|
10 |
ID_KLP |
NUMBER(8) |
|
|
|
11 |
PR_RABATU |
NUMBER(5,2) |
|
|
|
Indexes on Table OBCIAZENIA
Uniqueness |
Index Name |
Type |
Columns |
Partitions |
Partition Type |
Partition Columns |
Subpartition Type |
Subpartition Columns |
NON-UNIQUE |
IX1_OBCIAZENIA |
NORMAL |
ID_ANEKSU |
<none> |
|
|
|
|
NON-UNIQUE |
IX2_OBCIAZENIA |
NORMAL |
NR_KATAL |
<none> |
|
|
|
|
UNIQUE |
PK_OBCIAZENIA |
NORMAL |
ID_POZ |
<none> |
|
|
|
|
Foreign Key Constraints on Table OBCIAZENIA
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_OBCIAZENIA_KIT |
NR_KATAL |
F_54 |
KIT |
NR_KATAL |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table OBCIAZENIA
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_OBCIAZENIA |
Primary Key |
|
ENABLED |
ID_POZ |
Table OBCIAZENIA does not have...
Comments |
Partitions |
Redaction Policies |