CREATE TABLE reservation_notes (
  idReservation           INT             NOT NULL,
  idEntityCompany         INT             NOT NULL,
  note_index              TINYINT UNSIGNED NOT NULL,     -- posição no array
  note                     TEXT           NULL,
  PRIMARY KEY (idReservation, idEntityCompany, note_index),
  FOREIGN KEY (idReservation, idEntityCompany)
    REFERENCES reservation_details(idReservation, idEntityCompany)
    ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
