<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Thanks very much<br>
<br>
On 28/03/11 09:47, Monika Komorowska wrote:
<blockquote
cite="mid:B67B9836-65C0-47E1-85C3-ABE45164B1AF@ebi.ac.uk"
type="cite">
<pre wrap="">Hi Andrea
I attach pdfs of ensembl core schema.
This page will contain links to the schema from release 62:
<a class="moz-txt-link-freetext" href="http://www.ensembl.org/info/docs/api/core/core_schema.html">http://www.ensembl.org/info/docs/api/core/core_schema.html</a>
Regards</pre>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
Monika
On 25 Mar 2011, at 17:00, Andrea Edwards wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi
Is there a pdf of the ensembl core schema? I can only find one for the variation schema.
If not, can you advise a quick way to find all of the tables linked to a specific table. I can do it in sql but i was wondering if there was any other way quicker way from ensembl
mysql> select distinct TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME IN ('gene_id') and TABLE_SCHEMA = 'homo_sapiens_core_61_37f';
+---------------------------------------+
| TABLE_NAME |
+---------------------------------------+
| alt_allele |
| gene |
| gene_attrib |
| gene_stable_id |
| splicing_event |
| transcript |
| unconventional_transcript_association |
+---------------------------------------+
7 rows in set (0.05 sec)
thanks
_______________________________________________
Dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Dev@ensembl.org">Dev@ensembl.org</a>
<a class="moz-txt-link-freetext" href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a>
</pre>
</blockquote>
<pre wrap="">
Monika Komorowska
EnsEMBL Software Developer
European Bioinformatics Institute (EMBL-EBI)
tel: +44(0) 1233 494 409
</pre>
</blockquote>
<br>
</body>
</html>