这是我的sql语句
CREATE TABLE `safety_check` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`template_id` INT(11) NOT NULL,
`org_id` INT(11) NOT NULL,
`start_time` DATETIME NOT NULL,
`end_time` DATETIME NOT NULL,
`check_person` VARCHAR(50) NOT NULL,
`check_deadline` DATETIME NOT NULL,
`status` INT(11) NOT NULL DEFAULT '0',
`risk_id` INT(11) NOT NULL,
`hidden_status` INT(11) NOT NULL DEFAULT '0',
`hidden_info` VARCHAR(500) DEFAULT NULL,
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_template_id` (`template_id`),
KEY `idx_org_id` (`org_id`),
KEY `idx_risk_list_id` (`risk_id`),
CONSTRAINT `fk_safety_check_risk_id` FOREIGN KEY (`risk_id`) REFERENCES `risk_list` (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COMMENT='安全生产检查表';
这是我要关联的表的语句。
CREATE TABLE `risk_list` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '风险清单ID',
`category_id` bigint(20) NOT NULL COMMENT '风险类别ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '风险名称',
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '风险描述',
`risk_level` enum('LOW','MEDIUM','HIGH','CRITICAL') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '风险级别: 低, 中, 高, 严重',
PRIMARY KEY (`id`) USING BTREE,
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '风险清单表' ROW_FORMAT = Dynamic;
CREATE TABLE `safety_check` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`template_id` INT(11) NOT NULL,
`org_id` INT(11) NOT NULL,
`start_time` DATETIME NOT NULL,
`end_time` DATETIME NOT NULL,
`check_person` VARCHAR(50) NOT NULL,
`check_deadline` DATETIME NOT NULL,
`status` INT(11) NOT NULL DEFAULT '0',
`risk_id` INT(11) NOT NULL,
`hidden_status` INT(11) NOT NULL DEFAULT '0',
`hidden_info` VARCHAR(500) DEFAULT NULL,
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_template_id` (`template_id`),
KEY `idx_org_id` (`org_id`),
KEY `idx_risk_list_id` (`risk_id`),
CONSTRAINT `fk_safety_check_risk_id` FOREIGN KEY (`risk_id`) REFERENCES `risk_list` (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COMMENT='安全生产检查表';
这是我要关联的表的语句。
CREATE TABLE `risk_list` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '风险清单ID',
`category_id` bigint(20) NOT NULL COMMENT '风险类别ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '风险名称',
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '风险描述',
`risk_level` enum('LOW','MEDIUM','HIGH','CRITICAL') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '风险级别: 低, 中, 高, 严重',
PRIMARY KEY (`id`) USING BTREE,
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '风险清单表' ROW_FORMAT = Dynamic;