<< Click to Display Table of Contents >> Navigation: Program use > Configuration > Printer monitor settings > Database structure |
You can select the option of preparing a database during the installation of the program. A database with the following structure is created in this case (a MySQL sample database). Anyway, scripts for creating a database are added to the data folder in the program folder (one file for every database type).
This table contains all data by received events. Reports will be based on this data.
Column name |
Data type |
Size |
Cannot be empty |
Description |
PE_ID |
INTEGER |
10 |
Unique event identifier |
|
PE_DATE1 |
DATETIME |
0 |
Event date and time |
|
PE_CLASS |
VARCHAR |
20 |
Event class: JOB - print job, PRINTER - printer |
|
PE_PRINTER |
VARCHAR |
80 |
Printer name (network printer name) |
|
PE_PRINTER_NAME |
VARCHAR |
80 |
|
Full printer name (network printer name) |
PE_MACHINE_NAME |
VARCHAR |
50 |
|
The name of the computer where the printer is located |
PE_PRINTER_ID |
INTEGER |
11 |
|
Printer identifier from the PM_PRINTERS table. Updated when reports are printed. |
PE_USER_NAME |
VARCHAR |
50 |
|
The name of the user who added the print job |
PE_STATUS_FLAGS |
INTEGER |
11 |
|
Print job flags. The number is a bit-wise mask |
PE_STATUS |
VARCHAR |
80 |
|
The PE_STATUS_FLAGS field translated into a string |
PE_DOCUMENT |
VARCHAR |
128 |
|
Printed document name |
PE_SUBMITTED |
DATETIME |
0 |
|
Date and time when the document was sent to the printer |
PE_TOTAL_PAGES |
INTEGER |
11 |
|
Total number of pages in the document |
PE_PAGES_PRINTED |
INTEGER |
11 |
|
Printed pages |
PE_SERVER_NAME |
VARCHAR |
50 |
|
Contains the name of the computer where the printer is located for events of the "PRINTER" type |
PE_SHARE_NAME |
VARCHAR |
50 |
|
Contains the network printer name for events of the "PRINTER" type |
PE_COMMENT |
VARCHAR |
50 |
|
Comments |
PE_LOCATION |
VARCHAR |
50 |
|
Printer location |
PE_SEPFILE |
VARCHAR |
50 |
|
The name of the file that was used to create a page separating print jobs |
PE_PRINT_PROCESSOR |
VARCHAR |
50 |
|
Print processor type: EMF, RAW or TEXT |
PE_PARAMETERS |
VARCHAR |
50 |
|
Print processor parameters |
PE_DATATYPE |
VARCHAR |
50 |
|
Data type used to write print jobs |
PE_ATTRIBUTES |
VARCHAR |
125 |
|
Printer properties |
PE_PRIORITY |
VARCHAR |
15 |
|
Print job priority in the queue |
PE_DEFAULT_PRIORITY |
VARCHAR |
15 |
|
Default priority |
PE_START_TIME |
DATETIME |
0 |
|
Date and time the print job must not be printed earlier |
PE_UNTIL_TIME |
DATETIME |
0 |
|
Date and time the print job must not be printed later |
PE_STATUS_STRING |
VARCHAR |
50 |
|
Print job status |
PE_CJOBS |
INTEGER |
11 |
|
Number of print jobs at the printer at the moment when the event occurred |
PE_AVERAGE_PPM |
INTEGER |
11 |
|
Average number of pages per minute |
PE_NOTIFY_NAME |
VARCHAR |
50 |
|
The name of the user who must be notified when a job is finished or an error occurs |
PE_DRIVER_NAME |
VARCHAR |
50 |
|
Printer driver name |
PE_POSITION |
INTEGER |
11 |
|
Print job position in the queue |
PE_TIME |
INTEGER |
11 |
|
Seconds after the moment the printing was started |
PE_TOTAL_BYTES |
INTEGER |
11 |
|
Bytes sent |
PE_BYTES_PRINTED |
INTEGER |
11 |
|
Bytes printed |
PE_PAPERSIZE_TYPE |
INTEGER |
11 |
|
Paper type amount |
PE_PAPERSIZE |
VARCHAR |
50 |
|
Paper type |
PE_PAPERLENGTH |
INTEGER |
11 |
|
Paper length |
PE_PAPERWIDTH |
INTEGER |
11 |
|
Paper width |
PE_COPIES |
INTEGER |
11 |
|
Copies |
PE_PRINTQUALITY |
VARCHAR |
12 |
|
Print quality (DPI) |
PE_COLOR |
INTEGER |
11 |
|
Color printing flag |
PE_ORIENTATION |
VARCHAR |
12 |
|
Page orientation |
PE_DUPLEX |
INTEGER |
11 |
|
Duplex printing flag |
PE_MEDIATYPE |
VARCHAR |
32 |
|
Paper type |
PE_SHEETS_PRINTED |
INTEGER |
11 |
|
Sheets printed |
The table contains the description of print cost for printers
Column name |
Data type |
Size |
Cannot be empty |
Description |
PPR_ID |
INTEGER |
10 |
Unique price identifier |
|
PPR_PRINTER_ID |
INTEGER |
11 |
Unique printer identifier |
|
PPR_DATE1 |
DATETIME |
0 |
Price activation date |
|
PPR_DATE2 |
DATETIME |
0 |
|
Price expiration date |
PPR_PAPERSIZE |
INTEGER |
11 |
|
Paper size |
PPR_PRINTQUALITY |
VARCHAR |
20 |
|
Print quality |
PPR_COST_BW |
FLOAT |
0 |
|
Black-and-white printing price |
PPR_COST_COLOR |
FLOAT |
0 |
|
Color printing price |
PPR_CURR |
VARCHAR |
20 |
|
Currency |
The table contains printer descriptions
Name |
Data type |
Size |
Cannot be empty |
Description |
PP_ID |
INTEGER |
10 |
Unique printer identifier |
|
PP_HOST |
VARCHAR |
80 |
|
Computer name |
PP_NAME |
VARCHAR |
80 |
|
Printer name |
PP_DESC |
VARCHAR |
128 |
|
Printer description |
PP_DATE |
DATETIME |
0 |
|
Printer addition date |
PP_ACTIVE |
BIT |
1 |
Active printer flag |
|
PP_UPDATED |
BIT |
1 |
|
Updated printer and PM_EVENTS page update is required flag |
The table contains the description of built-in web server users
Name |
Data type |
Size |
Cannot be empty |
Description |
PU_ID |
INTEGER |
10 |
Unique user identifier |
|
PU_LOGIN |
VARCHAR |
50 |
Username |
|
PU_PASS |
VARCHAR |
50 |
|
Password |
PU_DATE |
DATETIME |
0 |
|
Updated user date |
PU_ALLOW_LOGIN |
BIT |
1 |
Allow authentication |
|
PU_ALLOW_FAV |
BIT |
1 |
Allow favorite reports |
|
PU_ALLOW_CUST |
BIT |
1 |
Allow random reports |
|
PU_ALL_DATA |
BIT |
1 |
Access to data for all users |