Table Documents_events table
Description
Allows to store information related to the transformation of spools and redirection between files.
Schema
|
Field |
Type |
Required |
Primary key |
Description |
|
docID |
bigint |
* |
|
internal identifier of the document |
|
evtTYPE |
int |
* |
|
Type of event type applied to the document 0=invalid (none), 1=transformation, 2=redirection, 3=notification |
|
docevtTIMESTAMP |
datetime2(3) |
* |
|
date (précise) of the event |
|
docevtFILTER |
varchar(64) |
|
|
last filter (configured in Watchdoc) applied to the event |
|
docevtSAVINGS |
float |
|
|
savings (positive or negative). |
|
docevtMOVED |
tinyint |
|
|
event of the document replicated on the database of another server (except Master server) |
|
docevtOBJECTID |
varchar(255) |
|
|
used only in case of redirection, contains the id of the source file |
|
docevtORIGIN |
varchar(255) |
|
|
? |
|
docevtFIELD |
tinyint |
|
|
in the case of a transformation, contains the type of transformation 0=invalid , 1=color to b&w, 2=simplextoduplex, 3=duplextosimplex, 4=chgemt of the number of ex, 5=cutting of color page, 6=cutting (deletion) of mono page, 7=redirection |
|
docevtVALUE |
int |
|
|
(linked to Field and has a different meaning depending on the nature of the field) contains the value corresponding to the event applied to the document. |
|
docevtPREVIOUS |
int |
|
|
value before the event |
|
docevtFLAG |
tinyint |
|
|
allows you to know, in the case of a transfer, if it is the user who has accepted the transfer 0=none, 1=spontaneous (at the initiative of the user), 2=suggested and refused, 3=suggested and accepted, 4=forced |
|
docevtAMOUNT |
float |
|
|
RFU |
|
docevtTEXT |
varchar(255) |
|
|
RFU |
|
docevtEXTRA |
ntext |
|
|
RFU |