table footests

| footests | CREATE TABLE `footests` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `leak_id` int(11) DEFAULT NULL,
  `inspection_type` varchar(50) DEFAULT NULL,
  `inspection_method` varchar(50) DEFAULT NULL,
  `l_component_type` varchar(50) DEFAULT NULL,
  `repair_notes` varchar(10000) DEFAULT NULL,
  `remonitoring_date` datetime DEFAULT NULL,
  `remonitoring_notes` varchar(10000) DEFAULT NULL,
  `test_type` varchar(15) DEFAULT NULL,
  `is_fixed` tinyint(1) DEFAULT NULL,
  `is_delayed` tinyint(1) DEFAULT NULL,
  `days_open` int(11) DEFAULT NULL,
  `delay_description` varchar(10000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  CONSTRAINT `footests_ibfk_1` FOREIGN KEY (`id`) REFERENCES `tests` (`id`) ON DELETE CASCADE,
  CONSTRAINT `footests_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `footests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |