Event Database Structure
The Event Logging Database schema consists of two primary tables:
-
EVENTLOG
-
EVENTLOG_METADATA
For the complete list of Compatible Databases, see the Talend Installation and Upgrade Guide .
To create those tables, SQL scripts are provided to you for the supported databases.
-
Make sure your chosen database is installed properly and is accessible.
-
Log in with a user account with CREATE permissions and run the "init SQL" scripts for the corresponding database (see table below). There are two initial scripts for each database. The script with "_ind" suffix is used to create indexes in database.
The script files for the corresponding databases are described in the following table. The SQL scripts can be found in the <TalendRuntimePath>/add-ons/event-logging/db directory.
SQL script filename
Database
create.sql
create_ind.sql
Apache Derby create_mysql.sql
create_mysql_ind.sql
MySQL create_oracle.sql
create_oracle_ind.sql
Oracle create_sqlserver.sql
create_sqlserver_ind.sql
SQL Server create_h2.sql
create_h2_ind.sql
H2 Database Engine create_db2.sql
create_db2_ind.sql
IBM DB2 create_postgresql.sql
create_postgresql_ind.sql
PostgreSQL
Once the scripts executed, the EVENTLOG and EVENTLOG_METADATA tables are created in your database. Below is the data structure of those tables:
For the EVENTLOG table:
| Field | Type |
|---|---|
| ID(Primary Key) | BIGINT |
| EVENT_UUID | CHAR(36) |
| CATEGORY | varchar(255) |
| EVENT_TYPE | varchar(255) |
| LOG_MESSAGE | CLOB(2147483647) |
| SEVERITY | varchar(255) |
| LOG_SOURCE | varchar(4000) |
| AGENT_TIMESTAMP | TIMESTAMP |
| SERVER_TIMESTAMP | TIMESTAMP |
| LOG_TIMESTAMP | TIMESTAMP |
| AUDIT | char(1) |
| AGENT_ID | varchar(255) |
| AUDIT_SEQUENCE_NO | varchar(255) |
| SIGNED_LOG_MESSAGE | BLOB(2147483647) |
| CORRELATION_ID | varchar(255) |
| SUBJECT | varchar(255) |
For the EVENTLOG_METADATA table:
| Field | Type | Description |
|---|---|---|
| ID(Primary Key) | BIGINT | Unique id of the CustomInfo |
| EVENT_ID | BIGINT | Relative EVENT's ID value |
| METADATA_TYPE | varchar(255) | Metadata type |
| METADATA_KEY | varchar(255) | Metadata key |
| METADATA_VALUE | varchar(4000) | Metadata value |