     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),

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

/** 
 * unidimensional_observation

    external_id                VARCHAR(50),
    date_of_experiment         TIMESTAMP,
    organisation_id            INT(10) UNSIGNED NOT NULL,  
    metadata_combined          TEXT,  
    metadata_group             VARCHAR(50) DEFAULT '',  
    
    PRIMARY KEY(id),
    KEY external_db_idx(db_id),
