[ensembl-dev] core schema pdf

[William Spooner]

Hi Andrea,

The easiest way to generate this yourself is to load a new schema into mysql, convert to innodb;

$ for t in `mysql $DBNAME -N -e "show tables"`; do mysql $DBNAME -N -e "ALTER TABLE $t engine=InnoDB"; done

Then add the foreign keys using ensembl/sql/foreign_keys.sql, and finally use SQL fairy to generate a PDF; 
  http://sqlfairy.sourceforge.net/

Best,

Will


On 25 Mar 2011, at 17:00, Andrea Edwards wrote:

> 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
> Dev at ensembl.org
> http://lists.ensembl.org/mailman/listinfo/dev

--
William Spooner
whs at eaglegenomics.com
http://www.eaglegenomics.com