20220524_update.sql

CREATE TABLE `procedure_instance_importer` (
  `procedure_instance_importer_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) NOT NULL,
  `procedure_id` bigint(20) NOT NULL,
  `name` varchar(512) NOT NULL,
  `type` varchar(32) NOT NULL,
  `configuration` longtext NOT NULL,
  `mappers_configuration` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`procedure_instance_importer_id`),
  KEY `procedure_instance_importer_tenant_IDX` (`tenant_id`),
  KEY `procedure_instance_importer_procedure_IDX` (`procedure_id`),
  CONSTRAINT `procedure_instance_importer_procedure_FK` FOREIGN KEY (`procedure_id`) REFERENCES `procedure` (`procedure_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `procedure_instance_importer_tenant_FK` FOREIGN KEY (`tenant_id`) REFERENCES `tenant` (`tenant_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;