dy-a-coder.idempotent.1.0.0.source-code.idempotent.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of idempotent Show documentation

A simple idempotent component that addresses the prevention of duplicate submissions, duplicate notifications, and duplicate transaction compensation.

There is a newer version: 2.1.0

Show newest version

CREATE TABLE `idempotent_request` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT,
  `prj_name` varchar(64) DEFAULT NULL,
  `interface_name` varchar(64) DEFAULT NULL,
  `request_param` varchar(2048) DEFAULT NULL,
  `response` varchar(2048) DEFAULT NULL,
  `biz_column_values` varchar(512) DEFAULT NULL,
  `sign` varchar(64) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `valid_end_time` datetime DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_sign` (`sign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;