[ensembl-dev] DB Schemas

[Laurent Gil]

Hi Stuart,

The MySQL Workbench file of the Ensembl Variation schema 71 is available 
on the CVS (database-schema.mwb):
http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl-variation/schema/?root=ensembl&pathrev=branch-ensembl-71

Cheers,

Laurent

On 07/05/2013 09:13, Emily Pritchard wrote:
> 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/
>