Table Create Table photon CREATE TABLE `photon` (\n `id` bigint(20) NOT NULL auto_increment,\n `dir` int(11) default NULL,\n `obc_time` double default NULL,\n `fims_time` int(11) default NULL,\n `x` float default NULL,\n `y` float default NULL,\n `pht` smallint(6) default NULL,\n `lambda` float default NULL,\n `phi` float default NULL,\n `ra` double default NULL,\n `decl` double default NULL,\n `eq_lon` double default NULL,\n `eq_lat` double default NULL,\n `filter` smallint(6) default NULL,\n `mask` int(11) default NULL,\n `flags` int(11) default NULL,\n `q_pix` int(11) default NULL,\n `grasp_factor` float default NULL,\n `band_id` smallint(6) default NULL,\n `acs_error` float default NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `x` (`x`,`y`,`fims_time`,`obc_time`),\n KEY `lambda` (`lambda`),\n KEY `phi` (`phi`),\n KEY `ra` (`ra`,`decl`),\n KEY `dir` (`dir`),\n CONSTRAINT `0_69` FOREIGN KEY (`dir`) REFERENCES `input_dir` (`id`)\n) TYPE=InnoDB