LogDB Table Structure

fine_record_execute

BI Execution Report

fine_record_login

Login table

fine_record_email

Email table

fine_record_write

Filling table

fine_record_param

Common parameter combination table

fine_record_sms

SMS sending table

fine_record_operate

Management log table

fine_record_sql

SQL execution table

fine_record_gc

GC record table

fine_record_conf

Partial configuration information table

fine_record_lock

User lock log table

fine_record_security

Illegal Session Alert Table

fine_container_entity

Container information table

fine_function_process

Function point information table

fine_operation_process_log

Cloud O&M log table

fine_schedule_record

Task schedule execution log table

fine_intelli_focus_point

Function tracking table

fine real time usage

Application real-time status table

fine_intelli_consume_point

Performance information table

fine_record_open_client_api

Interface and Application ID

fine_cloud_execution_record

Cloud Ops Execution Record

fine_template_error

Execution error log

fine_record_logout

Logout table

For versions 11.0.13 and later, this table is deprecated, and its content is now recorded in fine_record_login

fine_record_error

Execution error log table

For versions 11.0.1 and later, this table is deprecated, and its content is now recorded in fine_template_error

fine_operation_shutdown_record

Semaphore information table

This table is deprecated, and its content is now recorded in fine_intelli_focus_point

fine_plugin_usage

Plugin information table

This table is deprecated, and its content is now recorded in fine_intelli_focus_point

fine_tpl_info

Template attribute table

This table is deprecated

uuid

Unique identifier field

VARCHAR

time

Log start time

BIGINT

id

Primary key

VARCHAR

tname

Template Name

Records the actual storage location of the template, i.e., the full path under reportlet

VARCHAR

forkId

Reused ID

Records the ID of the template reused by the current template

For example, when creating a new template A, and template A is copied/saved as template B

· 

When accessing template A, forkId is empty, meaning no template is reused

· 

· 

When accessing template B, forkId is the ID of template A, meaning template A is reused

· 

VARCHAR

displayName

The name of the directory mounted to the platform (excluding the parent directory or full path)

If the template is accessed directly via a link, this field is empty

VARCHAR

type

Report access method

For details, see the following table.

INTEGER

param

Parameter

VARCHAR

ip

IP address for report execution

VARCHAR

username

User who execute reports

VARCHAR

userrole

The user identity (department, role, etc.) executing the report

VARCHAR

consume

Execution time consumption

Includes SQL execution time and report calculation time.

The unit is ms.

BIGINT

sql

SQL clause

VARCHAR

sqlTime

Total SQL execution time

BIGINT

browser

Version of the browser used by the client to access reports

The access terminal can be determined by the terminal field in this column

browser: browser type/version

OSInfo: operating system, which can be Windows, Mac, and Unix.

terminal: client identifier, which can be App, H5, and empty value.

· 

App: Accessed the platform via the Data Analysis App and viewed the template in the platform directory

· 

· 

H5: Accessed the platform via WeChat integration and viewed the template in the platform directory

· 

· 

Null value: Access platform directory or template via PC, access single template via HTML5

· 

VARCHAR

memory

Report-occupied memory, in byte

· 

If calculation is interrupted due to downtime, it records the memory occupied from the start of report calculation to the interruption (estimated by cell count, with 0.2KB per cell)

· 

· 

When the template's complete field value is 0, it is recorded as 0 here

· 

· 

If calculation is completed, the recorded data divided by 200 returns the number of cells generated from the start to the completion of report calculation

· 

BIGINT

reportId

Template ID

VARCHAR

userId

User ID

VARCHAR

complete

Calculation complete or not

· 

0: Calculation interrupted due to downtime

· 

· 

1: Calculation completed

· 

INTEGER

source

Access method

· 

integration: access through URL

· 

· 

single: platform access

· 

VARCHAR

session ID

Session ID

Associates with event tracking related to frontend rendering time consumption in the performance tracking table (fine_intelli_consume_point).

VARCHAR

Node

Name of the node loading templates

Need to export the treasure package. For details, see: Cloud operation and maintenance steps

VARCHAR

error

First error message during template execution

Need to export the treasure package. For details, see: Cloud operation and maintenance steps

VARCHAR

webInfo

Template execution information

Recorded in array format: {"webResolution":"x*y","fullScreen":0}

· 

webResolution: device resolution during frontend access, in x*y record format

· 

· 

fullScreen: Whether it is in full-screen mode during frontend access, 1 for full-screen/0 for non-full-screen

