Hello again, Yu, In addition to all.joiner, we do have a partial graphical map. It is only for the tables related to UCSC Genes. You can see it here:
http://genome-test.cse.ucsc.edu/images/knownGeneSchema.gif (Note that this is on our test server, which in general contains a lot of experimental and untested data.) -- Brooke Rhead UCSC Genome Bioinformatics Group On 12/11/08 15:08, Brooke Rhead wrote: > Hello Yu, > > Sorry for the delay in answering your question. The table relationships > for Genome Browser databases are captured in this file in our source tree: > > src/hg/makeDb/schema/all.joiner > > See this link for downloading the source: > http://hgdownload.cse.ucsc.edu/downloads.html#source_downloads > > It is free for academic, nonprofit and personal use. Commercial use > requires a license. > > The file joiner.doc in the same directory as above describes all.joiner > and how to use it. The tool "joinerCheck" can be used to parse the > all.joiner file. Run it without arguments for a usage statement: > > $ joinerCheck > joinerCheck - Parse and check joiner file > usage: > joinerCheck file.joiner > options: > -fields - Check fields in joiner file exist, faster with -fieldListIn > -fieldListOut=file - List all fields in all databases to file. > -fieldListIn=file - Get list of fields from file rather than mysql. > -keys - Validate (foreign) keys. Takes about an hour. > -tableCoverage - Check that all tables are mentioned in joiner file > -dbCoverage - Check that all databases are mentioned in joiner file > -times - Check update times of tables are after tables they depend on > -all - Do all tests: -fields -keys -tableCoverage -dbCoverage -times > -identifier=name - Just validate given identifier. > Note only applies to keys and fields checks. > -database=name - Just validate given database. > Note only applies to keys and times checks. > > > I hope this is helpful. If you have further questions, please write back > to [email protected]. > _______________________________________________ Genome maillist - [email protected] http://www.soe.ucsc.edu/mailman/listinfo/genome
