Columns of Table SKLADNIKI
Column ID |
Column Name |
Datatype |
Not Null |
Data Default |
Comments |
1 |
ID_SKL |
NUMBER(8) |
Y |
|
|
2 |
NR_SKL |
NUMBER(8) |
|
|
|
3 |
SKROT |
VARCHAR2(12 BYTE) |
|
|
|
4 |
OPIS |
VARCHAR2(60 BYTE) |
|
|
|
5 |
K_OBR |
CHAR(1 BYTE) |
|
|
|
6 |
STATUS |
CHAR(1 BYTE) |
|
|
|
7 |
TYP |
CHAR(1 BYTE) |
|
|
|
8 |
WYSWIETLANY |
CHAR(1 BYTE) |
|
|
|
9 |
POPRAWIANIE |
CHAR(1 BYTE) |
|
|
|
10 |
ALGORYTM |
VARCHAR2(256 BYTE) |
|
|
|
11 |
ILOSC_M |
NUMBER(8) |
|
|
|
12 |
WARTOSC |
NUMBER(12,2) |
|
|
|
13 |
ALGORYTM_PO |
VARCHAR2(256 BYTE) |
|
|
|
14 |
ZAOKRAGLANIE |
NUMBER(8) |
|
2 |
|
15 |
AKTYWNY |
CHAR(1 BYTE) |
|
|
|
16 |
TYP_SKL |
CHAR(1 BYTE) |
|
'N' |
|
17 |
WARTOSC_D |
DATE |
|
|
|
18 |
WARTOSC_N |
NUMBER(16,2) |
|
|
|
19 |
WARTOSC_T |
VARCHAR2(30 BYTE) |
|
|
|
20 |
ZAPYTANIE |
VARCHAR2(512 BYTE) |
|
|
|
21 |
JM |
NUMBER(3) |
|
|
|
Foreign Key Constraints on Table SKLADNIKI
Constraint Name |
Columns |
Ref Table Owner |
Referenced Table Name |
Referenced Columns |
Delete Rule |
Status |
Deferrable |
Deferred |
FK_SKLADNIKI_JM |
JM |
F_54 |
JM |
KOD_JM |
NO ACTION |
ENABLED |
No |
No |
PK, UK, & Check Constraints on Table SKLADNIKI
Constraint Name |
Type |
Condition |
Status |
Columns |
PK_SKLADNIKI |
Primary Key |
|
ENABLED |
ID_SKL |
UK_SKLADNIKI_NRSKL |
Unique |
|
ENABLED |
NR_SKL |
UK_SKLADNIKI_SKROT |
Unique |
|
ENABLED |
SKROT |
Table SKLADNIKI does not have...
Comments |
Partitions |
Redaction Policies |