· 

VARCHAR

lastMod

Last template modification time

BIGINT

detail

Records the detailed information of the shared FineBI dashboard

VARCHAR

fineMarkId

ID of the device used to preview template

VARCHAR

estimate

Records the actual estimated memory, in kb

BIGINT

frFullVersion

FineReport Version

VARCHAR

biFullVersion

FineBI Version

VARCHAR

cloudVersion

Cloud O&M version

VARCHAR

0

Pagination preview

1

Online analysis

2

Data entry preview

3

Dashboard preview

4

Row-based engine

5

Online editing (historically used, currently deprecated)

6

New data entry (historically used, currently deprecated)

7

New engine preview

8

FVS Visualization Dashboard Preview

9

Developer debugging preview

10

Exporting as Excel by page

11

Exporting as Excel

12

Exporting the entire Excel page, which corresponds to the following scenarios:

1. Exporting as Excel by the big dataset export plugin

2. Excel pagination export and Excel unaltered export with the row-based engine enabled

13

Page-based exporting as Excel by sheet

14

Exporting as PDF

15

Exporting as Word

16

Exporting as SVG

17

Exporting as CSV

18

Text export

19

Exporting as JPG

20

Exporting as PNG

21

Exporting as GIF

22

Exporting as BMP

23

Exporting as WBMP

24

Exporting templates from built-in datasets

25

Exporting as HTML

26

Exporting filled tables as HTML

27

Exporting as Excel from FineBI

30

Flash printing

31

PDF printing

32

Applet printing

33

No Client Printing

34

Local printing

101

View BI template

102

Edit BI template

1) Recording logic:

· 

Open a dashboard to enter edit mode, wait for the page to fully load, record once regardless of how many operations are performed or not;

· 

· 

Next time you click the template to edit or refresh the webpage, record the second time

· 

(2) The system records each time you edit the same dashboard.

103

Share BI template

104

Create BI public link

105

View BI public link

106

Exporting FineBI templates globally as PDF

107

Exporting FineBI templates globally as Excel

108

Exporting FineBI components as Excel

109

Saving BI templates as

201

Browser/Tab page closing (FineBI)

202

Editing self-service datasets

203

Sharing self-service datasets

204

Disabling self-service dataset sharing

205

Disable sharing BI template.

206

Closing BI public links

301

Component preview

302

Editing components

401

Excel plugin template preview

402

Editing Excel plugin-made templates (reserved)

403

Sharing Excel plugin-made templates

404

Creating public links for Excel plugins

405

Accessing Excel plugin templates via public links

408

Exporting Excel components as Excel

409

Saving Excel dashboards as

uuid

Unique identifier field

VARCHAR

time

Login time

BIGINT

ip

Login IP address

VARCHAR

username

Login user

VARCHAR

userrole

Login user role

VARCHAR

actionMethod

Login method

-1: Unavailable log in to method

0: Default login

1: Cross-domain login

2: Remote design

3: Third party

4: Mobile terminal

INTEGER

actionType

Operation type

0: Login

1: Logout

2: Overtime (timeout logout)

3: Keep login

INTEGER

authMethod

Authentication method

-1: Unavailable authentication method

0: Password

1: Verification code

2: Integration

INTEGER

actionResult

Operation result

0: Successful

1: Failed

INTEGER

uuid

Unique identifier field

VARCHAR

sender

Sender's username

VARCHAR

receiver

Recipient's username

VARCHAR

mail

Recipient maibox box

VARCHAR

ip

IP address for sending the email

VARCHAR

username

User sending the email

VARCHAR

tname

Template Name

Full path under reportlet

VARCHAR

displayName

Mounted directory name on the platform (excluding parent directory or full path)

Empty if accessing the template directly via link

VARCHAR

content

Mail Content

VARCHAR

time

Sending time

BIGINT

result

Email sent successfully or not

BIT

detail

Details

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

ip

IP address for data entry report

VARCHAR

username

User who fill in reports

VARCHAR

tname

Template Name

Records the actual storage location of the template, i.e., the full path under reportlet

VARCHAR

displayName

Mounted directory name on the platform (excluding parent directory or full path)

Empty if accessing the template directly via link

VARCHAR

sql

Internal use

The content recorded here is not the SQL statement for data entry

VARCHAR

sqlTime

Total SQL execution time

BIGINT

browser

Type and version of the browser used by the client to access reports

VARCHAR

result

Filling successful or not

