     external_id               VARCHAR(20) NULL,
     external_db_id            INT(10),
     project_id                INT(10) UNSIGNED NOT NULL,
+    organisation_id           INT(10) UNSIGNED NOT NULL,
     gf_acc                    VARCHAR(20),
     gf_db_id                  INT(10),
     strain_acc                VARCHAR(20),

    description               VARCHAR(200),
    major_version             INT(10) NOT NULL DEFAULT 1,
    minor_version             INT(10) NOT NULL DEFAULT 0,

    PRIMARY KEY (id)
    
) COLLATE=utf8_general_ci ENGINE=MyISAM;

 * An animal sample is a type of sample
 * The discriminative value is on the sample type
 */

CREATE TABLE live_sample (

    id                        INT(10) UNSIGNED NOT NULL,
