 	variation_annotation_id int(10) unsigned not null auto_increment,
 	variation_id int(10) unsigned not null,
 	phenotype_id int(10) unsigned not null,
-	source_id int(10) unsigned not null,
-	study varchar(30) default NULL,
-	study_type set('GWAS'),
+	study_id int(10) unsigned not null,
 	local_study_id int(10) default NULL,
 	associated_gene varchar(255) default NULL,
 	associated_variant_risk_allele varchar(255) default NULL,

/**
@table study

@desc This table contains details of some published studies. Most commonly the studies
      information comes from the DGVa or EGA sources.

@column study_id		Primary key, internal identifier.
@column source_id		Foreign key references to the source table.
@column name				Name of the study. e.g. "EGAS00000000001"
@column description	Description of the study.
@column url					URL to find the study data (http or ftp).
@column study				The pubmed/id or project name associated with this study.

@see source
@see variation_annotation

	primary key (variation_annotation_id),
	key variation_idx(variation_id),
	key phenotype_idx(phenotype_id),
	key study_idx(study_id),
	key local_study_idx (local_study_id)
);