0: Failed

1: Successful

BIT

detail

Internal use

The content recorded here is not the specific values for data entry

VARCHAR

consume

Execution time consumption

Includes SQL execution time and report calculation time.

VARCHAR

body

JSON data structure, recording the following information:

(1) key: fixed identifier of the request

(2) value: (times, max, min, avg)

· 

times: occurrence times of requests of this type

· 

· 

max: maximum response time for requests of this type, in milliseconds

· 

· 

min: minimum response time for requests of this type, in milliseconds

· 

· 

avg: average response time for requests of this type, in milliseconds

· 

VARCHAR

frFullVersion

FineReport Version

VARCHAR

biFullVersion

FineBI Version

VARCHAR

cloudVersion

Cloud O&M version

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Record time

BIGINT

templateid

Template ID

VARCHAR

username

Username

VARCHAR

pgroup

Common Parameter or Templates

Encrypted parameter values, displayed in array format

{Parameter 1: Value, Parameter 2: Value}

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

receiver

Recipient's username

VARCHAR

MOBILE

Recipient's phone number

VARCHAR

content

Mail Content

VARCHAR

result

Email sent successfully or not

BIT

detail

Details

VARCHAR

sender

Sender's username

VARCHAR

uuid

Unique identifier field

VARCHAR

time

User's operation time

BIGINT

type

Module (storing internationalization keys)

VARCHAR

item

Setting Item

VARCHAR

resource

Accessed Resource

VARCHAR

operate

Operation/Function

VARCHAR

username

Username

VARCHAR

ip

User's IP address

VARCHAR

detail

Details

VARCHAR

requestParam

Request parameter

VARCHAR

platformDisplay

Whether to display in "Management System > Intelligent Operations > Platform Logs"

0: Do not display

1: Display

INTEGER

STATUS

Operation successful or failed

0: Failed

1: Successful

INTEGER

Dec-Platform_Directory_Manage

Directory Management

Dec-Directory: Directory

Dec-Platform_Template: Report Template

Dec-Log_Update: Update

Dec-Log_Add: Add Dec-Log_Delete: Delete

Dec-Log_Auto_Clean: Auto Clean

Dec-Module-User_Manager

User Management

Dec-User

Dec-Log_Add: Add user Dec-User_Enable: Enable user

Dec-Module-Privilege_Manager

Permission Management

Dec-Basic_Global_Settings

Dec-Authority_Set

Dec-Log_Recover_Inherit_Authority

Dec-Log_Update: Update

Dec-Log_Add: Add Dec-Log_Delete: Delete

Dec-Module-Management_BI_Publish

Publication Management

BI-Tool_Data_Manage_Title

Public Data Management

Dec-Module-Look_And_Feel

Appearance Configuration

Dec-Look_Login_Page

Dec-Log_Update

Dec-Manage_PlatformModule

System Management

Dec-Basic_Login

Dec-System_SMS

Dec-Log_Open

Dec-Log_Close

Dec-Log_Update

Dec-Module-Simple_Scheduler

Task schedule

Fine-Schedule_Task

Dec-Log_Update: Update

Dec-Log_Add: Add Dec-Log_Delete: Delete

Dec-Log_Execute: Execute

Dec-Mobile_Plate

Mobile Platform

Dec-Mobile-Platform-Module_Directory

Dec-Log_Open

Dec-Log_Close

Dec-Module-Simple_Register

Registration Management

Dec-Basic_Global_Settings

Dec-Register_Info

Dec-Log_Export

Dec-Log_Update

Dec-Common-Help_Intelligence_Operation

Intelligent O&M

Dec-Data_Connection

Data Connection

Dec-Data_Connection_Manage

Dec-Data_Connection

Dec-Server_Table_Data

Dec-Basic_Preview

Dec-Log_Test_Connection

Dec-Log_Add

Dec-Management_Plugin

Plugin management

Dec-Management_Plugin

Dec-Log_Update: Update

Dec-Log_Add: Add Dec-Log_Delete: Delete

Dec-Module-Security_Management

Security Management

Dec-Module-Template_Management

Template Authentication

Dec-Module-Management_Map

Map Configuration

Dec-BI_Resource_Handover

Resource Handover

ESD_Title

/

ESD_Global-Config

Dec-Log_Update

uuid

Unique identifier field

VARCHAR

time

Record time

BIGINT

executeid

Execution batch ID

Same batch ID used for batch-executed SQL clauses during each preview/query)

VARCHAR

