Ucsc Database Schema Diagram

Question

[sfcarroll]

Is there an entity-relationship or schema diagram of the UCSC (Hg19) database available anywhere?

Answer 1

[Pierre Lindenbaum]

duplicate of

understanding UCSC mysql schema

the schema is available at http://genome-source.cse.ucsc.edu/gitweb/?p=kent.git;a=blob;f=src/hg/makeDb/schema/all.joiner and http://genome-source.cse.ucsc.edu/gitweb/?p=kent.git;a=blob;f=src/hg/makeDb/schema/joiner.doc

[sfcarroll]

Thanks for your quick answer. I was hoping there might something visual like an ERD diagram.

In fact I am trying to search for chromosome start & finish positions from a COSMIC id.

[Pierre Lindenbaum]

it's not possible because most (all ?) the tables DO NOT have a primary key.

[sfcarroll]

Really? That's quite interesting.... I'll have to digest that for a while. Thanks for your answer. I will post a different question.