WHOlistener_Database

Field Descripton Size
ID Sequential # 40
DATE YYY-MM-DD HH:MM:SS 2
NODE os,lk,pt,nb,se 2
DB db level 3
TRIGGER PWR or PKT 6
IMAGE jpg filename 40
SOUND mp3 filename 40
CLASS ship/boat/orca.. 10
CLASSIFIER person 20
CONF confidence 1
COMMENT comment 80
CREATE TABLE `orcasoundnodes`.`WHO_detection` (
`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`DATE` DATETIME NOT NULL ,
`NODE` CHAR( 2 ) NOT NULL ,
`DB` INT NOT NULL ,
`TRIGGER` CHAR( 6 ) NOT NULL ,
`IMAGE` VARCHAR( 40 ) NOT NULL ,
`SOUND` VARCHAR( 40 ) NOT NULL ,
`CLASS` VARCHAR( 20 ) NOT NULL ,
`CLASSIFIER` VARCHAR( 40 ) NOT NULL ,
`CONF` INT NOT NULL ,
`COMMENT` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM