[ensembl-dev] DB Schemas

[Emily Pritchard]

Sent directly to me rather than list:

Hi Emily,

Those PDF's on the website look like they were produced in MySQL 
Workbench - is there any chance of getting the workbench files 
themselves? Particularly the human Variation DB . . .

Thanks

Stuart

On 03/05/2013 12:47, Stuart Meacham wrote:
> Hidden in plain view, eh?
>
> Thanks
>
> Stuart
>
> On 03/05/13 12:39, Emily Pritchard wrote:
>> 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/
>>
>
>
> _______________________________________________
> 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