1 --liquibase formatted sql
2 --changeset message_table:18_10.create_message_table.sql
4 CREATE TABLE NELGEN_MESSAGE (NELGEN_MESSAGE_ID VARCHAR(500) PRIMARY KEY,
5 MESSAGE_ID VARCHAR(500) COMMENT 'Message id',
6 CONVERSATION_ID VARCHAR(500) COMMENT 'Conversation id for the transaction',
7 SERVICE_NAME VARCHAR(100) COMMENT 'Service name',
8 START_TIME DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'Transaction start time',
9 ELAPSED_MILLIS INTEGER ,
10 STATUS VARCHAR(20) COMMENT 'Transaction status',
11 REQUEST LONGTEXT NOT NULL COMMENT 'Request JSON',
12 RESPONSE LONGTEXT COMMENT 'Request JSON',
13 REQUESTER VARCHAR(50) COMMENT 'Requester'