dsName

Dataset name

VARCHAR

sqlTime

Total SQL execution time

Unit: milliseconds

BIGINT

rows

Dataset size, recording the row quantity

BIGINT

columns

Dataset size, recording the column quantity

BIGINT

connectionID

Data Connection ID

Associates with event tracking related to data source connection in the function tracking table (fine_intelli_focus_poin).

VARCHAR

CONNECTION

Data connection name

VARCHAR

uuid

Unique identifier field

VARCHAR

heapBeforeUsed

Heap memory usage before GC

BIGINT

heapAfterUsed

Heap memory usage after GC

BIGINT

heapBeforeCommitted

Applied heap memory before GC

BIGINT

heapAfterCommitted

Applied heap memory after GC

BIGINT

gcStartTime

GC start time

BIGINT

duration

GC duration

BIGINT

gcCause

GC cause

Common causes include:

System.gc()

Allocation Failure

humongous

Metadata GC Threshold

Ergonomics

GCLocker Initiated GC

VARCHAR

gcType

GC type

Divided into GC and Full GC

VARCHAR

metaspaceBeforeUsed

Metaspace memory usage before GC

BIGINT

metaspaceBeforeCommitted

Applied metaspace memory before GC

BIGINT

metaspaceAfterUsed

Metaspace memory usage after GC

BIGINT

metaspaceAfterCommitted

Applied metaspace memory after GC

BIGINT

balancePromoterScore

GC ergonomics aborts

INTEGER

youngBeforeUsed

Young-generation memory usage before GC

BIGINT

youngBeforeCommitted

Applied young-generation memory before GC

BIGINT

youngAfterUsed

Young-generation memory usage after GC

BIGINT

youngAfterCommitted

Applied young-generation memory after GC

BIGINT

loadScore

Overall load score

INTEGER

Node

User-defined node name

Empty in standalone mode

VARCHAR

oldBeforeUsed

Old-generation memory usage before GC

BIGINT

oldBeforeCommitted

Applied old-generation memory before GC

BIGINT

oldAfterUsed

Old-generation memory usage after GC

BIGINT

oldAfterCommitted

Applied old-generation memory after GC

BIGINT

pid

Process PID

VARCHAR

releasePromoterScore

Release score

INTEGER

time

Record time

BIGINT

uuid

Unique identifier field

VARCHAR

time

Record time

BIGINT

id

Configuration Item

VARCHAR

value

Configuration item's value

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Time of import into the database

BIGINT

lockItem

Lock Object

VARCHAR

lockTime

Lock time

VARCHAR

autoUnlockTime

Automatic unlock time

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Time of import into the database

BIGINT

user

Username

VARCHAR

ip

User IP

VARCHAR

level

Severity of unauthorized session

1: Critical (most severe)

2: Suspicious

3: Warning

INTEGER

name

Unauthorized type

· 

Suspicious deserialization anomaly

· 

· 

SQL Execution Exception

· 

· 

Formula execution anomaly

· 

· 

File upload anomaly

· 

· 

Interface authentication exception

· 

· 

Abnormal report access frequency

· 

VARCHAR

MODULE

Affected functional modules

1: Report

2: Platform

3: Reports and platform

INTEGER

Msg

Error message, displays different error messages based on the illegal type

· 

Suspicious deserialization exception: Detected deserialization exception, intercepted deserialization blacklist XXX. Please verify the legality of interface deserialization.

· 

· 

SQL execution exception: Detected SQL execution exception, intercepted SQL keyword XXX. Please verify the legality of the input SQL statement.

· 

· 

Formula execution exception: Detected formula execution exception, intercepted formula XXX. Please verify the legality of the input formula.

· 

· 

File upload exception: Detected file upload exception, intercepted uploaded file XXX. Please verify the legality of the uploaded file.

· 

· 

Interface authentication exception: Detected interface authentication exception, intercepted access to XXX interface. Please verify the legality of interface access.

· 

· 

Report access frequency exception: Detected abnormal report access frequency, prohibited access to XXX report. Please verify the legality of report access.

· 

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

Node

Node name

VARCHAR

item

Configuration Item

VARCHAR

value

Configuration item's value

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

Function

Function

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Record time

BIGINT

Node

Node Name

VARCHAR

process

Log Content

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

id

Primary key

UUID

VARCHAR

creator

Creator

VARCHAR

detailMessage

Details

VARCHAR

filePath

Generate attachment path

Reserved field, unused

VARCHAR

