[ensembl-dev] DB Schemas

Emily Pritchard emily at ebi.ac.uk
Fri May 3 12:39:36 BST 2013


Hi Stuart

Links to the different database schema can be found here:
http://www.ensembl.org/info/docs/api/index.html

All the best

Emily

On 03/05/2013 12:27, Stuart Meacham wrote:
> Hi,
>
> Is there a way of visualising the schema for a particular DB? I dumped 
> the latest Human Variation database (excluding data) and imported into 
> MySQL Workbench only to find that there are no foreign keys so it's 
> really quite difficult to understand the links between the various 
> tables. I appreciate there is a performance overhead for foreign key 
> constraints so I wasn't overly surprised but would really appreciate 
> some overview of the DB structure.
>
> Any help greatly appreciated
>
> Thanks
>
> Stuart
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: 
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/

-- 
Dr Emily Pritchard
Ensembl Outreach Officer

EMBL - European Bioinformatics Institute
Wellcome Trust Genome Campus
Hinxton
Cambridge
CB10 1SD
UK





More information about the Dev mailing list