BotConversationSteps Table

Description: Stores bot conversation steps associated with each ticket.

Table Definition:

CREATE TABLE BotConversationSteps (
    id INT PRIMARY KEY AUTO_INCREMENT,
    ticketId INT NOT NULL,
    departmentId VARCHAR(255) NULL,
    botConversationId VARCHAR(255) NULL,
    flowId VARCHAR(255) NULL,
    flowVersion INT NULL,
    flowName VARCHAR(255) NULL,
    stepType VARCHAR(50) NOT NULL,
    uniqueCardId VARCHAR(255) NULL,
    cardFriendlyName VARCHAR(255) NULL,
    visitDatetime DATETIME NOT NULL,
    FOREIGN KEY (ticketId) REFERENCES Ticket(id)
);

Fields:

Field Name	Data Type	Nullability	Constraints	Description
id	INT	NOT NULL	PRIMARY KEY, AUTO_INCREMENT	Unique identifier for each conversation step.
ticketId	INT	NOT NULL	FOREIGN KEY	References Ticket(id).
departmentId	VARCHAR(255)	NULL		Department ID.
botConversationId	VARCHAR(255)	NULL		Bot conversation ID.
flowId	VARCHAR(255)	NULL		Flow ID associated with the step.
flowVersion	INT	NULL		Version of the flow.
flowName	VARCHAR(255)	NULL		Name of the flow.
stepType	VARCHAR(50)	NOT NULL		Type of step (e.g., "Message", "Action").
uniqueCardId	VARCHAR(255)	NULL		Unique card ID associated with the step.
cardFriendlyName	VARCHAR(255)	NULL		Friendly name of the card (optional).
visitDatetime	DATETIME	NOT NULL		Timestamp when the step was visited.

---