logger table structure, Log table structure for event or activity logging

logTable.sql

-- scriptdb.logs definition

CREATE TABLE `logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `traceId` text,
  `eventId` text,
  `eventName` text,
  `actionType` text,
  `userId` text,
  `msisdn` text,
  `key1` text,
  `key2` text,
  `value1` text,
  `value2` text,
  `source` text,
  `status` text,
  `createdAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;