[ensembl-dev] DB Schemas

[Andy Yates]

Hi

The core schema mwb files are available from CVS and available to download from the website.

http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl-webcode/htdocs/info/docs/api/core/?root=ensembl

Andy

On 7 May 2013, at 09:19, Laurent Gil <lgil at ebi.ac.uk> wrote:

> 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/
>> 
> 
> 
> _______________________________________________
> 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/