AGG Software
Ask a question  Top  Previous  Next

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).

 

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

yes

Unique event identifier

PE_DATE1

DATETIME

0

yes

Event date and time

PE_CLASS

VARCHAR

20

yes

Event class: JOB – print job, PRINTER - printer

PE_PRINTER

VARCHAR

80

yes

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

yes

Unique price identifier

PPR_PRINTER_ID

INTEGER

11

yes

Unique printer identifier

PPR_DATE1

DATETIME

0

yes

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

yes

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

yes

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

yes

Unique user identifier

PU_LOGIN

VARCHAR

50

yes

Username

PU_PASS

VARCHAR

50

 

Password

PU_DATE

DATETIME

0

 

Updated user date

PU_ALLOW_LOGIN

BIT

1

yes

Allow authentication

PU_ALLOW_FAV

BIT

1

yes

Allow favorite reports

PU_ALLOW_CUST

BIT

1

yes

Allow random reports

PU_ALL_DATA

BIT

1

yes

Access to data for all users




Copyright © 1999-2016, AGG Software.
All rights reserved.