DynamicParameters Table

Description: Stores dynamic parameters associated with each ticket.

Table Definition:

CREATE TABLE DynamicParameters (
    id VARCHAR(255) PRIMARY KEY,
    ticketId INT NOT NULL,
    flowId VARCHAR(255) NULL,
    name VARCHAR(255) NOT NULL,
    strValue VARCHAR(500) NULL,
    boolValue BOOLEAN NULL,
    intValue INT NULL,
    numValue DECIMAL(18, 4) NULL,
    type VARCHAR(50) NOT NULL,
    creationDatetime DATETIME NOT NULL,
    FOREIGN KEY (ticketId) REFERENCES Ticket(id)
);

Fields:

Field Name	Data Type	Nullability	Constraints	Description
id	VARCHAR(255)	NOT NULL	PRIMARY KEY	Unique identifier for each parameter.
ticketId	INT	NOT NULL	FOREIGN KEY	References Ticket(id).
flowId	VARCHAR(255)	NULL		Flow identifier associated with the parameter.
name	VARCHAR(255)	NOT NULL		Name of the parameter.
strValue	VARCHAR(500)	NULL		String value of the parameter.
boolValue	BOOLEAN	NULL		Boolean value of the parameter.
intValue	INT	NULL		Integer value of the parameter.
numValue	DECIMAL(18, 4)	NULL		Numeric value of the parameter.
type	VARCHAR(50)	NOT NULL		Type of the parameter (e.g., "String", "Int").
creationDatetime	DATETIME	NOT NULL		Creation timestamp of the parameter.

---