ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_message_table.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

--liquibase formatted sql
--changeset message_table:18_10.create_message_table.sql

CREATE TABLE NELGEN_MESSAGE (NELGEN_MESSAGE_ID  VARCHAR(500) PRIMARY KEY, 
MESSAGE_ID VARCHAR(500) COMMENT 'Message id', 
CONVERSATION_ID  VARCHAR(500) COMMENT 'Conversation id for the transaction',
SERVICE_NAME VARCHAR(100) COMMENT 'Service name',
START_TIME DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'Transaction start time', 
ELAPSED_MILLIS INTEGER ,
STATUS VARCHAR(20) COMMENT 'Transaction status', 
REQUEST LONGTEXT NOT NULL COMMENT 'Request JSON',
RESPONSE LONGTEXT COMMENT 'Request JSON', 
REQUESTER VARCHAR(50) COMMENT 'Requester'
);