text: CREATE TABLE IF NOT EXISTS `SUBSTATUS_DOUBLEANNOTATION` (
    `ID` bigint(20) NOT NULL AUTO_INCREMENT,
    `ATTRIBUTE` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    `SUBMISSION_ID` bigint(20) NOT NULL,
    `VALUE` double DEFAULT NULL,
    `IS_PRIVATE` boolean,
    PRIMARY KEY (`ID`),
    UNIQUE KEY `DOUBLE_ANNO_UNIQUE` (`SUBMISSION_ID`,`ATTRIBUTE`),
    FOREIGN KEY (`SUBMISSION_ID`) REFERENCES `SUBSTATUS_ANNOTATIONS_OWNER` (`SUBMISSION_ID`) ON DELETE CASCADE
  )
  