[go-friends] GO database table to ER

[Chris Mungall]

Hi Zhiliang!

For historic reasons, you have to run the source sql through the 'compiledb' script. Do you already have the sql/ directory checked out from the go-dev project?

./compiledb go-tables-FULL.sql

You can browse the dir here:
http://geneontology.svn.sourceforge.net/viewvc/geneontology/go-dev/trunk/sql/



On Oct 17, 2011, at 8:02 PM, Zhiliang wrote:

> I wish to have an ER digram for the GO database tables so that I can build customized queries more easily.  However my attempts by connecting the MySQL Workbench to a local copy of a GO db, and by importing all SQL scripts ('cat' all into one) into MySQL Workbench, all failed.  I am not sure but wonder is there a different copy of SQL scripts that can be used for this purpose? (e.g. I have successfully use Ensembl SQL scripts to port into MySQL Workbench for ER diagrams).
> 
> I know there is already an ER at the GO site
> http://www.geneontology.org/GO.database.shtml#diagram but I wish to have one in the MySQL Workbench for details.
> 
> Any help will be appreciated.  Thanks in advance!
> 
> Zhiliang
> 
> _______________________________________________
> go-friends mailing list
> go-friends at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/go-friends