| | 43 | === gendbi generated sql === |
| | 44 | |
| | 45 | {{{ |
| | 46 | #!sql |
| | 47 | |
| | 48 | DROP TABLE IF EXISTS `SimPmtSpec`; |
| | 49 | CREATE TABLE `SimPmtSpec` ( |
| | 50 | `SEQNO` int(11) NOT NULL, |
| | 51 | `ROW_COUNTER` int(11) NOT NULL auto_increment, |
| | 52 | `pmtId` int(11) default NULL COMMENT 'PMT sensor ID', |
| | 53 | `describ` varchar(27) default NULL COMMENT 'String of decribing PMT position', |
| | 54 | `gain` float default NULL COMMENT 'Relative gain for pmt with mean = 1', |
| | 55 | `sigmaGain` float default NULL COMMENT '1-sigma spread of S.P.E. response', |
| | 56 | `timeOffset` float default NULL COMMENT 'Relative transit time offset', |
| | 57 | `timeSpread` float default NULL COMMENT 'Transit time spread', |
| | 58 | `efficiency` float default NULL COMMENT 'Absolute efficiency', |
| | 59 | `prePulseProb` float default NULL COMMENT 'Probability of prepulsing', |
| | 60 | `afterPulseProb` float default NULL COMMENT 'Probability of afterpulsing', |
| | 61 | `darkRate` float default NULL COMMENT 'Dark Rate', |
| | 62 | PRIMARY KEY (`SEQNO`,`ROW_COUNTER`) |
| | 63 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| | 64 | |
| | 65 | |
| | 66 | }}} |
| | 67 | |
| | 68 | |
