     sequence                  INT(10) UNSIGNED NOT NULL,
     media                     TINYINT(1) DEFAULT 0,
     data_analysis             TINYINT(1) DEFAULT 0,
-    data_analysis_notes       TEXT,
+    data_analysis_notes       VARCHAR(200),
     stable_key                INT(10) DEFAULT 0,
  
     PRIMARY KEY (id),

    external_id                VARCHAR(50),
    date_of_experiment         TIMESTAMP,
    organisation_id            INT(10) UNSIGNED NOT NULL,  
    
    PRIMARY KEY(id),
    KEY external_db_idx(db_id),

    KEY category_idx(category)
    
) COLLATE=utf8_general_ci ENGINE=MyISAM;

/** 
 * image_record_observation
 * Link to single/multiple image/movie records in the database
 */
/** OBSOLETED 2013-12-09 
CREATE TABLE image_record_observation (

    id                        INT(10) UNSIGNED NOT NULL,
    image_record_id           INT(11) UNSIGNED NOT NULL,
    
    PRIMARY KEY(id),
    KEY image_record_idx(image_record_id)
    
) COLLATE=utf8_general_ci ENGINE=MyISAM;
*/

/** 
 * unidimensional_observation
