SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS tut_acta_modelo_respuesta (
  id_respuesta INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  id_acta INT UNSIGNED NOT NULL,
  modelo_codigo VARCHAR(20) NOT NULL,
  seccion VARCHAR(60) NOT NULL,
  campo_codigo VARCHAR(80) NOT NULL,
  etiqueta VARCHAR(220) NOT NULL,
  valor TEXT NULL,
  marcado TINYINT(1) NULL,
  observacion TEXT NULL,
  orden SMALLINT UNSIGNED NOT NULL DEFAULT 1,
  creado_en TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  actualizado_en TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uq_tut_acta_modelo_resp (id_acta, modelo_codigo, seccion, campo_codigo),
  KEY idx_tut_acta_modelo_resp_modelo (modelo_codigo, seccion),
  CONSTRAINT fk_tut_acta_modelo_resp_acta FOREIGN KEY (id_acta)
    REFERENCES tut_acta_compromiso(id_acta) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;