logMessage

Log information

VARCHAR

logTime

Task execution time

Log print time

BIGINT

logType

Log type

0: failure

1: success

2: skip

INTEGER

nextFireTime

Next recording time

Reserved field, unused

BIGINT

runType

Attachment processing type

0: generated by snapshot

1: sent by email

2: uploaded by FTP

3: pushed by message

4: file print

5: sent by SMS

6: mounted by platform

7: customized

8: regularly filled

9: notified by client

10: uploaded by SFTP

INTEGER

taskName

Task Name

VARCHAR

taskID

Task ID

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

DATE

id

Function event tracking ID

Field ID format description:

Example: FR-P1001

FR: prefix, indicating FR event tracking

First character: function (F)/performance (P)

Second character: category, which can be 1 (data source), 2 (frontend), 3 (error reporting), 4 (intelligent O&M), or 5 (designer)

VARCHAR

Text

Main content recorded

VARCHAR

source

Event tracking source

-1: UNDEFINED

1: EMBED (function point of the built-in JAR package)

2: PLUGIN (plugin function point)

4: REPORT (FineReport function point)

8: BI (FineBI function point)

INTEGER

username

Username

which is transcoded (0 for super admin)

VARCHAR

ip

IP address triggering event tracking

VARCHAR

title

Title (what is event tracking)

VARCHAR

body

A JSON data structure

Stores information of different function points based on their IDs

Secondary information, which may be empty

VARCHAR

frFullVersion

FineReport Version

VARCHAR

biFullVersion

FineBI Version

VARCHAR

cloudVersion

Cloud O&M version

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log record time (one record per minute)

BIGINT

Node

Node name

VARCHAR

CPU

CPU utilization

double

memory

Current JVM memory status

BIGINT

sessionnum

Active Session Count

BIGINT

onlinenum

Number of online system users

BIGINT

pid

Process PID

VARCHAR

templateRequest

Number of template requests being calculated

INTEGER

httpRequest

Total number of HTTP requests being processed

INTEGER

sessionRequest

Number of sessionid-carried requests being processed

INTEGER

FineIO

Off-heap memory occupied by FineIO

Unit: KB

BIGINT

NIO

NIO off-heap memory usage size

Unit: KB

BIGINT

bufferMemUse

Total used off-heap memory

directMem「nio」and mappedMem

Unit: KB

BIGINT

physicalMemUse

Physical memory used space

Unit KB

BIGINT

physicalMemFree

Physical memory free space

Unit KB

BIGINT

uuid

Unique identifier field

String

time

Log recording time

long

id

Performance tracking number

String

Text

Resource content

Template name, analysis table name, etc.

String

source

Source of event tracking, Original: class

1: Current system 2: Plugin tracking 4: FineReport 8: FineBI

16. Mobile Terminal

32: JiuShuYun -1: Undefined source

Int

username

Operator

String

ip

Operation IP address

String

title

Resource ID,

which can be the template ID, analysis table ID, or table ID

String

frFullVersion

FR Version

String

biFullVersion

BI Version

String

cloudVersion

Cloud O&M version

String

finish

End time

String

consume

Time consumption, in milliseconds

String

memory

Memory, in byte

String

type

Operation Type

Can indicate which operation was performed

String

comment

Resource remarks

which can be specific information or data to be analyzed directly

String

body

Specific event tracking information

One JSON data structure, storing information by event tracking type

String

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

displayName

Directory name where the error template is mounted on the platform (excluding the full path of parent directories)

If the template is accessed directly via a link, this field is empty

VARCHAR

tname

The actual storage location of the error template, i.e., the full path under reportlet

VARCHAR

username

User who execute templates

notLogged: access without login

fromSchedule: scheduled dispatch

VARCHAR

ip

IP address for template execution

Scheduled task error, IP is empty

VARCHAR

Msg

Error information

including no specific error location and basically matching error codes (such as not displaying specific cells during cell infinite loop)

VARCHAR

trace

Error stack

containing a maximum of 1000 characters (truncated if exceeding this limit)

VARCHAR

code

Error Code

-1 represents no error code

VARCHAR

para

Query parameters when an error occurs

VARCHAR

result

Preview successful or not

0: no

1: yes

BIGINT

platformDisplay

Whether to display in "Management System > Intelligent Operations > Platform Logs"

0: Do not display

1: Display

BIGINT

uuid

Unique identifier field

VARCHAR

time

Record time

BIGINT

taskId

