 |
 |
|
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).
PM_EVENTS
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 bitwise 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 |
PM_PRICES
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 |
PM_PRINTERS
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 |
PM_USERS
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 |
 |
|
Copyright
© 1999-2012, AGG Software. |