blob: 33b424343ceb24f5cdde45e7a1a34fdfe11e686b (
plain)
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 VARCHAR(10000) NOT NULL COMMENT 'Request JSON',
RESPONSE VARCHAR(20000) COMMENT 'Request JSON',
REQUESTER VARCHAR(50) COMMENT 'Requester'
);
|