Task ID

VARCHAR

taskResult

Query results: including daily active users, daily active templates, and daily visits

VARCHAR

taskCondition

Query conditions: task type + query time range

VARCHAR

taskType

Task Type

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Log recording time

BIGINT

Node

Nodes in the cluster project

VARCHAR

name

Name of the running task

VARCHAR

MODULE

Business module name

· 

UNIVERSAL: Universal

· 

· 

FR: FineReport

· 

· 

BI: FineBI

· 

· 

FDL: FineDataLink

· 

VARCHAR

action

Execution Type

· 

COLLECT: Event Tracking Collection

· 

· 

EXPORT: event tracking information export

· 

VARCHAR

metricType

Event tracking type

· 

TREASURE: Treasure Event Tracking

· 

· 

SOLID: Solid Event Tracking

· 

· 

SOLID_PERIOD: Solid Period Event Tracking

· 

VARCHAR

starttime

Start time

BIGINT

endTime

End time

BIGINT

consume

Time consumption, in milliseconds

BIGINT

uuid

Unique identifier field

VARCHAR

time

User logout time

BIGINT

ip

Logout IP address

VARCHAR

username

Logout username

VARCHAR

userrole

Logout user role

VARCHAR

uuid

Unique identifier field

VARCHAR

displayName

The name of the directory mounted to the platform (excluding the parent directory or full path)

If the template is accessed directly via a link, this field is empty

VARCHAR

ip

IP address for report execution

VARCHAR

Msg

Error information

VARCHAR

time

Error record time

DATE

tname

Name of the faulty template

recording the full path under reportlet

If no template error occurs, the tname field is recorded as the non-template trigger error.

VARCHAR

trace

Error path

VARCHAR

username

User who execute reports

VARCHAR

userrole

Role assigned to the user who execute reports

VARCHAR

errorCode

Error code

It is recorded as empty if no error code is displayed.

VARCHAR

platformDisplay

Whether to display in "Management System > Intelligent Operations > Platform Logs"

0: Do not display

1: Display

INTEGER

uuid

Unique identifier field

VARCHAR

time

Time of import into the database

BIGINT

pid

Process ID

VARCHAR

starttime

Start time

BIGINT

upTime

End Time

BIGINT

Node

instance

VARCHAR

signalName

Signal name

VARCHAR

uuid

Unique identifier field

VARCHAR

time

Time of import into the database

BIGINT

plugin

Plugin Name

VARCHAR

version

Plugin Version

VARCHAR

API

Usage of interfaces in the plugin

VARCHAR

operation

Plugin running status

VARCHAR

register

Plugin registration status

VARCHAR

ENABLE

Plugin enabled or not

BIT

uuid

Unique identifier field

VARCHAR

time

Time of import into the database

BIGINT

id

Number

VARCHAR

tid

Template ID

VARCHAR

tname

Physical template name

recording the full path under reportlet

VARCHAR

cnums

Number of conditional attributes

BIGINT

formnums

Number of formulas

BIGINT

sheetnums

Number of sheets

BIGINT

dsnums

Number of datasets

BIGINT

compformnums

Number of complex formulas

Includes hierarchical coordinates, SQL, and value formulas

BIGINT

submitnums

Number of built-in submissions

BIGINT

isfrozen

Freezing used or not

BIT

isfoldtree

Collapsible tree used or not

BIT

widgetnums

Number of widgets

BIGINT

tsize

Total template size

BIGINT

imgsize

Size of a image in the template

BIGINT

execute0

Engine status summary 0

BIGINT

execute1

Engine status summary 1

BIGINT

execute2

Engine status summary 2

BIGINT

execute3

Engine status summary 3

BIGINT

execute4

Engine status summary 4

BIGINT

mem0

Memory status summary 0

BIGINT

mem1

Memory status summary 1

BIGINT

mem2

Memory status summary 2

BIGINT

mem3

Memory status summary 3

BIGINT

mem4

Memory status summary 4

BIGINT

sql0

SQL status summary 0

BIGINT

sql1

SQL status summary 1

BIGINT

sql2

SQL status summary 2

BIGINT

sql3

SQL status summary 3

BIGINT

sql4

SQL status summary 4

BIGINT

filternums

Number of filters

BIGINT

injectnums

Number of parameter injections

BIGINT

formula

Usage of formulas in the template

VARCHAR

jsapi

Usage of JavaScript APIs in the template

VARCHAR

recordtime

Template detection time

VARCHAR