SET NAMES utf8mb4;
CREATE TABLE IF NOT EXISTS experiment_operation_acknowledgements (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 workspace_id BIGINT UNSIGNED NOT NULL,
 experiment_id BIGINT UNSIGNED NOT NULL,
 alert_key VARCHAR(80) NOT NULL,
 user_id BIGINT UNSIGNED NULL,
 acknowledged_at DATETIME NOT NULL,
 UNIQUE KEY uq_eoa_exp_alert(experiment_id,alert_key),
 INDEX idx_eoa_ws(workspace_id),
 CONSTRAINT fk_eoa_workspace FOREIGN KEY(workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE,
 CONSTRAINT fk_eoa_experiment FOREIGN KEY(experiment_id) REFERENCES ab_experiments(id) ON DELETE CASCADE,
 CONSTRAINT fk_eoa_user FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
