[ensembl-dev] core schema pdf

[Glenn Proctor]

Hi Andrea

Links to PDFs of the core schema are below (split into 4 images,
otherwise it just becomes too unwieldy).

This page will contain links to the schema from release 62:
http://www.ensembl.org/info/docs/api/core/core_schema.html

Fundamental tables:
http://dl.dropbox.com/u/23033/schema/fundamental_tables_core.pdf

Features and analyses:
http://dl.dropbox.com/u/23033/schema/features_analyses_core.pdf

External references: http://dl.dropbox.com/u/23033/schema/external_refs_core.pdf

ID mapping: http://dl.dropbox.com/u/23033/schema/id_mapping_core.pdf

Thanks to Monika for generating these PDFs.

Glenn.

On Fri, Mar 25, 2011 at 5:00 PM, Andrea Edwards <edwardsa at cs.man.ac.uk> 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
>
>