Overview
This document briefly introduces the table field descriptions contained in the FineDB database.
Note: 1. This document uses the built-in project database as an example. Note that field data types may differ if you are using an external database.
2. The FineDB configuration database stores project configuration information. Tables are interrelated. Arbitrary modifications may lead to serious consequences, such as project startup failure.
Do not manually add, delete, or modify any data in the FineDB database unless necessary. Such operation may cause irrecoverable errors.
Table List
Category | Subcategory | Table Name | Description |
|---|---|---|---|
Permission control | User-Department position-Role | FINE_USER | User table |
FINE_EXTRA_PROPERTY | User additional information table | ||
FINE_DEPARTMENT | Department table | ||
FINE_POST | Position table | ||
FINE_DEP_ROLE | Department-Position junction table, through which users associate departments with positions | ||
FINE_CUSTOM_ROLE | Custom role table | ||
FINE_USER_ROLE_MIDDLE | User role mapping table, through which users associate with custom roles and department position roles | ||
FINE_SOFT_DATA | Synchronized user soft-delete table, storing data of synchronized users who have been soft-deleted | ||
FINE_TENANT | Tenant table | ||
Permission-Directory | FINE_AUTHORITY | Permission table, which only records the permissions granted to the current directory; permissions for templates and subdirectories under this directory will not be recorded | |
FINE_AUTHORITY_OBJECT | Permission entity table, which records permission objects, directory names, and report names for the current directory (excluding templates and subdirectories within it) | ||
FINE_AUTH_PREFERENCE | Table of user preference settings on the permission panel | ||
FINE_HOMEPAGE_EXPAND | Homepage expansion table This table records expansion attributes of homepage-type permission entities. | ||
FINE_FAVORITE_ENTRY | Favorites table | ||
Platform operations | Login | FINE_LAST_LOGIN | Last login information table |
FINE_LOGIN_LOCK | Login lockout table This table records lockouts due to excessive incorrect password attempts. For details, see Login Lockout. | ||
FINE_BLOCK_IP | IP blocklist table This table records IP addresses blocked due to high-frequency access requests. For details, see Access Control. | ||
Backup and restoration | FINE_BACKUP_NODE | Backup node table | |
FINE_BACKUP_EXCLUDE_ENTITY | Backup exclusion table | ||
Task schedule | FINE_SCHEDULE_TASK | Scheduled task table | |
FINE_SCHEDULE_TASK_PARAM | Parameter value table for scheduled tasks | ||
FINE_SCHEDULE_TASK_EXTEND | Extended attribute table for scheduled tasks | ||
FINE_SCHEDULE_TASK_LOG | Hierarchical monitoring log table for scheduled tasks | ||
FINE_SCHEDULE_RECORD | Execution log table for scheduled tasks | ||
FINE_SCHEDULE_OUTPUT | Export information table for scheduled tasks | ||
FINE_BASE_OUTPUT | Task attachment processing table | ||
FINE_OUTPUT_CLASS | Custom class processing table | ||
FINE_OUTPUT_CLIENT_NOTICE | Client notification table | ||
FINE_OUTPUT_EMAIL | Email delivery table | ||
FINE_OUTPUT_FTP | FTP upload configuration table | ||
FINE_OUTPUT_MOUNT | Mount directory table for scheduled tasks | ||
FINE_OUTPUT_PLATFORM_MSG | Platform system message table for scheduled tasks | ||
FINE_OUTPUT_PRINT | Print configuration table | ||
FINE_OUTPUT_SFTP | SFTP upload configuration table | ||
FINE_OUTPUT_SMS | SMS delivery table | ||
FINE_USAGE_DATA | Reach statistics table for scheduled tasks | ||
Message | FINE_BASE_MESSAGE | Basic message table | |
FINE_PROCESS_MESSAGE | Message push table | ||
FINE_SYSTEM_MESSAGE | Platform system message table | ||
Reporting workflow | FINE_WORKFLOW | Reporting workflow table | |
FINE_WORKFLOW_TASK | Reporting workflow task table | ||
FINE_WORKFLOW_TASK_IMPL | Task details table for reporting workflow | ||
FINE_WORKFLOW_NODE | Reporting workflow node table | ||
FINE_WORKFLOW_STASH_DATA | Temporary data table for reporting workflow | ||
FINE_WORKFLOW_LOG | Operation log table for reporting workflow | ||
System management | Configuration | FINE_CONF_CLASSNAME | Interface configuration type table, which records the specific type of a configuration class field that is an interface |
FINE_CONF_ENTITY | Configuration entity data table | ||
FINE_CONF_XMLENTITY | XML-based configuration table, which stores complex configuration fields by serializing them into the XML format when they cannot be stored in standard database columns | ||
FINE_INTERNATIONAL | Multilingual data table | ||
FINE_LABEL | Label table | ||
FINE_LABEL_INDEX | Label relationship table | ||
FINE_OPS_EXCEED_TEMPLATES | Exceed-Limit template table | ||
FINE_OPS_CRASH_DETAIL | Crash record table | ||
FINE_NET_CHECK_RECORD | Network check record table | ||
Swift module | FINE_SWIFT_COL_IDX_CONF | Field index configuration table | |
FINE_SWIFT_CONFIG_ENTITY | Swift internal configuration table | ||
FINE_SWIFT_METADATA | Metadata storage table | ||
FINE_SWIFT_SEG_LOCATION | Swift Segment distribution table | ||
FINE_SWIFT_SEGMENTS | Swift Segment details table | ||
FINE_SWIFT_SERVICE_INFO | Swift service information table | ||
FINE_SWIFT_TAB_IDX_CONF | Table index configuration table | ||
FINE_SWIFT_TABLE_PATH | Cube intermediate path table | ||
FINE_SWIFT_CLUSTER_SIZE | Deprecated | ||
FINE_SWIFT_DAYS_RECORD | Cache table for daily access statistics | ||
FINE_SWIFT_FILEKEY | Time index table for Swift Segments | ||
FINE_SWIFT_RESTORE_RESULT | Temporary record table for log restoration | ||
Quartz module | QRTZ_BLOB_TRIGGERS | BLOB-based Trigger table | |
QRTZ_CALENDARS | Calendar information storage table | ||
QRTZ_CRON_TRIGGERS | Cron-based Trigger table | ||
QRTZ_FIRED_TRIGGERS | Fired Trigger table | ||
QRTZ_JOB_DETAILS | Job detail table | ||
QRTZ_LOCKS | Scheduler pessimistic lock table | ||
QRTZ_PAUSED_TRIGGER_GRPS | Paused trigger group table | ||
QRTZ_SCHEDULER_STATE | Cluster node instance table | ||
QRTZ_SIMPLE_TRIGGERS | Simple Trigger table | ||
QRTZ_SIMPROP_TRIGGERS | CalendarInterval and DailyTimeInterval Trigger table | ||
QRTZ_TRIGGERS | Trigger basic information table | ||
Other modules | Mobile terminal | FINE_MOBILE_DEVICE | Mobile device table |
FINE_MOBILE_PUSH_MESSAGE | Mobile message push table | ||
FINE_WEIXIN_USER_RELATION | Manual mapping table of WeChat & platform users | ||
FINE_WEIXIN_OUTPUT | Table of WeChat-pushed scheduled tasks | ||
FINE_WEIXIN_AGENT | Application information table in WeChat management | ||
FINE_WEIXIN_GROUP | WeChat group information table in WeChat management | ||
FINE_FEISHU_USER_RELATION | Manual mapping table of Lark & platform users | ||
FINE_FEISHU_OUTPUT | Table of Lark-pushed scheduled tasks | ||
FINE_FEISHU_AGENT | Application information table in Lark management | ||
FINE_FEISHU_GROUP | Lark group information table in Lark management | ||
Report | FINE_PARAM_TEMPLATE | Template parameter combination table | |
FINE_PRINT_OFFSET | Print offset table | ||
FINE_PRINT_OFFSET_IP_RELATE | IP association table for print offset | ||
FINE_REMOTE_DESIGN_AUTH | Remote design user table | ||
FINE_WRITE_STASH | Data entry stash table | ||
FINE_PROCESS_EXPAND | This table is an expansion attribute table for permission entities of the data reporting workflow. It contains the attributes of reporting workflows configured in the decision-making platform directory, including name, path, description, type, display terminal, parameter settings, etc. | ||
FINE_REPORT_EXPAND | This table is an expansion attribute table for report permission entities. It contains the report attributes configured in the decision-making platform directory, including name, path, description, type, display terminal, parameter settings, etc. | ||
FINE_EXCEL_SUBMIT_TASK | Expansion table for permission entities of Excel batch import | ||
FINE_VCS | Template version management table | ||
FINE_COMPONENT_HEALTH | Component health record table | ||
Open platform | FR_OPEN_API | API information table | |
FR_OPEN_APP | Client information table | ||
FR_OPEN_AUTH | Permission information table | ||
FR_OPEN_GROUP | API group name table | ||
FR_OPEN_PRIVILEGE | Open platform permission table | ||
FR_OPEN_RELATION | Group and API association table | ||
FR_OPEN_API_PERFORMANCE | API query rate table | ||
Multi-product connection tool | FINE_COORDINATOR_ENTRY | Secondary server template table | |
FINE_COORDINATOR_SERVER | Secondary server information table |
Table Relationships
Permissions
Reporting
Task Schedule
Messages
Printing
Note: Given the table structures and lack of direct relationships, any direct database operations require manual deletion of data in junction tables.
For example: Deleting a department = Deleting related data in FINE_DEPARTMENT, FINE_DEP_ROLE, and FINE_USER_ROLE_MIDDLE tables; Deleting a user = Deleting related data in FINE_USER, FINE_USER_ROLE_MIDDLE, and FINE_EXTRA_PROPERTY tables.
User-Department Position-Role
FINE_USER User Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_EXTRA_PROPERTY > RELATEDID FINE_USER_ROLE_MIDDLE > USERID FINE_BASE_MESSAGE > USERID FINE_AUTH_PREFERENCE > USERID FINE_FAVORITE_ENTRY > USERID FINE_LAST_LOGIN > USERID FINE_LOGIN_LOCK > USERID FINE_WORKFLOW_TASK > CREATORID FINE_AUTHORITY > ROLEID | VARCHAR | 255 |
BIRTHDAY | Birthday | TIMESTAMP | 26 |
CREATIONTYPE | Creation type 1: Manual creation 2: Creation by synchronization | INTEGER | 32 |
DESCRIPTION | Description | VARCHAR | 1000 |
Mailbox | VARCHAR | 255 | |
ENABLE | Enabled or not true: Enabled false: Disabled | BOOLEAN | 0 |
LANGUAGE | Language | VARCHAR | 255 |
LASTOPERATIONTYPE | Type of the last modification 1: Manual modification 2: Synchronized modification | INTEGER | 32 |
MALE | Gender true: Male false: Female | BOOLEAN | 0 |
MOBILE | Mobile number | VARCHAR | 255 |
PASSWORD | Password This field stores the encrypted passwords for platform users and does not affect their logins to the decision-making platform. The built-in encryption method is SHA256. Ciphertext after custom encryption | VARCHAR | 255 |
REALNAME | Name | VARCHAR | 255 |
USERNAME | Username Associated table and field FINE_BASE_MESSAGE > USERNAME FINE_WORKFLOW_TASK > CREATORNAME FINE_SCHEDULE_RECORD > CREATOR FINE_SCHEDULE_TASK > CREATOR | VARCHAR | 255 |
WORKPHONE | Mobile number | VARCHAR | 255 |
REALALIAS | REALNAME sorting index For example, if REALNAME is Anna, REALALIAS is anna. FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
USERALIAS | USERNAME sorting index For example, if USERNAME is Alice, USERALIAS is alice. FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
TENANTID | Tenant ID Reserved field; currently unused. | VARCHAR | 255 |
SALT | Salt parameter The salt value is updated along with the user password to enhance security. FineReport: New field added in version 10.0.18 or later FineBI: New field added in version 5.1.15 or later | VARCHAR | 255 |
FINE_EXTRA_PROPERTY User Additional Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
NAME | Attribute name, which distinguishes platform user types user_product_type.platform.bi_datamining: Super admin user_product_type.platform: PC user user_product_type.platform.bi_view: BI user - viewer user_product_type.platform.bi_design: BI user - designer user_product_type.mobile: mobile user user_product_type.platform.fdl: FDL data development user | VARCHAR | 255 |
RELATEDID | User ID Associated table and field FINE_USER > ID | VARCHAR | 255 |
TYPE | Type of the associated data item | INTEGER | 32 |
VALUE | Property value | VARCHAR | 65536 |
FINE_DEPARTMENT Department Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_DEP_ROLE > DEPARTMENTID | VARCHAR | 255 |
CREATIONTYPE | Creation type 1: Manual creation 2: Creation by synchronization | INTEGER | 32 |
DESCRIPTION | Description | VARCHAR | 1000 |
ENABLE | Enabled or not true: Enabled false: Disabled | BOOLEAN | / |
LASTOPERATIONTYPE | Type of the last modification 1: Manual modification 2: Synchronized modification | INTEGER | 32 |
NAME | Department name | VARCHAR | 255 |
PARENTID | Parent department ID | VARCHAR | 255 |
FULLPATH | Department full path Grandparent department ID Parent department ID ...
FineReport: New field in JAR versions released on or after 2019-05-20 FineBI: New field in JAR versions released on or after 2019-06-13 | VARCHAR | 65536 |
ALIAS | NAME sorting index For example, if the department is Chief dispatcher, ALIAS is chief dispatcher.
FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
TENANTID | Tenant ID Reserved field; currently unused. | VARCHAR | 255 |
FINE_POST Position Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key
Associated table and field FINE_DEP_ROLE > POSTID | VARCHAR | 255 |
CREATIONTYPE | Creation type 1: Manual creation 2: Creation by synchronization | INTEGER | 32 |
DESCRIPTION | Description | VARCHAR | 1000 |
ENABLE | Enabled or not 1: Enabled 0: Disabled | BOOLEAN | 0 |
LASTOPERATIONTYPE | Type of the last modification 1: Manual modification 2: Synchronized modification | INTEGER | 32 |
NAME | Position name | VARCHAR | 255 |
ALIAS | NAME sorting index For example, if the position is Development engineer, ALIAS is development engineer.
FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
TENANTID | Tenant ID
Reserved field; currently unused. | VARCHAR | 255 |
FINE_DEP_ROLE Department-Position Junction Table
Field Name | Description | Data Type | Length | Note |
|---|---|---|---|---|
ID | Primary key | VARCHAR | 255 | Associated table and field FINE_USER_ROLE_MIDDLE > ROLEID |
CREATIONTYPE | Creation type 1: Manual creation 2: Creation by synchronization | INTEGER | 32 | / |
DEPARTMENTID | Associated department ID and position ID
DEPARTMENTID and POSTID are both null: Root department DEPARTMENTID is null, and POSTID is not null: A position under the root department (this case does not exist by default) DEPARTMENTID is not null, and POSTID is null: A department without positions DEPARTMENTID and POSTID are not null: A normal department position | VARCHAR | 255 | Associated table and field FINE_DEPARTMENT > ID |
POSTID | VARCHAR | 255 | Associated table and field FINE_POST > ID | |
LASTOPERATIONTYPE | Type of the last modification 1: Manual modification 2: Synchronized modification | INTEGER | 32 | / |
FULLPATH | Full path of intermediate data | VARCHAR | 65536 | / |
TENANTID | Tenant ID | VARCHAR | 255 | Reserved field; currently unused. |
FINE_CUSTOM_ROLE Custom Role Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key
Associated table and field FINE_USER_ROLE_MIDDLE > ROLEID | VARCHAR | 255 |
CREATIONTYPE | Creation type 1: Manual creation by the admin 2: Creation by synchronizing datasets | INTEGER | 32 |
DESCRIPTION | Description | VARCHAR | 255 |
ENABLE | Enabled or not true: Enabled false: Disabled | BOOLEAN | / |
LASTOPERATIONTYPE | Type of the last modification 1: Manual modification 2: Synchronized modification | INTEGER | 32 |
NAME | Role name | VARCHAR | 255 |
ALIAS | NAME sorting field index For example, if the role is Project O&M, ALIAS is project o&m.
FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
TENANTID | Tenant ID Reserved field; currently unused. | VARCHAR | 255 |
FINE_USER_ROLE_MIDDLE User Role Mapping Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ROLEID | Associated generalized role ID DEPROLEID or CUSTOMROLEID
Associated table and field FINE_DEP_ROLE > ID FINE_CUSTOM_ROLE > ID FINE_AUTHORITY > ROLEID Note: Different departments and roles of a user will be stored as multiple records. | VARCHAR | 255 |
ROLETYPE | Associated generalized role type 1: Department position 2: Custom role | INTEGER | 32 |
USERID | Associated user ID Associated table and field FINE_USER > ID | VARCHAR | 255 |
TENANTID | Tenant ID Reserved field; currently unused. | VARCHAR | 255 |
FINE_SOFT_DATA Synchronized User Soft-Delete Table
When data is removed from the synchronization source, it is physically deleted from the FineDB database and moved to the soft-delete table (FINE_SOFT_DATA) for archival.
Data restored from the synchronization source is recovered from the soft-delete table. Since the unique IDs remain unchanged, all original permissions are preserved.
Field Name | Description | Data Type | Length | Note |
|---|---|---|---|---|
ID | Primary key | VARCHAR | 255 | / |
DELETEDID | ID to be deleted | VARCHAR | 255 | (1) The combination of fields DELETEDID + TYPE forms a unique key. That is, the values of DELETEDID and TYPE cannot be identical across any two records. (2) The combination of fields DELETEDNAME + TYPE forms a unique key. That is, the values of DELETEDNAME and TYPE cannot be identical across any two records. |
DELETEDNAME | Name to be deleted User: Username Department: Calculated full department name Position: Position name Role: Role name Department position: Department ID + Position ID | VARCHAR | 255 | |
TYPE | Deleted data types 1: Department 2: Role 3: User 4: Position 5: Department-Position junction table 6: Data on the relationship between synchronized users and manually customized roles 7: Data on the relationship between synchronized users and department positions | INTEGER | 32 |
FINE_TENANT Tenant Table
Currently unused
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | User ID | VARCHAR | 255 |
NAME | Username | VARCHAR | 255 |
Permission-Directory
FINE_AUTHORITY Permission Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
AUTHORITY | Permission value 1: Deny 2: Allow | INTEGER | 32 |
AUTHORITYENTITYID | Associated permission entity ID Associated table and field FINE_AUTHORITY_OBJECT > ID | VARCHAR | 255 |
AUTHORITYENTITYTYPE | Associated authority entity type Platform type 0: Directory permission and management system permissionEntities are stored in the FINE_AUTHORITY_OBJECT table. 1: Personnel management - department permission, personnel management - role permission 2: Data connection permission 7: Scheduled task permission 8: Server dataset Report type 101: FineReport template permission (template authentication) FineBI type 201: FineBI business package permission 202: Row filter permission of FineBI business packages (not perceptible to external users) 203: FineBI dashboard permission (mainly for sharing dashboards) 204: FineBI template permission (template authentication) 205: FineBI dashboard sharing control (role to role) 206: FineBI self-service dataset sharing 207: FineBI self-service dataset sharing (role to role) FDL: 320: Module directory 321: Scheduled 322: Pipeline 323: Service | INTEGER | 32 |
AUTHORITYTYPE | Permission type Platform type 1: Viewing permission 2: Authorization permission 3: Editing permission 4: Data connection management permission 7: Scheduled task management permissions 9: Management permission on personnel management 10: Server dataset management permission Report type 101: FineReport template authentication permission 102: FineReport template viewing permission 103: Template data entry permission of FineReport 104: Batch import task permission 105: FineReport reporting workflow permission FineBI type 201: Business package usage permission 202: Business package management permission 203: FineBI report export permission 204: FineBI dashboard sharing permission 205: FineBI template authentication permission 206: FineBI template viewing permission 207: FineBI template export permission 208: Role control permission for FineBI dashboard sharing 209: Sharing function permission for FineBI dashboards 210: Public link function permission for FineBI dashboards FDL module: (All permissions are management permissions. For authorization permissions, see the corresponding "Platform Type" field.) 320: Data directory permission 321: Scheduled task permission 322: Pipeline task permission 323: Data service API permission 324: Data service application permission | INTEGER | 32 |
ROLEID | Associated generalized role ID Associated table and field FINE_DEP_ROLE > ID FINE_CUSTOM_ROLE > ID FINE_USER_ROLE_MIDDLE > ROLEID FINE_USER > ID | VARCHAR | 255 |
ROLETYPE | Associated generalized role type 1: Department, or position under a department 2: Custom role 3: User 4: Position | INTEGER | 32 |
TENANTID | Tenant ID Reserved field; currently unused. | VARCHAR | 255 |
FINE_AUTHORITY_OBJECT Permission Entity Table
This table contains directory information and management system information.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_AUTHORITY > AUTHORITYENTITYID | VARCHAR | 255 |
EXPANDID | Record ID of the associated expansion attribute | VARCHAR | 255 |
EXPANDTYPE | Associated expansion attribute type Platform type 1: Platform management system node 2: Homepage 3: Directory 5: Link 6: File Report type 101: Reporting workflow 102: FineReport report FineBI type 201: FineBI report | INTEGER | 32 |
PARENTID | Associated parent node ID | VARCHAR | 255 |
COVERID | Cover ID Directory Cover in System Management > Appearance Configuration > Directory Style | VARCHAR | 255 |
DESCRIPTION | Description | VARCHAR | 65536 |
DEVICETYPE | Displayed type 0: PC, tablet, and mobile not selected 1: PC 2: Tablet 3: PC and tablet 4: Mobile 5: PC and mobile selected 6: Tablet and mobile selected 7: PC, tablet, and mobile selected | INTEGER | 32 |
DISPLAYNAME | Displayed report name and directory name | VARCHAR | 255 |
ICON | Icon ID Directory Icon in System Management > Appearance Configuration > Directory Style | VARCHAR | 255 |
PATH | Path, whose meaning varies depending on the entry type | VARCHAR | 255 |
SORTINDEX | Sorting index | BIGINT | 64 |
MOBILEICON | Mobile icon ID | VARCHAR | 255 |
FULLPATH | Entity full path FineReport: New field in JAR versions released on or after 2019-05-20 FineBI: New field in JAR versions released on or after 2019-06-13 | VARCHAR | 65536 |
TENANTID | Tenant ID Reserved field; currently unused. | VARCHAR | 255 |
FINE_AUTH_PREFERENCE Table of User Preference Settings on the Permission Panel
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
AUTHTYPE | Permission panel type | INTEGER | 32 |
AUTHVISIBLECFG | Permission visibility configuration | BIGINT | 64 |
USERID | User ID
Associated table and field FINE_USER > ID | VARCHAR | 255 |
FINE_HOMEPAGE_EXPAND Homepage Expansion Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ANDROIDPADHOMEPAGE | Homepage link for Android tablets | VARCHAR | 1000 |
ANDROIDPHONEHOMEPAGE | Homepage link for Android phones | VARCHAR | 1000 |
IPADHOMEPAGE | Homepage link for iPad | VARCHAR | 1000 |
IPHONEHOMEPAGE | Homepage link for iPhone | VARCHAR | 1000 |
PCHOMEPAGE | Homepage link for PC | VARCHAR | 1000 |
TYPE | Homepage type 0: FineReport template 1: Platform directory 2: Hyperlink 3: FineBI template | INTEGER | 32 |
FINE_FAVORITE_ENTRY Favorites Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ENTRYID | Favorite report ID | VARCHAR | 255 |
TIME | Favorite time | TIMESTAMP | 26 |
USERID | User ID
Associated table and field FINE_USER > ID | VARCHAR | 255 |
Login
FINE_LAST_LOGIN Last Login Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CITY | City of login | VARCHAR | 255 |
IP | Login IP address | VARCHAR | 255 |
TIME | Login time | TIMESTAMP | 26 |
USERID | Login user ID
Associated table and field FINE_USER > ID | VARCHAR | 255 |
FINE_LOGIN_LOCK Login Lockout Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ERRORTIME | Number of password errors | INTEGER | 32 |
LOCKOBJECT | Locked IP address or username | VARCHAR | 255 |
LOCKOBJECTVALUE | Value of the IP address or username | VARCHAR | 255 |
LOCKTIME | Lockout time | TIMESTAMP | 26 |
LOCKED | Usually null | BOOLEAN | / |
UNLOCKTIME | Unlock time | TIMESTAMP | 26 |
USERID | User ID
Associated table and field FINE_USER > ID | VARCHAR | 255 |
FINE_BLOCK_IP IP Blocklist Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CREATETIME | Block time | TIMESTAMP | 26 |
IP | Blocked IP address | VARCHAR | 255 |
REJECTEDVISITS | Rejection count | INTEGER | 32 |
Backup and Restoration
FINE_BACKUP_NODE Backup Node Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
BACKUPMODULE | Backup module jar: JAR package jar-cluster: JAR package within a cluster (special case) In a cluster environment, JAR package backup is automatically handled via proxy implementation; therefore, it is categorized as a separate module. plugins: Plugin dashboards: FineBI templates reportlets: Report templates config: Platform configurations dpworks: Scheduled tasks | VARCHAR | 255 |
BACKUPNAME | Backup name | VARCHAR | 255 |
BACKUPTIME | Backup time | TIMESTAMP | 26 |
SAVEPATH | Backup path | VARCHAR | 1000 |
BACKUPSIZE | Backup file size | DOUBLE | 64 |
TYPE | Type auto: Automatic backup manual: Manual backup FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
BACKUPENDTIME | Backup end time FineReport: New field added in version 10.0.11 or later FineBI: New field added in version 5.1.8 or later | TIMESTAMP | 26 |
STATUS | Backup status FineReport: New field in 10.0.11 or later FineBI: New field added in version 5.1.8 or later | INTEGER | 32 |
DETAIL | Details (Error log) FineReport: New field added in version 10.0.11 or later FineBI: New field added in version 5.1.8 or later | VARCHAR | 65536 |
FINE_BACKUP_EXCLUDE_ENTITY Backup Exclusion Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Some functional configuration items are not involved in backup and restoration. The configuration items that are skipped during backup execution are recorded in this table. The meaning of ID and VALUE varies based on the functions. | VARCHAR | 255 |
VALUE | VARCHAR | 255 |
Task Schedule
FINE_SCHEDULE_TASK Scheduled Task Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_SCHEDULE_TASK_PARAM > TASKID FINE_SCHEDULE_RECORD > TASKID | VARCHAR | 255 |
BACKUPFILEPATH | Backup file path Reserved field; unused | VARCHAR | 1000 |
CREATOR | Task creator Associated table and field FINE_USER > USERNAME FINE_SCHEDULE_RECORD > CREATOR | VARCHAR | 255 |
EDITABLE | Whether the task is editable true: Editable false: Not editable Reserved field; unused | BOOLEAN | 0 |
FILECLEARCOUNT | Attachment cleanup count -1: No cleanup 0: Immediate cleanup upon task completion 1: Retain one time Other positive integers: Custom retention of x times | INTEGER | 32 |
NEXTFIRETIME | Next execution time yyyy-MM-dd HH:mm:ss | TIMESTAMP | 26 |
OUTPUTSTR | Combined string of task attachment processing types, used for filtering during conditional queries File processing methods, separated by commas: 1: Email notification | VARCHAR | 1000 |
PREFIRETIME | Last execution time yyyy-MM-dd HH:mm:ss | TIMESTAMP | 26 |
REPEATTIME | Time interval for restarting after task execution fails | INTEGER | 32 |
REPEATTIMES | Number of retries after task execution fails | INTEGER | 32 |
SENDBACKUPFILE | Whether to send backup files true: Send false: Not send Reserved field; unused | BOOLEAN | 0 |
SHOWTYPE | Display type 0: Pagination preview 1: Data entry preview 2: Data analysis preview 3: Preview on PC 4: New data entry | INTEGER | 32 |
TASKCONDITION | Task status This field is in the JSON format, and includes type and description. type: 0: Unconditional execution 1: Formula evaluation 2: Custom class evaluation description: Specific content (specific formula or class name) | VARCHAR | 255 |
TASKDESCRIPTION | Task description Reserved field; unused | VARCHAR | 1000 |
TASKNAME | Task name | VARCHAR | 255 |
TASKPARAMETER | Task parameter This field is in the JSON format, and includes inputStyle (parameter input method), name (parameter name), type (parameter type), and value (parameter value). inputStyle (input method), optional 0: Default 1: Dataset type (parameter type) String: String Integer: Integer Double: Double Date: Date Boolean: Boolean TableColumn: Dataset column value (parameter value) If the parameter input method is default, value is a string. If the parameter input method is the dataset, this field includes value (dataset name) and colname (dataset field value). | VARCHAR | 65536 |
TASKSTATE | Task status 0: Start 1: Pause 2: Completed This field may not directly correspond to the status displayed on the frontend, as calculation is required prior to frontend rendering. | INTEGER | 32 |
TASKTYPE | Task type 0: No schedule object 1: Report template 2: FineBI template 3: Multi-select report template | INTEGER | 32 |
TEMPLATEPATH | Template path | VARCHAR | 1000 |
TRIGGERGROUP | Trigger group This field is in the JSON format and contains multiple Triggers, including Trigger type, time, etc. triggerType: 1: Single execution 2: Simple repeat execution 3: Detailed frequency settings 4: Expression settings startTime: yyyy-MM-dd HH:mm:ss startType: 1: Execute immediately 2: Select start time endType: 1: End immediately after execution 2: No end date 3: Select end time 4: Additional execution count recurrenceInterval (interval for simple repeat execution), optional recurrenceIntervalUnit (unit of the interval for simple repeat execution), optional 1: Minute 2: Hour 3: Day 4: Week repeatCount (additional execution count), optional: Integer hours (detailed execution frequency — hour count), optional: Integer minutes (detailed execution frequency — minute count), optional: Integer dayType (detailed execution frequency — day type), optional: 1: Daily 2: Weekly 3: Monthly monthDays (specific days in a month when dayType is set to monthly), optional: Integer array weekDays (specific days in a week when dayType is set to weekly), optional: Integer array months (specific months for detailed execution frequency), optional Integer array | VARCHAR | 65536 |
USERGROUP | User group JSON format: customRole (role list): Array of role IDs customRoleStr (role list string): For frontend display departmentAndPost (department list): Array of department IDs departmentStr (department list string): For frontend display platformUser (user list), optional: Array, formatted as "Name (Username)" platformUserStr (user list string), optional: For frontend display userType (user type): 1 - Platform user; 2 - Custom user columnIndex: Dataset column index of custom users (optional) columnIndexStr: Dataset column name of custom users (optional) tableDataName: Dataset name of custom users (optional) | VARCHAR | 65536 |
SCHEDULEOUTPUT | Task push Associated table and field FINE_SCHEDULE_OUTPUT > ID | VARCHAR | 255 |
CONDITIONPARAMETER | Custom class parameters for execution conditions JSON format: name (parameter name) value (parameter value) FineReport: New field in JAR versions released on or after 2020-06-08 FineBI: New field in JAR versions released on or after 2020-08-04 | VARCHAR | 1000 |
FINE_SCHEDULE_TASK_PARAM Parameter Value Table for Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
PARAM | Parameter list JSON format: Parameter name: Parameter value | VARCHAR | 65536 |
TASKNAME | Task name | VARCHAR | 255 |
TASKID | Task ID Associated table and field FINE_SCHEDULE_TASK > ID | VARCHAR | 255 |
FINE_SCHEDULE_TASK_EXTEND Extended Attribute Table of Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Record ID | VARCHAR | 255 |
TASKID | Scheduled task ID | VARCHAR | 255 |
TASKPARAMETERMAP | Parameters for scheduled task templates | VARCHAR | 65536 |
TEMPLATEPATHS | Templates for scheduled tasks | VARCHAR | 4000 |
FINE_SCHEDULE_TASK_LOG Hierarchical Monitoring Log Table for Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Record ID | VARCHAR | 255 |
LOGTIME | Log time | BIGINT | 64 |
LOGTYPE | Log type 0: Failure 1: Success 2: Skip | INTEGER | 32 |
TASKID | Scheduled task ID | VARCHAR | 255 |
TASKLOG | Scheduled task log | VARCHAR | 16777216 |
TASKNAME | Scheduled task name | VARCHAR | 255 |
FINE_SCHEDULE_RECORD Execution Log Table for Scheduled Tasks
Note: For projects with JAR packages released before 2019-05-20, the FINE_SCHEDULE_RECORD table is used to store scheduled task execution logs.
For projects with JAR packages released on or after 2019-05-20, the FINE_SCHEDULE_RECORD table in the LogDB database is used to store scheduled task execution logs. For details, see Log Database LogDB.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CREATOR | Creator | VARCHAR | 255 |
DETAILMESSAGE | Details | VARCHAR | 65536 |
FILEPATH | Generated attachment path Reserved field; unused | VARCHAR | 1000 |
LOGMESSAGE | Log information | VARCHAR | 255 |
LOGTIME | Task execution time Log print time | TIMESTAMP | 26 |
LOGTYPE | Log type 0: Failure 1: Success 2: Skip | INTEGER | 32 |
NEXTFIRETIME | Next recording time Reserved field; unused | TIMESTAMP | 26 |
RUNTYPE | Attachment processing type 0: Generated by snapshot 1: Sent by email 2: Upload via FTP 3: Pushed by platform message 4: File print 5: Sent by SMS 6: Mounted on the platform 7: Custom class processing 8: Regular data entry 9: Client notification 10: Upload via SFTP -1: Sent by attachment (default) | INTEGER | 32 |
TASKNAME | Task name | VARCHAR | 255 |
TASKID | Task ID Associated table and field FINE_SCHEDULE_TASK > ID | VARCHAR | 255 |
FINE_SCHEDULE_OUTPUT Export Information Table for Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_SCHEDULE_TASK > SCHEDULEOUTPUT FINE_BASE_OUTPUT > OUTPUTID | VARCHAR | 255 |
BASENAME | Generated attachment name | VARCHAR | 65536 |
CREATEATTACHBYUSERNAME | Whether to generate different attachments for different users 1: Yes 0: No | BOOLEAN | 0 |
FORMATS | Type of the exported attachment JSON format: formatNum File processing method: 0: Output CPR files 1: Output Excel files of the new version 2: Output PDF files 4: Output Word files 8: Output Excel files of the old version 16: Output PNG files 32: Output FRR files | VARCHAR | 255 |
BASEMAMEMAP | Attachment name for a single template in scheduled tasks | VARCHAR | 65536 |
FORMATSMAP | Export format for attachments of a single template in scheduled tasks | VARCHAR | 65536 |
FINE_BASE_OUTPUT Task Attachment Processing Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ACTIONNAME | Attachment processing class type | VARCHAR | 255 |
EXECUTEBYUSER | Whether to execute separately for different users 1: Yes 0: No | BOOLEAN | / |
RESULTURL | Result URL | VARCHAR | 1000 |
RUNTYPE | Attachment processing type 0: Generated by snapshot 1: Sent by email 2: Upload via FTP 3: Pushed by platform message 4: File print 5: Sent by SMS 6: Mounted on the platform 7: Custom class processing 8: Regular data entry 9: Client notification 10: Upload via SFTP -1: Sent by attachment (default) | INTEGER | 32 |
OUTPUTID | Export ID Associated table and field FINE_SCHEDULE_OUTPUT > ID | VARCHAR | 255 |
FINE_OUTPUT_CLASS Custom Class Processing Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
CLASSNAME | Custom class name | VARCHAR | 255 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
FINE_OUTPUT_CLIENT_NOTICE Client Notification Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ADDRESSEE | Receiver | VARCHAR | 65536 |
CONTENT | Content | VARCHAR | 65536 |
CUSTOMIZELINK | Custom link | VARCHAR | 65536 |
LINKOPENTYPE | Link type 1: Scheduled task result link 2: Custom link | INTEGER | 32 |
MEDIAID | Image ID for rich text messages | VARCHAR | 255 |
SUBJECT | Subject | VARCHAR | 65536 |
TERMINAL | Push terminal Currently fixed at 1, representing app notification | INTEGER | 32 |
TYPE | Message type 1: Link message 2: Graphic message 3: File message | INTEGER | 32 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
FINE_OUTPUT_EMAIL Email Delivery Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ADDLINK | Result link | BOOLEAN | 0 |
BCCADDRESS | BCC address | VARCHAR | 65536 |
BODYCONTENT | Content | VARCHAR | 65536 |
CCADDRESS | CC address | VARCHAR | 65536 |
PREVIEWATTACH | Body preview | Boolean | 0 |
SUBJECT | Subject | VARCHAR | 65536 |
USEATTACH | Used attachments | BOOLEAN | 0 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
CUSTOMADDRESS | Custom email recipient | VARCHAR | 1000 |
CUSTOMBCCADDRESS | Custom BCC address | VARCHAR | 1000 |
CUSTOMCCADDRESS | Custom CC address | VARCHAR | 1000 |
PREVIEWWIDGET | Whether Preview Component in Body is selected FineReport: New field added in version 10.0.13 or later FineBI: New field added in version 5.1.10 or later | BOOLEAN | 0 |
ADDLINKLIST | Result link for a single template in scheduled tasks | VARCHAR | 65536 |
EMAILACCOUNTCONFIGID | Sender ID | VARCHAR | 255 |
REVIEWATTACHLIST | Preview content of a single template in scheduled tasks | VARCHAR | 65536 |
USEATTACHLIST | Generated attachments of a single template in scheduled tasks | VARCHAR | 65536 |
FINE_OUTPUT_FTP FTP Upload Configuration Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
PASSWORD | Password | VARCHAR | 255 |
PORT | Port number | VARCHAR | 255 |
SAVEPATH | Upload path | VARCHAR | 255 |
SERVERADDRESS | Server address | VARCHAR | 255 |
USERNAME | Username | VARCHAR | 255 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
FTPMODE | FTP mode passive: Passive mode active: Active mode | VARCHAR | 255 |
FINE_OUTPUT_MOUNT Mount Directory Table for Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
DESCRIPTION | Description | VARCHAR | 65536 |
FOLDERENTRYID | Mount directory ID | VARCHAR | 255 |
FOLDERENTRYNAME | Mount directory name | VARCHAR | 255 |
FOLDERENTRYSTR | Mount directory | VARCHAR | 255 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
FINE_OUTPUT_PLATFORM_MSG Platform System Message Table for Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
CONTENT | Content | VARCHAR | 65536 |
LINKOPENTYPE | Link type 1: Scheduled task result link 2: Custom link | INTEGER | 32 |
SUBJECT | Subject | VARCHAR | 65536 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
FINE_OUTPUT_PRINT Print Configuration Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
PRINTERNAME | Printer Name | VARCHAR | 255 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
FINE_OUTPUT_SFTP SFTP Upload Configuration Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
PASSWORD | Password | VARCHAR | 255 |
PORT | Port number | VARCHAR | 255 |
PRIVATEKEY | Private Key | VARCHAR | 255 |
SAVEPATH | Upload path | VARCHAR | 255 |
SERVERADDRESS | Server address | VARCHAR | 255 |
USERNAME | Username | VARCHAR | 255 |
FINE_OUTPUT_SMS SMS Delivery Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
TEMPLATEID | Template ID | INTEGER | 32 |
ID | Primary key Associated table and field FINE_BASE_OUTPUT > ID | VARCHAR | 255 |
SMSPARAM | SMS parameters, in JSON format, including: id: Parameter IDname: Parameter name value: Parameter value type: Parameter type Values of type: String Integer Double Date Boolean Formula FineReport: New field in JAR versions released on or after 2019-12-05 FineBI: New field in JAR versions released on or after 2020-01-15 | VARCHAR | 255 |
FINE_USAGE_DATA Reach Statistics Table for Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Record ID | VARCHAR | 255 |
DATA | Record data | VARCHAR | 1000 |
DATATYPE | Record data type | INTEGER | 32 |
SUBTYPE | Record data subtype | INTEGER | 32 |
TAG | Record data name | VARCHAR | 255 |
Messages
FINE_BASE_MESSAGE Basic Message Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CREATETIME | Message creation time | TIMESTAMP | 26 |
DATETIME | Message time | TIMESTAMP | 26 |
MESSAGE | Message content | VARCHAR | 65536 |
READ | Read or not 1: Yes 0: No | BOOLEAN | / |
TOASTED | Whether a toast notification has been displayed 1: Yes 0: No | BOOLEAN | / |
TYPE | Message type 0: System message 1: Report message 2: Template message 3: Mobile message -1: Unknown message | INTEGER | 32 |
URL | URL | VARCHAR | 1000 |
URLTYPE | URL type 0: Null 1: Internal link type, for example, /report/entry/{id} 2: External link type, for example, www.fanruan.com 3: Platform module route, through which a specific tab page in system management can be accessed 4: URL to open multiple templates within the platform | INTEGER | 32 |
USERID | User ID Associated table and field FINE_USER > ID | VARCHAR | 255 |
USERNAME | Username Associated table and field FINE_USER > USERNAME | VARCHAR | 255 |
FINE_PROCESS_MESSAGE Message Push Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ALLTASKID | All task IDs | VARCHAR | 255 |
DEADLINE | End time | TIMESTAMP | 26 |
PROCESSED | Completed or not 1: Completed 0: Not completed | BOOLEAN | 0 |
TASKID | Report task ID | VARCHAR | 255 |
ID | Primary key Associated table and field FINE_BASE_MESSAGE > ID | VARCHAR | 255 |
FINE_SYSTEM_MESSAGE Platform System Message Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
TERMINAL | Push terminal Currently fixed at 1, representing PC message notification | BIGINT | 64 |
TITLE | Subject | VARCHAR | 255 |
ID | Primary key Associated table and field FINE_BASE_MESSAGE > ID | VARCHAR | 255 |
Reporting
Note: Reporting-related tables are added to JAR packages released after 2018-12-27.
FINE_WORKFLOW Reporting Workflow Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CREATETIME | Creation time | TIMESTAMP | 26 |
CREATORID | Creator ID Associated table and field FINE_WORKFLOW_TASK > CREATORID FINE_WORKFLOW_STASH_DATA > USERID FINE_WORKFLOW_LOG > OPERATORNAME | VARCHAR | 255 |
DESCRIPTION | Description | VARCHAR | 65536 |
NAME | Process name | VARCHAR | 255 |
NODESID | Node ID Associated table and field FINE_WORKFLOW_NODE > ID | VARCHAR | 65536 |
FINE_WORKFLOW_TASK Reporting Workflow Task Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_WORKFLOW_TASK_IMPL > TASKID | VARCHAR | 255 |
CREATETIME | Creation time | TIMESTAMP | 26 |
CREATORID | Creator ID Associated table and field FINE_USER > ID FINE_WORKFLOW > CREATORID | VARCHAR | 255 |
CREATORNAME | Creator name Associated table and field FINE_USER > USERNAME | VARCHAR | 255 |
DEADLINEDATE | End time | INTEGER | 32 |
DEADLINETYPE | Deadline type | VARCHAR | 255 |
ISSUECONTROL | Scheduled delivery control | VARCHAR | 65536 |
ISSUEOVER | Whether the delivery is completed 1: Yes 0: No | BOOLEAN | 0 |
LEAPFROGBACK | Skip-level rollback | BOOLEAN | 0 |
NAME | Task name | VARCHAR | 255 |
PARENTID | Parent task ID Associated table and field FINE_WORKFLOW_TASK_IMPL > PARENTID | VARCHAR | 255 |
PROCESSID | Process ID Associated table and field FINE_WORKFLOW_TASK_IMPL > PROCESSID | VARCHAR | 255 |
REMINDCONTROL | Notice method | VARCHAR | 65536 |
TASKNAMECALCULATEONCE | Whether Calculated only once when the task is initiated is selected during task adding 1: Selected 2: Unselected | BOOLEAN | 0 |
FINE_WORKFLOW_TASK_IMPL Task Details Table for Reporting Workflow
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ALERTED | Whether alerted 1: Yes 0: No | BOOLEAN | 0 |
COMPLETESTATE | Current task operator and completion status 1: Completed 0: Not completed Example: {"demo/authority/Product Sales Query.cpt":{"sunlin":0}} Note: If the reporting user identity is a role, the operator's role type ID and role ID are displayed instead of the username. | VARCHAR | 65536 |
CREATETIME | Creation time (time of delivery) | TIMESTAMP | 26 |
CURRENTNODEIDX | Current node ID | INTEGER | 32 |
DEADLINE | End time | TIMESTAMP | 26 |
FRTASKID | Source Task ID | VARCHAR | 255 |
NAME | Task name | VARCHAR | 255 |
NEEDALLCOMPLETE | Whether all tasks need to be completed 1: Yes 0: No | BOOLEAN | 0 |
NODEROUTE | Node traversal path (JSON format) | VARCHAR | 65536 |
NOTE | Note | VARCHAR | 16777216 |
OPERATORJSON | Index of the multi-user node in the workflow | VARCHAR | 65536 |
OPERATOROFFSET | Index of the user in the multi-user node | VARCHAR | 65536 |
OPERATOROFFSETNAME | Name of the user defined by OPERATOROFFSET | VARCHAR | 65536 |
PARENTID | Parent task ID Associated table and field FINE_WORKFLOW_TASK > PARENTID | VARCHAR | 255 |
PROCESSID | Process ID Associated table and field FINE_WORKFLOW_TASK > PROCESSID | VARCHAR | 255 |
REPORTOFFSET | Index of the template | INTEGER | 32 |
SENDTIME | Sending time | TIMESTAMP | 26 |
SENDER | Sender | VARCHAR | 255 |
SENDERID | Sender ID | VARCHAR | 255 |
SONTASKID | Subtask ID [{nodeIdx:0, userId:1, taskId:1}] | VARCHAR | 255 |
STATE | Task status -1: Initial 0: Pending reporting 1: Pending approval 2: Approved 3: Rejected 4: Closed 5: Timed out | INTEGER | 32 |
TASKID | Source Task ID Associated table and field FINE_WORKFLOW_TASK > ID | VARCHAR | 255 |
TASKBACKTARGET | Rollback information | VARCHAR | 255 |
FINE_WORKFLOW_NODE Reporting Workflow Node Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key Associated table and field FINE_WORKFLOW > NODESID | VARCHAR | 255 |
ALERTCONTROL | Alert details | VARCHAR | 1000 |
AUTHORITY | Permission | VARCHAR | 255 |
DESCRIPTION | Description | VARCHAR | 1000 |
NAME | Node name | VARCHAR | 255 |
NEEDALLCOMPLETE | Whether all tasks must be completed for transfer 1: Yes 0: No | BOOLEAN | 0 |
NEEDOFFLINEREPORT | Whether offline data entry is required 1: Yes 0: No | BOOLEAN | 0 |
PROCESSID | Process ID | VARCHAR | 255 |
REPORTCONTROL | Reporting details | VARCHAR | 1000 |
FINE_WORKFLOW_STASH_DATA Stashed Data Table for Reporting Workflow
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
DATA | Data | VARCHAR | 16777216 |
REPORTPATH | Report path | VARCHAR | 65536 |
USERID | User ID Associated table and field FINE_WORKFLOW > CREATORID | VARCHAR | 255 |
TASKID | Task ID | VARCHAR | 255 |
FINE_WORKFLOW_LOG Operation Log Table for Reporting Workflow
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
DATETIME | Date | TIMESTAMP | 26 |
MESSAGE | Message | VARCHAR | 65536 |
OPERATORNAME | Operator name Associated table and field FINE_WORKFLOW > CREATORID | VARCHAR | 255 |
PROCESSNAME | Process name | VARCHAR | 255 |
TASKNAME | Task name | VARCHAR | 255 |
System Configuration
FINE_CONF_CLASSNAME Interface Configuration Type Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Position of the current field in the configuration | VARCHAR | 255 |
CLASSNAME | Field type of the corresponding configuration value (for interface configurations) | VARCHAR | 255 |
FINE_CONF_ENTITY Configuration Entity Data Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Position of the data in the configuration | VARCHAR | 255 |
VALUE | Data value | VARCHAR | 65536 |
Note: This table contains most of the configurations in the database. For example: id = BackupConfig.backupMemory, value = 1024 means assigning a value of 1024 to the backupMemory configuration in BackupConfig, indicating that automatic backups can occupy up to 1024 MB.
Common platform configuration items and the configurations without a frontend UI are mostly stored in the FINE_CONF_ENTITY table.
FINE_CONF_XMLENTITY XML-Based Configuration Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Position of the data in the configuration | VARCHAR | 255 |
VALUE | XML text value of this field | BLOB | 67108864 |
FINE_INTERNATIONAL Multilingual Data Table
Note: This table is added in JAR packages released on or after 2020-02-28.
Field Name | Description | Data Type | Length | Note |
|---|---|---|---|---|
ID | Primary key | VARCHAR | 255 | / |
DESCRIPTION | Description | VARCHAR | 1000 | / |
I18NKEY | Internationalization key | VARCHAR | 255 | / |
LANGUAGE | Internationalization language zh_CN: Simplified Chinese zh_TW: Traditional Chinese en_US: English ja_JP: Japanese ko_KR: Korean | VARCHAR | 255 | / |
I18NVALUE | Internationalization value | VARCHAR | 1000 | Chinese characters must be converted into Unicode escape sequences using an online conversion tool before being written into the database. |
FINE_LABEL Label Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Record ID | VARCHAR | 255 |
LABELNAME | Label name | VARCHAR | 255 |
RELATEDTYPE | Label association type | INTEGER | 32 |
FINE_LABEL_INDEX Label Relationship Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Record ID | VARCHAR | 255 |
LABELID | Label ID | VARCHAR | 255 |
RELATEDID | Label association ID | VARCHAR | 255 |
FINE_OPS_EXCEED_TEMPLATES Exceed-Limit Template Table
Note: This table is added in FineReport version 11.0.5 or later, and FineBI version 5.1.23 or later.
This table records templates whose execution time exceeds the normal range, used for analysis on the O&M platform.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
TEMPLATENAME | Template name | VARCHAR | 255 |
TEMPLATETYPE | Exceed-limit type | VARCHAR | 255 |
FINE_OPS_CRASH_DETAIL Crash Record Table
Note: This table is added in FineReport version 11.0.5 or later, and FineBI 5.1.23 or later.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
DOWNTIME | Crash time | BIGINT | 64 |
NODE | Node | VARCHAR | 255 |
REASONDETAIL | Detailed reason | VARCHAR | 255 |
SOLUTION | Solution | VARCHAR | 255 |
FINE_NET_CHECK_RECORD Network Check Record Table
Note: This table is added in FineReport version 11.0.7 or later, and FineBI version 5.1.25 or later.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
CONFIG | VARCHAR | 1000 | |
HANDLERNODE | VARCHAR | 255 | |
ITEM | VARCHAR | 255 | |
RESULT | VARCHAR | 16777216 | |
TARGET | VARCHAR | 255 | |
TIME | BIGINT | 64 | |
TYPE | VARCHAR | 255 |
Swift Module (Non-Modifiable)
FINE_SWIFT_COL_IDX_CONF Field Index Configuration Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
COLUMNNAME | Field name | VARCHAR | 255 |
TABLEKEY | Data table source key | VARCHAR | 255 |
REQUIREGLOBALDICT | Whether to generate a global index 1: Yes 0: No | BOOLEAN | 0 |
REQUIREINDEX | Whether to generate an index 1: Yes 0: No | BOOLEAN | 0 |
FINE_SWIFT_CONFIG_ENTITY Swift Internal Configuration Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
CONFIGKEY | Location of the configuration | VARCHAR | 255 |
CONFIGVALUE | Configuration value | VARCHAR | 65536 |
FINE_SWIFT_METADATA Metadata Storage Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Source key calculated from the data table | VARCHAR | 255 |
FIELDS | Field information | VARCHAR | 65536 |
REMARK | Translated name | VARCHAR | 255 |
SCHEMANAME | Schema of the database table | VARCHAR | 255 |
SWIFTSCHEMA | Data file storage location CUBE/LOG | VARCHAR | 255 |
TABLENAME | Table name | VARCHAR | 255 |
FINE_SWIFT_SEG_LOCATION Swift Segment Distribution Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
CLUSTERID | Cluster ID | VARCHAR | 255 |
SEGMENTID | Generated Segment ID | VARCHAR | 255 |
SOURCEKEY | Data table source key, indicating which table the Segment belongs to | VARCHAR | 255 |
FINE_SWIFT_SEGMENTS Swift Segment Details Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Generated Segment ID | VARCHAR | 255 |
SEGMENTORDER | Segment sequence number | INTEGER | 32 |
SEGMENTOWNER | Data table source key, indicating which table the Segment belongs to | VARCHAR | 255 |
SEGMENTURI | Relative URL of the data file | VARCHAR | 65536 |
STORETYPE | Data storage type MEMORY: Data is stored only in memory and is lost upon shutdown. NIO: The memory content is written to files, eliminating data loss upon shutdown. FINE_IO: A proprietary IO framework developed by FineReport. When the NIO buffer is full, data is written to FINE_IO. | VARCHAR | 255 |
SWIFTSCHEMA | Data file storage directory CUBE/LOG | VARCHAR | 255 |
FINE_SWIFT_SERVICE_INFO Swift Service Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Service ID | VARCHAR | 255 |
CLUSTER_ID | Cluster ID | VARCHAR | 255 |
IS_SINGLETON | Whether the service is a singleton. 1: Yes 0: No | BOOLEAN | 0 |
SERVICE | Service type cluster_master_service: records the master node ID for synchronization across all nodes. Other values: Services started by each node (such as query, import, history, and real-time services, etc.) | VARCHAR | 255 |
SERVICE_INFO | Service details | VARCHAR | 255 |
FINE_SWIFT_TAB_IDX_CONF Table Index Configuration
Field Name | Description | Data Type | Length |
|---|---|---|---|
TABLEKEY | Table source key | VARCHAR | 255 |
ALLOTRULE | Block allocation logic | VARCHAR | 255 |
FINE_SWIFT_TABLE_PATH Cube Intermediate Path Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
CLUSTERID | Cluster ID The value is LOCAL in standalone mode. | VARCHAR | 255 |
TABLEKEY | Table source key | VARCHAR | 255 |
LASTPATH | Last used temporary path | INTEGER | 32 |
TABLEPATH | Current intermediate path | INTEGER | 32 |
TMPDIR | Intermediate path for Cube generation | INTEGER | 32 |
FINE_SWIFT_CLUSTER_SIZE
This table has been deprecated.
Field Name | Data Type | Length |
|---|---|---|
ID | VARCHAR | 255 |
PRIMARY_CLUSTER_SIZE | INTEGER | 32 |
DESCRIPTION | VARCHAR | 255 |
FINE_SWIFT_DAYS_RECORD Cache Table for Daily Access Statistics
Note: This table was deprecated in July 2022, and its content is now stored in the fine_pretreat_job_result table of the LogDB database.
A scheduled task runs in Swift every day at midnight to query the daily metrics (visit count, active template count, and active user count) from the previous day's access statistics and caches them in this table.
TASK in the field names of this table refers to this scheduled task.
Field Name | Description | Data Type | Length |
|---|---|---|---|
TASK_ID | Task ID | VARCHAR | 255 |
TASK_RESULT | Query results, including daily metrics (active user count, active template count, and visit count) | VARCHAR | 4096 |
TASK_CONDITION | Query conditions: Task type + Query time range | VARCHAR | 1024 |
TASK_TYPE | Task type | VARCHAR | 255 |
FINE_SWIFT_FILEKEY Time Index Table for Swift Segments
Field Name | Description | Data Type | Length |
|---|---|---|---|
SEGMENTID | ID of a Swift Segment, corresponding to ID in the FINE_SWIFT_SEGMENTS table | VARCHAR | 255 |
TIMEKEY | File index of a Swift Segment. In versions after 2021-04-11, the storage path for Cubes was modified: A folder is generated daily to store the data of that day, which is named with the date, e.g., 20210701. | VARCHAR | 255 |
FINE_SWIFT_RESTORE_RESULT Temporary Record Table for Log Restoration
This is a staging table for temporary records of log restoration. Data is automatically cleared upon successful completion. Under normal conditions, this table is empty.
Field Name | Description | Data Type | Length |
|---|---|---|---|
UUID | Record ID | VARCHAR | 255 |
CLUSTERID | Cluster ID The value is LOCAL in standalone mode. | VARCHAR | 255 |
ENDTIME | End time of the log restoration period | BIGINT | 64 |
ERRORCODE | Error code | INTEGER | 32 |
ERRORMSG | Error information | VARCHAR | 255 |
EXCEPTION | Exception information | VARCHAR | 65536 |
STARTTIME | Start time of the log restoration period | BIGINT | 64 |
SUCCESS |
true: Success false: Failure | BOOLEAN | [NULL] |
Quartz Module (Non-Modifiable)
QRTZ_BLOB_TRIGGERS BLOB-based Trigger Table
This table stores custom Trigger data in Binary Large Object (BLOB) format when Quartz users create specialized Trigger types via JDBC that JobStore cannot recognize for standard storage.
Field Name | Description | Data Type | Length |
|---|---|---|---|
SCHED_NAME | Scheduler name | VARCHAR | 255 |
TRIGGER_GROUP | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
TRIGGER_NAME | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
BLOB_DATA | A BLOB column that stores serialized Trigger objects | VARBINARY | 16777216 |
QRTZ_CALENDARS Calendar Information Storage Table
This table stores Calendar information in BLOB format. In Quartz, a Calendar can be configured to define or exclude specific time ranges for Triggers.
Field Name | Description | Data Type | Length |
|---|---|---|---|
CALENDAR_NAME | Calendar name | VARCHAR | 255 |
SCHED_NAME | Scheduler name | VARCHAR | 255 |
CALENDAR | A BLOB column that stores serialized Calendar objects | VARBINARY | 4000 |
QRTZ_BLOB_TRIGGERS Cron-based Trigger Table
This table stores cron expressions of Triggers.
Field Name | Description | Data Type | Length |
|---|---|---|---|
SCHED_NAME | Scheduler name | VARCHAR | 255 |
TRIGGER_GROUP | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
TRIGGER_NAME | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
CRON_EXPRESSION | Cron expression | VARCHAR | 255 |
TIME_ZONE_ID | Time zone | VARCHAR | 255 |
QRTZ_FIRED_TRIGGERS Fired Trigger Table
This table stores state information related to fired Triggers and execution information of associated Jobs.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ENTRY_ID | Scheduler instance ID | VARCHAR | 255 |
SCHED_NAME | Scheduler name | VARCHAR | 255 |
FIRED_TIME | Fired time | NUMERIC | 19 |
INSTANCE_NAME | Scheduler instance name | VARCHAR | 255 |
IS_NONCONCURRENT | Nonconcurrent or not 1: Nonconcurrent 0: Concurrent | BOOLEAN | 0 |
JOB_GROUP | Job group name in the cluster | VARCHAR | 255 |
JOB_NAME | Job name in the cluster | VARCHAR | 255 |
PRIORITY | Priority | INTEGER | 32 |
REQUESTS_RECOVERY | Whether recovery is requested (0 by default) 1: Yes 0: No | BOOLEAN | 0 |
SCHED_TIME | Scheduled fire time | NUMERIC | 19 |
STATE | State | VARCHAR | 255 |
TRIGGER_GROUP | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
TRIGGER_NAME | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
QRTZ_JOB_DETAILS Job Detail Table
This table stores details for each configured Job.
Field Name | Description | Data Type | Length |
|---|---|---|---|
JOB_GROUP | Job group name in the cluster | VARCHAR | 255 |
JOB_NAME | Job name in the cluster | VARCHAR | 255 |
SCHED_NAME | Scheduler name | VARCHAR | 255 |
DESCRIPTION | Description of the Job | VARCHAR | 255 |
IS_DURABLE | Durable or not 1: Yes, the Job is durable. 0: No, the Job is non-durable. | BOOLEAN | 0 |
IS_NONCONCURRENT | Nonconcurrent or not 1: Nonconcurrent 0: Concurrent | BOOLEAN | 0 |
IS_UPDATE_DATA | Whether to update data 1: Yes 0: No | BOOLEAN | 0 |
JOB_CLASS_NAME | Fully qualified name of the Job implementation class | VARCHAR | 255 |
JOB_DATA | A BLOB column that stores serialized Job objects | VARBINARY | 16777216 |
REQUESTS_RECOVERY | Whether recovery is requested (0 by default) 1: Yes 0: No | BOOLEAN | 0 |
CREATOP | / | VARCHAR | 255 |
QRTZ_LOCKS Scheduler Pessimistic Lock Table
This table stores scheduler pessimistic lock information.
Field Name | Description | Data Type | Length |
|---|---|---|---|
LOCK_NAME | Pessimistic lock name | VARCHAR | 255 |
SCHED_NAME | Scheduler name | VARCHAR | 255 |
QRTZ_PAUSED_TRIGGER_GRPS
This table stores information about paused Trigger groups.
Field Name | Description | Data Type | Length |
|---|---|---|---|
SCHED_NAME | Scheduler name | VARCHAR | 255 |
TRIGGER_GROUP | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
QRTZ_SCHEDULER_STATE
This table stores instance information of nodes in the cluster. Quartz periodically reads this table to determine the current state of each instance in the cluster.
Field Name | Description | Data Type | Length |
|---|---|---|---|
INSTANCE_NAME | Name of the scheduler instance | VARCHAR | 255 |
SCHED_NAME | Scheduler name | VARCHAR | 255 |
CHECKIN_INTERVAL | Check-in interval | NUMERIC | 19 |
LAST_CHECKIN_TIME | Last check-in time | NUMERIC | 19 |
QRTZ_SIMPLE_TRIGGERS Simple Trigger Table
This table stores information for simple Triggers, including repeat count, repeat interval, and number of times fired.
Field Name | Description | Data Type | Length |
|---|---|---|---|
SCHED_NAME | Scheduler name | VARCHAR | 255 |
TRIGGER_GROUP | Trigger group | VARCHAR | 255 |
TRIGGER_NAME | Trigger name | VARCHAR | 255 |
REPEAT_COUNT | Repeat count statistics | NUMERIC | 19 |
REPEAT_INTERVAL | Repeat interval | NUMERIC | 19 |
TIMES_TRIGGERED | Times fired | NUMERIC | 19 |
QRTZ_SIMPROP_TRIGGERS
The QRTZ_SIMPROP_TRIGGERS table stores CalendarIntervalTrigger and DailyTimeIntervalTrigger instances. CalendarIntervalTrigger is similar to SimpleTrigger and executes Jobs at fixed time intervals starting from a specified time. DailyTimeIntervalTrigger executes Jobs at fixed intervals within a specified daily time range.
Field Name | Description | Data Type | Length |
|---|---|---|---|
SCHED_NAME | Scheduler name | VARCHAR | 255 |
TRIGGER_GROUP | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
TRIGGER_NAME | Part of the foreign key to the QRTZ_TRIGGERS table | VARCHAR | 255 |
BOOL_PROP_1 | First Boolean parameter of the Trigger | BOOLEAN | 0 |
BOOL_PROP_2 | Second Boolean parameter of the Trigger | BOOLEAN | 0 |
DEC_PROP_1 | First decimal parameter of the Trigger | NUMERIC | 19 |
DEC_PROP_2 | Second decimal parameter of the Trigger | NUMERIC | 19 |
INT_PROP_1 | First integer parameter of the Trigger | INTEGER | 32 |
INT_PROP_2 | Second integer parameter of the Trigger | INTEGER | 32 |
LONG_PROP_1 | First long parameter of the Trigger | NUMERIC | 19 |
LONG_PROP_2 | Second long parameter of the Trigger | NUMERIC | 19 |
STR_PROP_1 | First String parameter of the Trigger | VARCHAR | 255 |
STR_PROP_2 | Second String parameter of the Trigger | VARCHAR | 255 |
STR_PROP_3 | Third String parameter of the Trigger | VARCHAR | 255 |
QRTZ_TRIGGERS Trigger Basic Information Table
This table stores basic information of Triggers.
Note: After setting the User Synchronization, you can locate the data with JOB_NAME being syncUser in the QRTZ_TRIGGERS table to view the user update time.
Field Name | Description | Data Type | Length |
|---|---|---|---|
SCHED_NAME | Scheduler name | VARCHAR | 255 |
TRIGGER_GROUP | Trigger group name | VARCHAR | 255 |
TRIGGER_NAME | Trigger name | VARCHAR | 255 |
CALENDAR_NAME | Calendar name | VARCHAR | 255 |
DESCRIPTION | Detailed description information | VARCHAR | 255 |
END_TIME | End time | NUMERIC | 19 |
JOB_DATA | A BLOB column that stores serialized Job objects | VARBINARY | 16777216 |
JOB_GROUP | Part of the foreign key to the QRTZ_JOB_DETAILS table | VARCHAR | 255 |
JOB_NAME | Part of the foreign key to the QRTZ_JOB_DETAILS table | VARCHAR | 255 |
MISFIRE_INSTR | Misfire instruction | INTEGER | 32 |
NEXT_FIRE_TIME | Next fire time | NUMERIC | 19 |
PREV_FIRE_TIME | Previous fire time | NUMERIC | 19 |
PRIORITY | Priority | INTEGER | 32 |
START_TIME | Start time | NUMERIC | 19 |
TRIGGER_STATE | Current Trigger state WAITING PAUSED ACQUIRED BLOCKED ERROR | VARCHAR | 255 |
TRIGGER_TYPE | Trigger type SIMPLE: Triggers fire repeatedly at specific time intervals. For example, they start at 9 AM and fire every hour. CRON: Triggers fire based on a calendar schedule. For example, they fire every Tuesday at 2 AM. | VARCHAR | 255 |
APPOINT_ID | Platform cluster node ID This field indicates on which node the Trigger should run; if left blank, the Trigger can run on all nodes. | VARCHAR | 255 |
Mobile Terminal
FINE_MOBILE_DEVICE Mobile Device Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CREATEDATE | Device creation date | TIMESTAMP | 26 |
DEVICENAME | Device name | VARCHAR | 255 |
MACADDRESS | Device MAC address | VARCHAR | 255 |
PASSED | Whether the device has passed authentication 1: Yes 0: No | BOOLEAN | 0 |
UPDATEDATE | Device update date | TIMESTAMP | 26 |
USERNAME | Associated username | VARCHAR | 255 |
FINE_MOBILE_PUSH_MESSAGE Mobile Message Push Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
GROUPID | Message recipient group ID | VARCHAR | 255 |
MEDIAID | Image ID for a rich text message | VARCHAR | 255 |
MSGTYPE | Message type 1: Regular text message 2: Graphic message 3: File message | INTEGER | 32 |
TERMINAL | Push terminal Currently fixed at 1, representing app notification | INTEGER | 32 |
TITLE | Message title | VARCHAR | 255 |
ID | Primary key | VARCHAR | 255 |
FINE_WEIXIN_USER_RELATION Manual Mapping Table of WeChat & Platform Users
Note: Data appears in this table after you set User Match Way to Manual Match on the Member Management tab under System Management > WeChat Management and bind the platform users with WeChat users.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
FSUSER | Platform username | VARCHAR | 255 |
WEIXINUSER | WeChat user ID | VARCHAR | 255 |
FINE_WEIXIN_OUTPUT Table of WeChat-Pushed Scheduled Tasks
Note: Data is generated in this table only when Client Notification > WeChat Notification is selected in Task Schedule settings, and the settings are saved.
Field Name | Description | Data Type | Length |
|---|---|---|---|
AGENTID | Application ID | VARCHAR | 255 |
CONTENT | Content of client notification | VARCHAR | 255 |
CUSTOMIZELINK | Content filled in the custom link | VARCHAR | 255 |
LINKOPENTYPE | Link type of client notification 1: Scheduled task link 2: Custom link | VARCHAR | 255 |
MEDIAID | Media ID of a file or image obtained by calling the upload interface | VARCHAR | 255 |
SUBJECT | Title of client notification | VARCHAR | 255 |
TERMINAL | Fixed at 2, representing WeChat notification | INTEGER | 32 |
TYPE | Message type for client notification 1: Link message 2: Graphic message 3: File message | INTEGER | 32 |
ID | Primary key | VARCHAR | 255 |
ADDRESSEE | Additional client for receiving messages, while 1 represents group push. | INTEGER | 32 |
CHATGROUPS | String array storing group push IDs | VARCHAR | 255 |
FINE_WEIXIN_AGENT Application Information Table in WeChat Management
Note: Data is generated in this table only when Client Notification > WeChat Notification is selected in Task Schedule settings and the settings are saved.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
AGENTID | Application ID | VARCHAR | 255 |
AGENTNAME | Application name | VARCHAR | 255 |
CORPID | Enterprise Corp ID | VARCHAR | 255 |
SECRET | Application secret key | VARCHAR | 255 |
TIMESTAMP | Timestamp | VARCHAR | 255 |
TYPE | Application type 1: Management group secret application (legacy) 2: Normal application 3: Application that failed to obtain a token | INTEGER | 32 |
FINE_WEIXIN_GROUP WeChat Group Information Table in WeChat Management
Note: Data is generated in this table only when Client Notification > WeChat Chatgroup is selected in Task Schedule settings and the settings are saved.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
AGENTID | Application ID | VARCHAR | 255 |
GROUPID | Group Chat ID, used for push notification | VARCHAR | 255 |
GROUPNAME | Group name | VARCHAR | 255 |
TIMESTAMP | Timestamp | VARCHAR | 255 |
FINE_FEISHU_USER_RELATION Manual Mapping Table of Lark & Platform Users
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
FSUSER | Platform username | VARCHAR | 255 |
FEISHUUSER | Lark user ID | VARCHAR | 255 |
FINE_FEISHU_OUTPUT Table of Lark-pushed Scheduled Tasks
Field Name | Description | Data Type | Length |
|---|---|---|---|
AGENTID | Application ID | VARCHAR | 255 |
CONTENT | Content of client notification | VARCHAR | 255 |
CUSTOMIZELINK | Content filled in the custom link | VARCHAR | 255 |
LINKOPENTYPE | Link type of client notification 1: Scheduled task link 2: Custom link | VARCHAR | 255 |
MEDIAID | Media ID of a file or image obtained by calling the upload interface | VARCHAR | 255 |
SUBJECT | Title of client notification | VARCHAR | 255 |
TERMINAL | Fixed at 4, representing DingTalk notification | INTEGER | 32 |
TYPE | Message type for client notification 1: Link message 2: Graphic message 3: File message | INTEGER | 32 |
ID | Primary key | VARCHAR | 255 |
ADDRESSEE | Additional client for receiving messages1 represents group push. | INTEGER | 32 |
CHATGROUPS | String array storing group push IDs | VARCHAR | 255 |
FINE_FEISHU_AGENT Application Information Table in Lark Management
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
AGENTID | Application ID | VARCHAR | 255 |
AGENTNAME | Application name | VARCHAR | 255 |
CORPID | Enterprise Corp ID | VARCHAR | 255 |
ENCRYPTED | Encrypted or not true: Encrypted false: Not encrypted | BOOLEAN | 0 |
SECRET | Application secret key | VARCHAR | 255 |
TIMESTAMP | Timestamp | VARCHAR | 255 |
TYPE | Application type 1: Management group secret application (legacy) 2: Normal application 3: Application that failed to obtain token | INTEGER | 32 |
FINE_FEISHU_GROUP Lark Group Information Table in Lark Management
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
AGENTID | Application ID | VARCHAR | 255 |
GROUPID | Group Chat ID, used for push notification | VARCHAR | 255 |
GROUPNAME | Group name | VARCHAR | 255 |
TIMESTAMP | Timestamp | VARCHAR | 255 |
Reports
FINE_PARAM_TEMPLATE Template Parameter Combination Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
TEMPLATEID | Template ID | VARCHAR | 255 |
TPGROUP | Parameter combination | VARCHAR | 65536 |
USERNAME | Username | VARCHAR | 255 |
FINE_PRINT_OFFSET Print Offset Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CPTNAME | Template name | VARCHAR | 50 |
IP | Client IP address | VARCHAR | 20 |
OFFSETX | Horizontal offset | VARCHAR | 50 |
OFFSETY | Vertical offset | VARCHAR | 50 |
SIGN | Offset option 0: No offset 1: Global configuration 2: Single template configuration | VARCHAR | 10 |
FINE_PRINT_OFFSET_IP_RELATE IP Association Table for Print Offset
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CHILDIP | Associated client IP Associated table and field FINE_PRINT_OFFSET > ID | VARCHAR | 20 |
MOTHERID | ID from the Print Offset table | VARCHAR | 255 |
FINE_REMOTE_DESIGN_AUTH Remote Design User Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
PATH | Path authorized for remote design | VARCHAR | 1000 |
PATHTYPE | Path type 0: File 1: Folder | BOOLEAN | 0 |
USERID | User ID | VARCHAR | 255 |
USERNAME | Username | VARCHAR | 255 |
ROLETYPE | Role type 0: No role 1: Department position role 2: Custom role 3: User role | INTEGER | 32 |
FINE_WRITE_STASH Data Entry Stash Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
DATA | Temporary data | VARCHAR | 16777216 |
REPORTPATH | Template path | VARCHAR | 1000 |
USERNAME | Username | VARCHAR | 255 |
FINE_PROCESS_EXPAND Expansion Table for FineReport Data Reporting Process
This table is an expansion attribute table for permission entities of the data reporting workflow.
It contains the attributes of reporting workflows configured in the decision-making platform directory, including name, path, description, type, display terminal, and parameter settings.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
PROCESSTYPE | Reporting workflow type 1: Reporting task management 2: Reporting workflow management 3: My reporting task | INTEGER | 32 |
FINE_REPORT_EXPAND FineReport Report Expansion Table
This table is an expansion attribute table for report permission entities. It contains the report attributes configured in the decision-making platform directory.
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
SHOWTYPE | 0: Data entry 1: Pagination 2: Analysis 3: Table preview 4: New data entry 5: PC preview of the FRM report | INTEGER | 32 |
TRANSMITPARAMETERS | Custom preview parameters | VARCHAR | 65536 |
FINE_EXCEL_SUBMIT_TASK Expansion Table for Permission Entities of Excel Batch Import
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CREATETIME | Task creation time | TIMESTAMP | 26 |
DESCRIPTION | Description | VARCHAR | 1000 |
NAME | Task name | VARCHAR | 255 |
REPORTPATH | Associated template path | VARCHAR | 1000 |
SUBMITTIME | Submission time | TIMESTAMP | 26 |
FINE_VCS Template Version Management Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
COMMITCODE | Commit ID used for rollback | VARCHAR | 255 |
COMMITMSG | Commit message | VARCHAR | 255 |
FILENAME | Template name | VARCHAR | 255 |
TIME | Submission time | TIMESTAMP | 26 |
USERNAME | Username | VARCHAR | 255 |
VERSION | Version number | INTEGER | 32 |
FINE_COMPONENT_HEALTH Component Health Record Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
CLUSTERNODEID | Node ID | VARCHAR | 255 |
EXTRAINFO | Additional information Reserved field; currently unused. | VARCHAR | 65536 |
MODULE | Module | VARCHAR | 255 |
STATUS |
1: Available 2: Not enabled 3: Exception 4: Timeout 5: Unknown error | INTEGER | 32 |
TIME | Submission time | TIMESTAMP | 26 |
Open Platform Plugin
Note: All tables in this chapter are generated only after the Open Platform plugin is installed.
FR_OPEN_API API Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
CREATETIME | Creation date | TIMESTAMP | 26 |
DESCRIPTION | Description | VARCHAR | 255 |
EDITABLE |
1: Editable 0: Not editable | INTEGER | 32 |
ENABLE |
1: Available 0: Unavailable | INTEGER | 32 |
NAME | I18n key for the display name | VARCHAR | 255 |
CLASS | Class path | VARCHAR | 255 |
CONFIG | Configuration item (json) | VARCHAR | 10000 |
TDEFAULT | Default parameter (json) | VARCHAR | 255 |
INFO | Request path | VARCHAR | 255 |
ISPUBLIC |
1: Public 0: Private | INTEGER | 32 |
METHOD | Method (GET/POST, etc.) | VARCHAR | 255 |
FR_OPEN_APP Client Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
CREATETIME | Creation date | TIMESTAMP | 26 |
DESCRIPTION | Description | VARCHAR | 255 |
EDITABLE |
1: Editable 0: Non-editable | INTEGER | 32 |
ENABLE |
1: Available0: Unavailable | INTEGER | 32 |
NAME | I18n key for the display name | VARCHAR | 255 |
ICON | Icon | VARCHAR | 255 |
SECRET | Secret key (encrypted) | VARCHAR | 255 |
SPAREAUTH | Authenticator ID | VARCHAR | 255 |
FR_OPEN_AUTH Permission Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
CREATETIME | Creation date | TIMESTAMP | 26 |
DESCRIPTION | Description | VARCHAR | 255 |
EDITABLE |
1: Editable 0: Non-editable | INTEGER | 32 |
ENABLE |
1: Available 0: Unavailable | INTEGER | 32 |
NAME | I18n key for the display name | VARCHAR | 255 |
CLAZZ | Class path | VARCHAR | 255 |
CONFIG | Configuration item (json) | VARCHAR | 255 |
TDEFAULT | Default parameter (json) | VARCHAR | 255 |
FR_OPEN_GROUP API Group Name Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
CREATETIME | Creation date | TIMESTAMP | 26 |
DESCRIPTION | Description | VARCHAR | 255 |
EDITABLE |
1: Editable 0: Non-editable | INTEGER | 32 |
ENABLE |
1: Available 0: Unavailable | INTEGER | 32 |
NAME | I18n key for the display name | VARCHAR | 255 |
FR_OPEN_PRIVILEGE Open Platform Permission Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
APIID | API ID | VARCHAR | 255 |
CLIENTID | Client ID | VARCHAR | 255 |
FR_OPEN_RELATION Group and API Association Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | ID | VARCHAR | 255 |
GROUPID | Group ID | VARCHAR | 255 |
FR_OPEN_API_PERFORMANCE API Query Rate Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | API ID | VARCHAR | 255 |
FREQUENCY | Access frequency limit for the corresponding API Unit: requests/s | INTEGER | 32 |
Multi-Product Connection Tool Plugin
Note: All tables in this chapter are generated only when the Multi-Product Connection Tool plugin is installed.
FINE_COORDINATOR_ENTRY Secondary Server Template
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
ORIGINPATH | Original path of the secondary server template | VARCHAR | 255 |
FINE_COORDINATOR_SERVER Secondary Server Information Table
Field Name | Description | Data Type | Length |
|---|---|---|---|
ID | Primary key | VARCHAR | 255 |
NAME | Secondary server name | VARCHAR | 255 |
URL | URL address of the secondary server | VARCHAR | 1000 |
WITHTEMPLATE | Whether the secondary server hosts templates 0: No 1: Yes | BOOLEAN | / |
Previous：Changing the Username and Password of the External Database
